- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2021 10:41 AM
In our instance, I filter a reference field based on another reference field by doing that following:
You could use an advanced Reference Qualifier on the reference field. Here is our example:
"SOW Number" - Current reference field I am updating the Reference Qual on
"current.variables.customer" - form field reference to custom table
"u_client" - reference field on my custom table
Below is my Advanced Reference Qualifier on the "SOW Number" field.
javascript:'u_client='+current.variables.customer+'^u_active=true';
So basically this filters the "SOW Number" reference field by the "Customer" field which is also a reference field. It only shows SOW numbers associated with the customer chosen that are active.
Please mark this response as correct and/or helpful if it assisted you with your question.
Steven