AnsweredAssumed Answered

How to Setup Dynamic portal filtering using relationships

Question asked by JamesPeragine on Dec 21, 2014
Latest reply on Dec 22, 2014 by JamesPeragine

Title

How to Setup Dynamic portal filtering using relationships

Post

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?

 

Outcomes