How to Setup Dynamic portal filtering using relationships
I have a portal setup with a global sort field on the parent side and a stored calculation field on the child side. I have different filter variations that I want to create on several tabs, however, I don't want to set up a different table occurrence for every one of these by creating another stored calculation field for each TO.
Because the calculation can not reference a global field my options seem limited. If I was allowed to use a Global Field I could use the Evaluate function to evaluate a global fields contents. I tried setting up a script trigger that assigned a numeric value to a Global Variable and then used a Case Function in my stored calculation for each Global Variable however this doesn't seem to be working.
Is the a way to do this?