Populate lookup selectbox choice based on reference field

Sriharsha3 · ‎05-18-2020

Hello ,

I have two variables Reference and lookup selectbox both referencing same table.

My requirement is: Both are referencing Business Application table. However the lookup select box field's lookup value field is install_type

How to populate the install_type of selected application on the Select box field.

Eg: Application A install type is Production. So when i select Application A on the reference field, lookup field should populate with Production choice.

Ankur Bawiskar · ‎05-18-2020

Hi Param,

If you still need that to be show and present then please find below suggestions

1) Since you just want to auto-populate Install Type based on application selected; please use single line text variable

2) use onchange on Reference variable to populate it

3) set it read-only from that script

Sample Client Script:

Note: Ensure you use proper variable name for

1) business name reference variable

2) install_type variable

3) install_type field from business app table

function onChange(control, oldValue, newValue, isLoading) {
   if (isLoading) {
// always set as read-only
g_form.setReadOnly('install_type', true;)

      return;
   }

//Type appropriate comment here, and begin script below

if(newValue == ''){
g_form.clearValue('install_type');
}

var ref = g_form.getReference('business_app', callBackMethod);
   
}

function callBackMethod(ref){
if(ref.install_type != ''){
g_form.setValue('install_type', ref.install_type);
}
}

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Jaspal Singh · ‎05-18-2020

Hi Param,

In the selectbox field you can pass reference qualifier as below.

javascript: 'application='+current.field_name;

javascript: 'application='+current.variables.variable_name;

Considering application is the field name in Business Application table that has a relation with Install type.

Sriharsha3 · ‎05-18-2020

Hello ,

I tried this and it seems to not work.

Please note im also displaying install type in first reference variable as a second column.

Ankur Bawiskar · ‎05-18-2020

Hi,

Any reason to show identical fields i.e. both referring to same table?

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Sriharsha3 · ‎05-18-2020

Hi Ankur,

The first variable shows the Application Name on the first field.

The second variable should show the selected application's install_type . ( which is lookup select box of install type in Business application table)