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

[Jeff_Hager]

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.

Populating multipls tabs from one tab in google-sheet

I have a registration form that adds a new row into tab=Order_Form with Company Info and Contact info Email. Based on such received data (the system will generate a unique Client_Id). I like to Add a new row to tab=companies to add this new company info & tag it with this new Client_Id. Add a new row to tab=contacts to add this new contact info & tag it with this new Client_Id. Add a new row to tab=Users to activate this contact as a user & tag it with this new Client_Id. Add 10 rows to t…