Solved: Re: Add a new row to another table using values fr...

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

Lynn

Hi @Peter_S1
Are you adding Key column? Do you have a screen shot of your Action?

Peter_S1

Yes, I added a key column. The key just gets replaced in row 2 with each new action trigger. Cant upload more than one image.

Peter_S1

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()

j62

is it possible on action run to prompt use to choose the [Status] column's value from list, if that column were a ref to a Master Statuses table that listed all the status options?

Peter_S1

Lynn

Sorry I am confused. What is the last scren shot? I dont think you need a workflow, just the action. Someone else may be able to help.

Matt_Myers

I had the same exact thing happen and it was because my KEY value was NOT unique with each new insert. Are you sure you’re passing a unique value in the [key] field each time?

Peter_S1

Thank you, all. I have added the uniqueid() to the Onboarding tasks table but the issue is the same. With each addition the data in row two just gets overwritten. Does the key have to be in first column maybe? For both tables? Is that what’s causing the issue?

Peter_S1

Was able to resolve. After adding the uniqueid() column I needed to also tick the checkbox for this column as Key. After that it started adding new rows. Thank you, all!

Steve

Well done!

Lynn

@Peter_S1
Great.

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