Hello Everyone,
I followed the steps in this tutorial; however, I am having some trouble with the [Unique Row ID] Column.
In the picture above, row one should be Job_ID 2 and row two should be Job_ID 3. Each time i test filling out a form the Job_ID in the first row increases by one increment and no Job_ID is assigned to the new row.
Below are screenshots of the automation. I would appreciate any help!
Looks like just a minor tweak Try updating your formula in the "write to" field to: =[Job _ID]
The way you have it set up now would overwrite that column of the first row in the table. By specifying the [Job _ID] of the new row, the automation will instead write to that column of the new row that will be added.
Let us know if that helps and if you have any other questions.
Hello Alyssa,
Thank you for your response!
I made the change as suggested and the same issue appears to be occurring.
The two automations in the red boxes now do the same thing, this seems a bit redundant, so I will delete one of them and test the automation again.
**Edited, that also did not have the desired effect. Additionally, I am noticing that the numbers in ID-Primary[ID Primary] and Intake[Job _ID] are no longer changing on form submission.
To clarify, you only need to change the "write to" field in your first screenshot from =Intake[Job _ID] to =[Job _ID] (remove the table name "Intake" from the formula).
The other automation is still needed and did not need to be changed.
I see what's going on now. You want your formula that writes to the [Job _ID] field to be a part of the "Add Row" action (not an overwrite action; the overwrite action is the second one that updates the counter). In an Add Row action, you are able to specify the column it is going to be writing to.