# In Action, can we add a new row in parent sheet, get the id of the newly inserted data and insert that into a new child sheet? **URL:** \ **Category:** Ask for Help\ **Created:** [April 20, 2022, 6:03am UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931 "2022-04-20T06:03:47Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![remoteworker.id](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/remoteworker.id/32/36396_2.png) [@remoteworker.id](https://community.glideapps.com/u/remoteworker.id)\ **Post date:** [April 20, 2022, 6:03am UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/1 "2022-04-20T06:03:47Z")
Have a look here: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8ea42f604b8e97c245ee99c5aea5d9d954dbbf2d.jpeg) I need to insert row into Event and later several rows into Event Menu Umum … is this possible? The child sheet should get the parent row id here ---
**Author:** ![resepsionis\_ganteng](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/resepsionis_ganteng/32/39081_2.png) [@resepsionis\_ganteng](https://community.glideapps.com/u/resepsionis_ganteng)\ **Post date:** [April 20, 2022, 6:17am UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/2 "2022-04-20T06:17:35Z")
sekali klik nambah 2 row di sheet yang berbeda? ---
**Author:** ![remoteworker.id](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/remoteworker.id/32/36396_2.png) [@remoteworker.id](https://community.glideapps.com/u/remoteworker.id)\ **Post date:** [April 20, 2022, 6:19am UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/3 "2022-04-20T06:19:03Z")
yes. English please 😃 If only adding several rows, that’s fine. But if I want to capture row id from another newly inserted row… that will be … no idea how ---
**Author:** ![resepsionis\_ganteng](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/resepsionis_ganteng/32/39081_2.png) [@resepsionis\_ganteng](https://community.glideapps.com/u/resepsionis_ganteng)\ **Post date:** [April 20, 2022, 6:21am UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/4 "2022-04-20T06:21:13Z")
you can, just try it. but the data entered is not dynamic data, but data that has been inputted in the action settings. let me know if my statement is wrong ---
**Author:** ![remoteworker.id](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/remoteworker.id/32/36396_2.png) [@remoteworker.id](https://community.glideapps.com/u/remoteworker.id)\ **Post date:** [April 20, 2022, 6:59am UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/5 "2022-04-20T06:59:31Z")
that’s the problem. It need to be dynamic: newly inserted data ---
**Author:** ![christoph](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christoph/32/22794_2.png) [@christoph](https://community.glideapps.com/u/christoph)\ **Post date:** [April 20, 2022, 11:10am UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/6 "2022-04-20T11:10:50Z")
You could first create a unique ID into a user specific column, insert that ID into the new row of your parent sheet, then have a relation looking for that ID and retrieve the Row ID through a lookup. ---
**Author:** ![Benjamin\_Sabbah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_sabbah/32/19379_2.png) [@Benjamin\_Sabbah](https://community.glideapps.com/u/Benjamin_Sabbah)\ **Post date:** [November 6, 2024, 1:35pm UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/7 "2024-11-06T13:35:44Z")
Basically I have the same problem. How to solve this ? ---
**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:** [November 6, 2024, 2:05pm UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/8 "2024-11-06T14:05:47Z")
It’s a built in feature now. When a row is added you can write the rowid to any column in the parent table or user profile, and then use it for subsequent actions. ![Screenshot_20241106-080416](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/7/17b11552a110c1a6e3d8eda832fec81f7b83da36.png) ---
**Author:** ![Benjamin\_Sabbah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_sabbah/32/19379_2.png) [@Benjamin\_Sabbah](https://community.glideapps.com/u/Benjamin_Sabbah)\ **Post date:** [November 6, 2024, 2:15pm UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/9 "2024-11-06T14:15:19Z")
It does not solve my issue since I need to store the row id of a parent row in 6 child rows. When submitting a form =\> row id of the parent row is created =\> I need to add 6 more rows to another sheet with this parent row ID stored ---
**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:** [November 6, 2024, 2:17pm UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/10 "2024-11-06T14:17:31Z")
I think that use case was largely the reason the feature was added. You write that parent RowID somewhere, and then refer to it in all of your other Add Row actions. ---
**Author:** ![Benjamin\_Sabbah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_sabbah/32/19379_2.png) [@Benjamin\_Sabbah](https://community.glideapps.com/u/Benjamin_Sabbah)\ **Post date:** [November 6, 2024, 2:19pm UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/11 "2024-11-06T14:19:32Z")
Does it mean that I have to leave the form component to create the parent row and rather doing it with the add a row action ? Because I don’t see this feature in a form. ---
**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:** [November 6, 2024, 2:31pm UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/12 "2024-11-06T14:31:23Z")
Ah, yeah that seems to be missing from forms. I guess you could roll your own custom form with a separate single row table, some user specific columns, a detail screen sourced from that table, and a submit button that calls a series of actions. ---
**Author:** ![Benjamin\_Sabbah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_sabbah/32/19379_2.png) [@Benjamin\_Sabbah](https://community.glideapps.com/u/Benjamin_Sabbah)\ **Post date:** [November 6, 2024, 2:32pm UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/13 "2024-11-06T14:32:31Z")
Yes seems that’s the only way. Thanks. ---
**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:** [November 6, 2024, 11:30pm UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/14 "2024-11-06T23:30:25Z")
If you’re adding those 6 rows using 6 add row actions, I guess you can use the on-submit action of the form and be able to reference the parent row’s ID. ---
**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:** [November 6, 2024, 11:44pm UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/15 "2024-11-06T23:44:15Z")
@ThinhDinh would you recommend a Wait action before those additional rows are added? ---
**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:** [November 6, 2024, 11:45pm UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/16 "2024-11-06T23:45:03Z")
Maybe 1-2 seconds, but I don’t think I have ever had problems with that approach before. ---
**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:** [November 6, 2024, 11:48pm UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/17 "2024-11-06T23:48:04Z")
I’m still leary about using On Submit actions that refer to a row that was just added, so it’s interesting to know what everyone’s experience has been. ---
**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:** [November 6, 2024, 11:49pm UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/18 "2024-11-06T23:49:09Z")
Most of my problems with that on-submit action is about set columns, I would still add a wait to be sure, but I tried referring the rowID like I said above and it worked just fine. ---
**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:** [November 6, 2024, 11:53pm UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/19 "2024-11-06T23:53:36Z")
Good to know. Thanks! ---
**Author:** ![Benjamin\_Sabbah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_sabbah/32/19379_2.png) [@Benjamin\_Sabbah](https://community.glideapps.com/u/Benjamin_Sabbah)\ **Post date:** [November 7, 2024, 6:49am UTC](https://community.glideapps.com/t/in-action-can-we-add-a-new-row-in-parent-sheet-get-the-id-of-the-newly-inserted-data-and-insert-that-into-a-new-child-sheet/40931/20 "2024-11-07T06:49:04Z")
Working fine, thanks a lot !