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?