I have a field (FIELD1) defined as Text,Editable.
Another field (FIELD2) defined as Text,Computed,Allow Multiple Values,Hidden.
And Another field (LOCATION) defined as Numeric,Hidden
What I want to do is update FIELD2 based on the value in FIELD1 slotted with the value of LOCATION.
So, If Field1 = AAAA and Location = 1, then FIELD2 should be AAAA, Field1 is blanked and Location set to 2, if the user puts BBBB into Field1 then Field2 should be AAAA;BBBB.
I have the formula to update the field in a hotspot but the field will not update into the correct slot, it keeps getting added to the end of Field1.
The formula I am using in the hotspot is:
@SetField(@Subset("Field2";Location);Field2 + Field1 + ";");
FIELD Field1 := "";
FIELD Location := Location + 1;
Anyone have any ideas?