Hello
I want to update the fields of Test1 and Test2 of an already existing record in the form 'Form1' when the same input of Scan is submitted.
So far the existing record is update but a new record is created as well.
Is there a way to stop the creation of a new record but only update the already existing one?
This is how far I got with the script on success:
Variable1 = Form1[Scan == input.Scan];
Variable1.Test1 = input.Test1;
Variable1.Test2 = input.Test2;