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 Storage location
The buttons are
Save new status
Save new location
Save new performer
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!