AnsweredAssumed Answered

Multi-purpose Valuelist

Question asked by PJSpark on Jan 19, 2015
Latest reply on Jan 20, 2015 by PJSpark


Multi-purpose Valuelist



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?