Form Submission to edit or modify fields in an existing row, rather than create a new row

Hey

I just edited your doc.

  1. In the first automation step, configure it to trigger when a new form is submitted in the temporary table:
  • The key part is that you can access the form values using Step 1 Result.
  1. In step 3, configure the action to “Add or Modify” and set a filter. In this case, I set the filter to match the same event name. I had to use the Trim() formula to remove any whitespace at the end of the event name. If the filter formula matches, the row will be updated; otherwise, a new row will be added.
  2. In the subsequent configurations, simply match the columns from both tables. (I matched three columns as an example, but you can easily map the rest.)

Best regards
Arnhold

2 Likes