Reference Field dependant on another Reference Field

MStritt · ‎07-03-2019

Hello,

I would like to have one reference field dependent on another reference field on our case form. On our case form, I would like the 'Component' reference field to only show values that are related to the 'Product Name' field. In the screenshot below, when I click on the 'Component' lookup, I only want to see the values related to Product Name 'Digital PIN'.

Michael Ritchie · ‎07-03-2019

You need to include the "javascript" prefix to evaluate the current value of u_product_name. The following should work as your reference qualfier:

javascript:"u_component=" + current.u_product_name

View solution in original post

MStritt · ‎07-03-2019

MStritt · ‎07-03-2019

Got it working. Added Product Name field under Dependent Field.

Michael Ritchie · ‎07-03-2019

Yes that is certainly another way to accomplish this too. Out of the box the task assigned_to is dependent on the assignment_group. The method I described is useful too especially if you have multiple fields you need to use for the query such as an active flag on top of product name.

Omnia Ameer · ‎07-12-2023

Hello Michael,

I have a question so if I need to change the first field value and then I need the second list field changes immediately so what should I do as in this case I have to use client script but how to set the second list field.

Thanks

Latoya · ‎05-28-2020

I changed the type to a string using the label and that worked.