Filter drop down reference field after changing dependency field value

marclindsay
Tera Guru

When displaying a Reference Field C as a drop down, how can I get the values to be filtered based on Fields A and B ?

I have 3 Reference fields. Field C values are dependent on what is chosen for Field A and B. I have created a Reference Qualifier to handle the filter for Field C. When changing the values of Field A and/or B, Field C automatically (without pressing Save/Update button) shows the correct new values based on these Fields A and B. All work great, as shown below. 

Now if I change Reference Field C to be a drop down. 

Now when I change the values for Field A and Field B, Field C (still reference field) does not refresh automatically (without pressing Save/Update button) with a new list of Values. 

When displaying a Reference Field C as a drop down, how can I get the values to be filtered / refresh automatically based on values selected for Fields A and B ?

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

I would recommend keeping field C as reference only and not drop down.

Reason being if the table is huge then it won't be a good user experience and user might have to scroll down to select the value.

Also advanced ref qualifier won't work on drop down field as per my understanding.

Regards
Ankur

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

View solution in original post

6 REPLIES 6

@marclindsay 

Hope you are doing good.

Did my reply answer your question?

If my response helped please close the thread by marking appropriate response as correct so that it benefits future readers.

Regards
Ankur

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

Asep
Tera Contributor

Hi @marclindsay 

 

this post is exacly im looking for but, cannot see attached screenshoot

Asep_0-1684220806651.png

can you re upload or share the example please? Thanks!