The CreatorCon Call for Content is officially open! Get started here.

List Reference Field dependant on another Reference Field

Omnia Ameer
Tera Contributor

Hello,

 

I would like to have one list reference field dependent on another reference field . I would like the 'Component' reference field to only show values that are related to the 'Product Name' so when I click on the 'Component' lookup, I only want to see the values related to Product Name which I selected immediately so I think this can be done using client script but how can I set the list Reference Field values??

1 ACCEPTED SOLUTION

If this is in the platform then you can use JavaScript in your advanced reference qualifier and the “current” object.

 

javascript: “u_product_name=“ + current.u_product_name

View solution in original post

11 REPLIES 11

@Mike Rakvica1 this dosn't work as it gets the value saved in the form not the value i just change without saving it.please check my screenshottest.png

Is there an "Application" field on the table "Groups" is referencing?
What is the field name on this table, and what is your reference qualifier set to?

Using the current object in reference qualifiers does reflect changes on the current form. I use this everyday.

@Mike Rakvica1  

No there's no "Application field in the Groups table but there's a field called "Parent" the value of it is "Parent + ApplicationName" for example : if the Application = "EasyTickt" so the Parent = "Parent EasyTicket" so i query using( u_groups= "Parent.namelike" + u_application).

When i'm using in the refernce qual the current object it gets the value saved in the xml not the value i just added in the form.

Thank you @Mike Rakvica1  it works by using current

Ankur Bawiskar
Tera Patron
Tera Patron

@Omnia Ameer 

the 2nd field will filter only based on 1st

Can you share screenshots of what you configured and what's not working?

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