I am looking to transfer a value from individual portal rows to a checkbox field which contains all the possible values.
The portal value is the Space ID which is a drop down list with the same values as the checkbox.
The script is triggered when the Transaction field is changed to "In".
My problem is as a new portal row is added and I trigger the script, the existing value in the checkbox is replaced by the new value. Whereas I need another value added to the checkbox.
Likewise when Transaction field is changed to "Out" then the Space ID value in the checkbox would be removed.
I have attached images for the layout and script.
Many thanks for your help,