Populate reference field values based on the choice field

[User351756]

Hi All,

I have a table Budget where there is
1. A choice field Budget type - Opex, Capex
2. Reference field HFM (Referring to HFm company table) has a field Budget type as "Opex, Capex and Both"

Now when user selects Opex on Budget table, HFM records with Budget type 'Opex and Both' should populate

And, when user selects Capex on Budget table, HFM records with Budget type 'Capex and Both' from HFM should populate.

[Pullela Sony1]

Hi ,

Please refer below link do changes accordingly it might help you:

https://www.servicenow.com/community/itsm-forum/auto-populate-reference-field-with-value-based-on-6-...

I hope this will help you.

If it works then kindly mark the answer as correct .

Thank you,
Sony

[User351756]

Hi Sony,

It din't work. Reference field is returning all the records irrespective of the Budget type I selected.

Thanks.

[Pullela Sony1]

Can you please send your code here

[User351756 · Accepted solution]

Hi Sony,

I have tried using Reference Qualifier and it worked.

javascript: 'u_budget_type=Both^ORu_budget_type=' + current.u_budget_type;

Thanks.