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

**URL:** https://community.glideapps.com/t/creating-one-row-in-one-table-creates-another-row-in-another-table/14319
**Category:** Ask for Help
**Created:** [August 21, 2020, 1:51pm UTC](https://community.glideapps.com/t/creating-one-row-in-one-table-creates-another-row-in-another-table/14319 "2020-08-21T13:51:03Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![AwesomeAzrien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/awesomeazrien/32/7875_2.png) [@AwesomeAzrien](https://community.glideapps.com/u/AwesomeAzrien)
#### Post date: [August 21, 2020, 1:51pm UTC](https://community.glideapps.com/t/creating-one-row-in-one-table-creates-another-row-in-another-table/14319/1 "2020-08-21T13:51:03Z")

</div>

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

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 21, 2020, 1:53pm UTC](https://community.glideapps.com/t/creating-one-row-in-one-table-creates-another-row-in-another-table/14319/2 "2020-08-21T13:53:28Z")

</div>

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

---

<div class="post-metadata">

### Author: ![AwesomeAzrien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/awesomeazrien/32/7875_2.png) [@AwesomeAzrien](https://community.glideapps.com/u/AwesomeAzrien)
#### Post date: [August 21, 2020, 1:58pm UTC](https://community.glideapps.com/t/creating-one-row-in-one-table-creates-another-row-in-another-table/14319/3 "2020-08-21T13:58:50Z")

</div>

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

---

<div class="post-metadata">

### Author: ![AwesomeAzrien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/awesomeazrien/32/7875_2.png) [@AwesomeAzrien](https://community.glideapps.com/u/AwesomeAzrien)
#### Post date: [August 21, 2020, 2:05pm UTC](https://community.glideapps.com/t/creating-one-row-in-one-table-creates-another-row-in-another-table/14319/4 "2020-08-21T14:05:19Z")

</div>

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

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 21, 2020, 2:34pm UTC](https://community.glideapps.com/t/creating-one-row-in-one-table-creates-another-row-in-another-table/14319/5 "2020-08-21T14:34:47Z")

</div>

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

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 25, 2020, 2:22am UTC](https://community.glideapps.com/t/creating-one-row-in-one-table-creates-another-row-in-another-table/14319/6 "2020-08-25T02:22:33Z")

</div>

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](https://community.glideapps.com/t/populating-multipls-tabs-from-one-tab-in-google-sheet/11716):
>
> 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…
