# Ordering App : Problem to send order items to Spreadsheet **URL:** \ **Category:** Get Help\ **Created:** [November 19, 2020, 4:42pm UTC](https://forum.adalo.com/t/ordering-app-problem-to-send-order-items-to-spreadsheet/6144 "2020-11-19T16:42:22Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![StephEnabl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/stephenabl/32/4214_2.png) [@StephEnabl](https://forum.adalo.com/u/StephEnabl)\ **Post date:** [November 19, 2020, 4:42pm UTC](https://forum.adalo.com/t/ordering-app-problem-to-send-order-items-to-spreadsheet/6144/1 "2020-11-19T16:42:23Z")
Hello everyone! Has anyone ever used the Ordering FOOD SPOT template? I customized it a little bit to make it work for one restaurant with stock management and without online payment but I’m stuck on sending data via Zapier. I’m able to send all the data EXCEPT the content of the order, which, you’ll agree, is a bit annoying. 🙂 I export the ORDERS table, I have all the info but the menu items are in the “orders” column which only counts the items but doesn’t display them. The “orders items” are in another table… Zapier does not list the menu items of the order, I don’t know why ! I don’t know if I’m clear… If someone has an idea… I’ll take it ! Thank you. Thank you. ---
**Author:** ![pford](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/pford/32/4648_2.png) [@pford](https://forum.adalo.com/u/pford)\ **Post date:** [November 19, 2020, 7:09pm UTC](https://forum.adalo.com/t/ordering-app-problem-to-send-order-items-to-spreadsheet/6144/2 "2020-11-19T19:09:58Z")
Here’s how to do this: 1. Make sure the orders have an ID of some kind and that the ID is replicated to an order item each time one is added to the order. 2. When you fire the Zap to export an Order’s order items, the zap will look up all Order Items then use the Filter step to filter it to match the ID of the Order you want to export. 3. The last step of the Zap will be to add those items to a spreadsheet and save/send/export it to where it needs to go. ---
**Author:** ![StephEnabl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/stephenabl/32/4214_2.png) [@StephEnabl](https://forum.adalo.com/u/StephEnabl)\ **Post date:** [November 19, 2020, 7:45pm UTC](https://forum.adalo.com/t/ordering-app-problem-to-send-order-items-to-spreadsheet/6144/3 "2020-11-19T19:45:59Z")
Hi @pford, thanks for your answer. So I’ll have 2 zaps right ? One for the ORDERS table with the name, email, pick up time, etc… And an other Zap with the items of the order ? ---
**Author:** ![pford](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/pford/32/4648_2.png) [@pford](https://forum.adalo.com/u/pford)\ **Post date:** [November 19, 2020, 8:08pm UTC](https://forum.adalo.com/t/ordering-app-problem-to-send-order-items-to-spreadsheet/6144/4 "2020-11-19T20:08:16Z")
To be honest I’m not sure which would work better, but I think it could just be one multi-step Zap. I use Integromat more because it’s a little bit easier to see the action path, but it should be able to be contained in one Zap. ---
**Author:** ![StephEnabl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/stephenabl/32/4214_2.png) [@StephEnabl](https://forum.adalo.com/u/StephEnabl)\ **Post date:** [November 19, 2020, 8:15pm UTC](https://forum.adalo.com/t/ordering-app-problem-to-send-order-items-to-spreadsheet/6144/5 "2020-11-19T20:15:07Z")
The thing is that I can’t do it in 1 zap cause the items are not in the same table. That’s why I have this problem. On one hand I have the infos of my order (orders table) et on the other hand the items of my order (orers items) Look here : ![Capture d’écran 2020-11-19 à 21.10.13](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/5/56242b1bcf09b5e3d8d8f15a8811868a9b8d20ea.png) ![Capture d’écran 2020-11-19 à 21.10.26](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/2/225ba12e81a10d0303e9dd35f775762070439f48.png) Integromat does not integrate Adalo ☹ ---
**Author:** ![pford](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/pford/32/4648_2.png) [@pford](https://forum.adalo.com/u/pford)\ **Post date:** [November 19, 2020, 8:20pm UTC](https://forum.adalo.com/t/ordering-app-problem-to-send-order-items-to-spreadsheet/6144/6 "2020-11-19T20:20:38Z")
Gotcha. You can actually use the new Adalo API to use it with Integromat. But yes sorry I was thinking Zapier had a Get All Records module, but it doesn’t look like they do… ---
**Author:** ![StephEnabl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/stephenabl/32/4214_2.png) [@StephEnabl](https://forum.adalo.com/u/StephEnabl)\ **Post date:** [November 19, 2020, 8:52pm UTC](https://forum.adalo.com/t/ordering-app-problem-to-send-order-items-to-spreadsheet/6144/7 "2020-11-19T20:52:13Z")
Outch… “You can actually use the new Adalo API to use it with Integromat.”. I absolutely don’t know to do it. 😉 I’ll try with Zapier. You gave me some clues to do it. I keep going… Thanks a lot ! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\ **Post date:** [November 29, 2020, 8:52pm UTC](https://forum.adalo.com/t/ordering-app-problem-to-send-order-items-to-spreadsheet/6144/8 "2020-11-29T20:52:21Z")
This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.