# Transferring data from one table to another

**URL:** <https://community.glideapps.com/t/transferring-data-from-one-table-to-another/37338>\
**Category:** Ask for Help\
**Created:** [January 18, 2022, 9:55am UTC](https://community.glideapps.com/t/transferring-data-from-one-table-to-another/37338 "2022-01-18T09:55:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![evk](https://avatars.discourse-cdn.com/v4/letter/e/6a8cbe/32.png) [@evk](https://community.glideapps.com/u/evk)\
**Post date:** [January 18, 2022, 9:55am UTC](https://community.glideapps.com/t/transferring-data-from-one-table-to-another/37338/1 "2022-01-18T09:55:20Z")

</div>

Colleagues, good afternoon everyone! I use internal Glide tables. There is a current table with shop orders, which has user-specific columns. Moreover, there can be more than one order (read lines). After placing an order for an action or form, you need to transfer these terms to a new table and remove these orders from the current one. Recommend the correct option

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [January 18, 2022, 9:59am UTC](https://community.glideapps.com/t/transferring-data-from-one-table-to-another/37338/2 "2022-01-18T09:59:24Z")

</div>

a very complicated task, to set multiple rows, you need help from Google Scripts… so I would recommend duplicating order in GS

---

<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:** [January 19, 2022, 12:00am UTC](https://community.glideapps.com/t/transferring-data-from-one-table-to-another/37338/3 "2022-01-19T00:00:19Z")

</div>

Let’s call your first table “Cart” and your second table “Orders”.

I assume you mean when there are multiple items in a user’s cart and they press a button, you want to represent those rows in the “Orders” table?

What I usually do, assuming the user is already logged in:

- Have a rowID column for the “Cart” table.
- Have a “cartIDs” column in the “Orders” table, which will be used to house the rowIDs from the “Cart” table.
- Construct a joined list column in the “Cart” table, joining all the “cartIDs” in the Orders table.
- Have an If Then Else column, if the cart row’s email is not the signed-in user then empty, if the rowID is included in the joined list in step 3 then empty, else return the rowID.
- Have a second joined list column in the “Cart” table, joining all values in the If Then Else column above. This will be your “unsubmitted IDs”.
- Finally, when the user presses the “Order” button or something like that, write the second joined list column to the “Orders” table.

To be clear, I don’t clear anything from the “Cart” table. I need those to be individually referenced and editable later on.

Hope it helps your case.