Hey
I just edited your doc.
- 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.
- 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. - 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