AnsweredAssumed Answered

Script help

Question asked by RandyHandley on Jul 9, 2017
Latest reply on Jul 10, 2017 by RandyHandley

I have three fields that I am using to change the status of inventory items.


I have 4 buttons that go along with them to save the changes to selected records.


The fields are:

Change status

Change Storage location

change Performer


The buttons are

Save new status

Save new location

Save new performer

Save all


I am trying to write a script for the save all button.

Currently I have a table called change status which where the change status,location, and performer can be selected from.


The scripts that i have written currently use set variable and set table to copy/paste which works great.


What I would like to achieve with the save all script is that it will save all three fields to the selected records.  However with how I have it now when one of those fields is empty it also empties the destination record.  How do I get it to not change the destination record if the change field in empty?  I have used the ISempty function but I am not certain if there is a better method.

Any advice would be a great help and much appreciated!