Solved: Add a new row to another table using values from t... - Page 2

Peter_S1 · 03-21-2021 05:05 PM

I would like to use the add a new row to another table using values from this row action to create a new row in a table. The action works but it doesn’t create a new row like the name of the action suggests, it just overwrites an existing row (row 2) every time the action is triggered. Can someone please advise on how the action can look for the last row in the table and create a new row right after?

Suvrutt_Gurjar

As @Lynn and @Matt_Myers have hinted in the right direction, you seem to be setting the [Key] of the “other” table (Onboarding Table) to the key of the “Driver Onboarding” table.

As such, it sounds that the added row is getting overwritten because the key is getting overwritten from the 'Driver Onboarding" table. You may wish to set a unique value in the action configuration for the key column of the “Onboarding Tasks” table such as
Key = UNIQUEID()

View solution in original post

Add a new row to another table using values from this row