Having an issue creating an automation

I’m trying to do something pretty simple but I’m struggling. Long story short, I have one table called ‘accounts’. In that table there’s a column called ‘account strategy’ that relates to another table called ‘account strategy’. It’s linked using the ‘account name’ column.

I created an automation so that any time I create a new row in the accounts table, it will create a new row in the account strategy table using the ‘account name’. I.e. if I create a new Account for Fox Corporation, it will automatically create the row in account strategy for Fox Corporation.

I tried to share screenshots but it says that only new users can add images, so I can’t share photos of the tables. Thoughts?

1 Like

hi @Jordan_Moore , welcome to the community!

did you use the step1 logic in your addRow logic?

that is an often forgotten part.

cheers, christiaan

1 Like

Hi @Jordan_Moore , were you able to solve this?

Like @Christiaan_Huizer said you need to use your step 1 result when the new row gets created in your accounts table an use that on your add rows to your account strategy table.

Let us know if you still need help!

1 Like