# Send Multiple Items to Another Sheet **URL:** \ **Category:** Feature Requests\ **Created:** [January 2, 2021, 7:42pm UTC](https://community.glideapps.com/t/send-multiple-items-to-another-sheet/20627 "2021-01-02T19:42:08Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![al3xrods](https://avatars.discourse-cdn.com/v4/letter/a/b9e5f3/32.png) [@al3xrods](https://community.glideapps.com/u/al3xrods)\ **Post date:** [January 2, 2021, 7:42pm UTC](https://community.glideapps.com/t/send-multiple-items-to-another-sheet/20627/1 "2021-01-02T19:42:08Z")
Hi ! I have been trying to send more than 1 item from the CART SHEET (ENVIADO AL CARRITO) to the CONFIRMED SHEET (PEDIDOS CONFORMADOS) but it only send the first row . I have been using the form component in order to do so. Anyone can help me with this ?Thank you ![scrnli_2_1_2021 21-38-06](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/3/d3a8eddf8604840e59afe589b4e16d5ab154afa6.png) ![scrnli_2_1_2021 21-37-42](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/3/a302db143a4260d9c3f370d31d10122f1cad372b.png) ---
**Author:** ![Jacktools\_Net](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktools_net/32/18500_2.png) [@Jacktools\_Net](https://community.glideapps.com/u/Jacktools_Net)\ **Post date:** [January 2, 2021, 9:15pm UTC](https://community.glideapps.com/t/send-multiple-items-to-another-sheet/20627/2 "2021-01-02T21:15:48Z")
Perhaps you just need a relation colum in your confirmation sheet to achieve what you want to do. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [January 2, 2021, 10:31pm UTC](https://community.glideapps.com/t/send-multiple-items-to-another-sheet/20627/3 "2021-01-02T22:31:17Z")
I’d suggest you exactly what @Jacktools_Net said. In your confirmation table you just need the Cart ID, total value, etc… because in a Adm panel you’ll need only a relation to get the informations of the cart table related to that Cart ID ---
**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 3, 2021, 3:31am UTC](https://community.glideapps.com/t/send-multiple-items-to-another-sheet/20627/4 "2021-01-03T03:31:09Z")
If you just need to join some certain things (like items, quantities etc.) then probably you can try a join list on a template column. ---
**Author:** ![al3xrods](https://avatars.discourse-cdn.com/v4/letter/a/b9e5f3/32.png) [@al3xrods](https://community.glideapps.com/u/al3xrods)\ **Post date:** [January 4, 2021, 4:51am UTC](https://community.glideapps.com/t/send-multiple-items-to-another-sheet/20627/5 "2021-01-04T04:51:42Z")
When the customer just make one order , the data gets sent to the confirmation sheets and everything works fine, but The problem is that once the customer makes more than 1 orders , just the data of the first row gets sent to the confirmation sheet. So I cannot make a relation of the orders that didn’t got sent to the confirmation sheet. ---
**Author:** ![al3xrods](https://avatars.discourse-cdn.com/v4/letter/a/b9e5f3/32.png) [@al3xrods](https://community.glideapps.com/u/al3xrods)\ **Post date:** [January 4, 2021, 4:56am UTC](https://community.glideapps.com/t/send-multiple-items-to-another-sheet/20627/6 "2021-01-04T04:56:12Z")
![scrnli_4_1_2021 6-55-40](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/e/4ee1c18ceaff297f8e88d7558da21fc1ef5b6f95.png) ---
**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 4, 2021, 8:50am UTC](https://community.glideapps.com/t/send-multiple-items-to-another-sheet/20627/7 "2021-01-04T08:50:31Z")
So you’re using a custom cart you made with a form, is it correct? ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [January 4, 2021, 11:56am UTC](https://community.glideapps.com/t/send-multiple-items-to-another-sheet/20627/8 "2021-01-04T11:56:46Z")
> [@How to create an app for taking Sales Orders](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/2): > > What kind of problem are you having? I’d say it’s definitely possible. There have been a few posts regarding a shopping cart that doesn’t use Stripe. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [January 4, 2021, 12:02pm UTC](https://community.glideapps.com/t/send-multiple-items-to-another-sheet/20627/9 "2021-01-04T12:02:26Z")
In addition of that, I guess what you need exactly is to know how to create an Order ID. Because once I order something, my order ID **must** be different in a second time or for another user. Here’s what I used and help me a lot a while ago with [Buffalo Burger](https://community.glideapps.com/t/updated-buffalo-burger/7790) and [Forker](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048) (multi-delivery app), thank to @Jeff_Hager! > [@How to create an app for taking Sales Orders](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/12): > > Here’s a bit of a wild idea. Create a column in your confirmed orders sheet that will contain only email and business. This can be 2 separate column joined with a template, or you can write it to the sheet later already joined from the form button. Doesn’t matter. We just need email and buiness only. Next on your products, sheet follow the instructions here to get a lookup column of the user’s signed in email into the products sheet. [List Relation "Data"](https://community.glideapps.com/t/list-relation-data/7659/5) Next in the products sheet, create… ---
**Author:** ![al3xrods](https://avatars.discourse-cdn.com/v4/letter/a/b9e5f3/32.png) [@al3xrods](https://community.glideapps.com/u/al3xrods)\ **Post date:** [January 5, 2021, 4:25am UTC](https://community.glideapps.com/t/send-multiple-items-to-another-sheet/20627/10 "2021-01-05T04:25:20Z")
I created a Order ID which is User Row ID + Menu ID but that is not the problem. The problem is that when I use the FORM component to send all the order’s data to another sheet , only the first row is sended to the other sheet. So suppose you order :1 Pizza , 2 Big Macs & 2 Sushi. Only the 1 Pizza will get send to the other sheet of all your order. ---
**Author:** ![al3xrods](https://avatars.discourse-cdn.com/v4/letter/a/b9e5f3/32.png) [@al3xrods](https://community.glideapps.com/u/al3xrods)\ **Post date:** [January 5, 2021, 4:27am UTC](https://community.glideapps.com/t/send-multiple-items-to-another-sheet/20627/11 "2021-01-05T04:27:29Z")
Yes . But that is a little troublesome because when the user hits “send” on the form component , just 1 row of all his order gets send to the confirmation sheet. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [January 5, 2021, 4:57am UTC](https://community.glideapps.com/t/send-multiple-items-to-another-sheet/20627/12 "2021-01-05T04:57:49Z")
That’s normal @al3xrods the form button always will send the first row What you gotta understand is to get the informations you need to send in this single row to ‘Orders Confirmed’ table ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [May 15, 2024, 3:53am UTC](https://community.glideapps.com/t/send-multiple-items-to-another-sheet/20627/13 "2024-05-15T03:53:51Z")