# When adding an item, automatically add Row-ID to another table

**URL:** <https://community.glideapps.com/t/when-adding-an-item-automatically-add-row-id-to-another-table/58428>\
**Category:** Ask for Help\
**Created:** [February 24, 2023, 1:02pm UTC](https://community.glideapps.com/t/when-adding-an-item-automatically-add-row-id-to-another-table/58428 "2023-02-24T13:02:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![tzatti](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tzatti/32/52422_2.png) [@tzatti](https://community.glideapps.com/u/tzatti)\
**Post date:** [February 24, 2023, 1:02pm UTC](https://community.glideapps.com/t/when-adding-an-item-automatically-add-row-id-to-another-table/58428/1 "2023-02-24T13:02:20Z")

</div>

Hi community,

I’m building a CRM where I have project data and financial data for projects in two separate tables. Reason for that is that I want only a subset of my users to have access to financial data.  
The finances table has a project\_id column, which refers to a project’s row ID.

What I’m trying to achieve is that whenever I add a new project, I want to automatically make a new entry in my finances table, containing the row ID of the newly created project.

Is there a way to do that automatically?

---

<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:** [February 24, 2023, 1:49pm UTC](https://community.glideapps.com/t/when-adding-an-item-automatically-add-row-id-to-another-table/58428/2 "2023-02-24T13:49:27Z")

</div>

You should be able to do that with an on-submit action to write a new row to the Finances table, assuming you’re using a form to populate a new project.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [June 10, 2024, 2:10pm UTC](https://community.glideapps.com/t/when-adding-an-item-automatically-add-row-id-to-another-table/58428/3 "2024-06-10T14:10:37Z")

</div>

If using a custom form, not possible.

Vote here: [[REQUEST] Return RowID of newly created row from an Add Row action](https://community.glideapps.com/t/request-return-rowid-of-newly-created-row-from-an-add-row-action/74020)