Hi, all
I'm looking for a way to filter the available options in a picklist (optionset) field based upon the value of another lookup field?
I found most of information are all about configuration for two lookup fields or javascript code for dependent optionsets.
Is there any solution to filter a picklist field based on a lookup field?
Thank you for your help.
*This post is locked for comments
There is not an easy solution, like there would be the other way around using pre-filter.
If you wanted to filter your lookup based on an optionset, you could use pre-filtering to filter the data in your optionset
In your case you would need to add an onChange event to the lookup and check for the value in the lookup (id or name).
From there you can do a switch statement to decide what to do with the picklist in each one of these scenarios.
I would recommend to see if you can replace the picklist with another lookup, or replace the first lookup with a picklist.
Hope this helps. If you have further details that can help us assist you please provide example of what you are trying to achieve, and why not use two lookups or option set as first field and lookup as second.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (