Populate lookup selectbox choice based on reference field

Sriharsha3
Tera Contributor

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.

1 ACCEPTED SOLUTION

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

16 REPLIES 16

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

Vishwa Prakash
Kilo Expert

Hi Param,

I have found a question related to your requirement on the community. Although the user is trying to populate a reference field with info from a lookup select box. It might be helpful.

https://community.servicenow.com/community?id=community_question&sys_id=2f55b6d9dbc6afc0656a5583ca96...

Please mark correct and helpful if this helps.

Thanks