question Look-up record from GlideModalForm in Community Central forum

Look-up record from GlideModalForm

JGerrity — Tue, 12 Nov 2024 17:58:27 GMT

Hello Community,

I am trying to create a UI Action that uses a GlideModalForm to display an asset from the alm_hardware or alm_asset table and allow updates to that asset.

My question is how to you take the input value from the modal and display the particular record in the form?

I can do the pop-up, but I can't load a specific asset into the form. How is this done? Do you use the setPreference('sysparam_query') method and if so, what is the query value for alm_hardware.asset_tag?

My code so far:

Thank you!

Re: Look-up record from GlideModalForm

JGerrity — Wed, 13 Nov 2024 14:29:55 GMT

Thought I'd update myself.

Thanks to @ericgilmore for posting something that made me think in the right direction.

We need to find the sys_ID of the record from the modal prompt: (value is the variable name of the prior GlideModal"glide_prompt" I call earlier in below.)

var gr = new GlideRecord('alm_asset'); gr.addQuery('asset_tag', value); gr.query(); if (gr.next()) { var aTag = gr.sys_id; }

Then you can use .setSysID to set the sys_ID and refer to that particular record:

var af= new GlideModalForm('Update Asset','alm_asset'); af.setSysID(aTag); af.setPreference('alm_asset.install_status',1); //set state to in use af.setPreference('alm_asset.assigned_to', currentUser); af.render();

This now works and my GlideModalForm refers to the specific asset_tag. Thanks Eric!

Now I'm trying to set some field values in advance of the loaded asset form and I thought .setPreference was the way to achieve this, but it's not working...

af.setPreference('alm_asset.install_status',1); //set state to in use af.setPreference('alm_asset.assigned_to', currentUser);

I've tried .setPreference('install_status',1) and 'state' but to no avail.

Thoughts anyone?
Cheers