Thanks Raymond - we’re on a similar track. The part we’re missing is when a user sets a filter value on the model that has the filters, how do we pass the value to the conditions on the other models?
Model 1
Condition (Always On): Customer_Segment = null
(Auto) Filter: Sales_Rep
Model 2
Condition (Default Inactive): Customer_Segment = 2
Condition: __autofilter__Sales_Rep__c
The models load properly with the applicable conditions applied. When the user selects a Sales Rep from Model 1, two actions are fired. A JS snippet to make the condition on Model 2 active and set the condition value, and one to reload the models.
Based on one of the links in my original post, it appears JS is the only way to do this. If that’s true, can someone provide the mechanism to pass the value of Sales_Rep from Model 1 to the corresponding condition in Model 2.
Thanks again.
