3 Replies Latest reply on Dec 22, 2014 7:56 AM by JamesPeragine

    How to Setup Dynamic portal filtering using relationships

    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?