1 Reply Latest reply on Mar 17, 2014 7:18 AM by philmodjunk

    Auto Update Value List in Script based on User Field Entry

    garonson

      Title

      Auto Update Value List in Script based on User Field Entry

      Post

           I want to allow the user to enter a value in a form.  Then I want to trigger a script that will take what the user entered, check if already in the assigned value list and if it is not there, add the user entered value to the assigned value list.  Suggestions please.

        • 1. Re: Auto Update Value List in Script based on User Field Entry
          philmodjunk

               Make sure that you set up a value list with the "use values from a field" option. Your layout and script can control whether the user's input adds a new record to a table of such values. In fact, if a second record with the same value is accidentally added to that field, it still will not appear twice in the value list.

               FilterValues with ValueListItems are two functions that can be used to check and see if a new value is already in the list.