Updating a reference type variable

Anu_Arv · ‎02-12-2025

I have the below variable in a catalog item called from_division.

This variable is auto- populated

I have another variable of type Yes/No called ABC _Employee. If ABC_Employee is yes, then I want to update the from_division variable to a specific value of "ABC" from the department table. What is the best approach?

Ankur Bawiskar · ‎02-13-2025

@Anu_Arv

if you know the department sysId then simply hard-code but don't use GlideRecord

For best practice, story that sysId in system property and use GlideAjax to get that and then set in client script

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading) {
        return;
    }

    if (newValue == 'Yes')
        g_form.setValue('from_division', 'sysId');
    else
        g_form.clearValue('from_division');

}

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

View solution in original post

Dr Atul G- LNG · ‎02-13-2025

Hi @Anu_Arv

Use the onchange client script and set the value, it's best one.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Anu_Arv · ‎02-13-2025

@Dr Atul G- LNG I tried using an onchange client script but didn't seem to work. Can you take a look and let me know if you see any issues with my script? It doesn't seem to update the value when the value is set to Yes.

Dr Atul G- LNG · ‎02-13-2025

@AshishKM need help here.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

AshishKM · ‎02-13-2025

@Anu_Arv

glide query returing any record ?

Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution