1 Reply Latest reply on Jan 20, 2015 1:55 PM by PJSpark

    Multi-purpose Valuelist

    PJSpark

      Title

      Multi-purpose Valuelist

      Post

      Hello,

      I've made a valuelist based on a year field in one table and restricted its values by a second TO based on a global field that contains an ID. What this does is gives a limited year valuelist depending on what ID I want to display. And this all works well. But what I was also hoping for was when I clear the global ID field, I wanted the year valuelist to display all the years from all the records. To that end, I use a script to create a list of all the ID's and place them in that global ID field, but it doesn't return any records when I do that. I'm quite certain that this works when using as a portal, so I'm surprised it's not working as a valuelist. Does anyone have any thoughts for something like this?

      Thanks