Creating one row in one table creates another row in another table

I’m looking to use the creation of one row to create another row in a separate table. Any suggestions?

I suppose you can use Zapier to trigger creating a row when another row is created.

I tried this, but it returns Sample Value for some reason

Well correction, it returns the data of the prior row instead of the new row.

I mean you should trigger it using your Sheets solely, instead of Glide. Sounds like you’re using Glide action for it?

You could use a formula to duplicate the data into another sheet, but that can cause issues if you add additional columns to the second sheet. Also some ideas here if you want to do this with scripting. It’s a little more work, but prevents issues by only adding new rows to the other sheets. Deletes or resorting won’t affect anything in the second sheet.

1 Like