12 Replies Latest reply: Jan 17, 2014 3:18 PM by Jeremiah Kurpat RSS

    Set field from variable

      I want to save the selections in a field upon entering sheet1.  Then I want to manually change the selections in that field.  Then upon leaving sheet1 I want to restore the original selections that I saved.

       

      I tried this by GetFieldSelections and storing the result in a variable.  These are years by the way.  This results in a comma separated list.  Then I change the years to what is appropriate for Sheet1.  Then when I leave sheet1 I want to put the original list of years that I saved back into the field.  I tried doing this by taking the comma separated list, adding leading and trailing parentheses and replaced the commas with pipes.

       

      This doesn't work.  Does anyone have any suggestions?  Maybe a better way to be able to restore the values?