- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-12-2023 10:34 AM
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??
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-12-2023 07:18 PM - edited 07-12-2023 07:20 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-13-2023 05:18 AM
@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 screenshot
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-13-2023 05:24 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-13-2023 06:07 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-13-2023 06:52 AM
Thank you @Mike Rakvica1 it works by using current
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-13-2023 02:36 AM
the 2nd field will filter only based on 1st
Can you share screenshots of what you configured and what's not working?
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader