# Delivery App - Retrieving Order **URL:** \ **Category:** Ask for Help\ **Created:** [April 26, 2020, 11:06am UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867 "2020-04-26T11:06:33Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [April 28, 2020, 1:56am UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/21 "2020-04-28T01:56:12Z")
I’m following you @Wiz.Wazeer 🧐 ---
**Author:** ![Fabrice\_Bouland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabrice_bouland/32/5998_2.png) [@Fabrice\_Bouland](https://community.glideapps.com/u/Fabrice_Bouland)\ **Post date:** [April 28, 2020, 1:40pm UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/22 "2020-04-28T13:40:28Z")
Hello, I am struggling as well to replicate a checkout for a marketplace. Looking forward to see your solution! Cheers, Fabrice ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [April 28, 2020, 11:26pm UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/23 "2020-04-28T23:26:33Z")
Sure. Tx ---
**Author:** ![jordi-torrijos](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jordi-torrijos/32/4597_2.png) [@jordi-torrijos](https://community.glideapps.com/u/jordi-torrijos)\ **Post date:** [April 29, 2020, 8:49am UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/24 "2020-04-29T08:49:14Z")
Hi @Wiz.Wazeer , I was looking for a cash on delivery solution either. Would you mind sharing the template with me when you finish. Thanks and kind regards. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [April 29, 2020, 11:35am UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/25 "2020-04-29T11:35:17Z")
Sure Tx. Nearly done. I’ve just overcome a major frustration. I was having this issue with auto generated invoice referencing. The problem was allowing a customer to delete entire order (not items ordered)’ meant the auto referencing went haywire. The only way to avoid that would have been to disable the whole order cancellation button. But I have overcome it in a rather cheeky way. Test the invioice some1 pls. I am getting the customers to generate their own invoice references. This way no need for array formulas etc. Of course you can always internally reference the invoices. This was my main issue If you have other solutions pls share with me when you’ve made your own modifications to my cart. Tx ---
**Author:** ![fi.low](https://avatars.discourse-cdn.com/v4/letter/f/e79b87/32.png) [@fi.low](https://community.glideapps.com/u/fi.low)\ **Post date:** [April 29, 2020, 3:03pm UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/26 "2020-04-29T15:03:54Z")
> [@Mariano\_Betta](#): > > EMAIL\_RESTAURANT\_COUNT > [@Mariano\_Betta](#): > > ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6bb08d7c2c849c34a48a86867466c2eb27723003.png) > > We start with the count at 0. > I got 0 by relating the EMAIL\_RESTAURANT column of the menu table > with EMAIL\_RESTAURANT from the confirmed orders table. > The first time it gives 0 to all the articles. > When you confirm another order, you should give 1. > That is, the count is made with that column. And the subsequent relationship from the table confirmed orders with the articles is going to be done with the column EMAIL\_RESTAURANT\_COUNT. > You have to use matrix formula, I only did that example in an excel. > > I’m not very good at explaining, but the most important thing is the logic. > I do what I can within the short time I have. I tried several times but I failed even more. I get the EMAIL\_RESTAURANT and EMAIL\_RESTAURANT\_COUNT in the menu, i pass them down to the Cart, then from there to the Confirmed Orders. Everything works fine. But then, on the second order I made, it takes the First Item of the column that have the older count and doesn’t work… 😩 ![Screenshot 2020-04-29 at 17.02.40](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/4e2bf397b8ebe084f09869085644b198561af8f4.png) What am I missing? ---
**Author:** ![fi.low](https://avatars.discourse-cdn.com/v4/letter/f/e79b87/32.png) [@fi.low](https://community.glideapps.com/u/fi.low)\ **Post date:** [April 29, 2020, 3:08pm UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/27 "2020-04-29T15:08:58Z")
@Mariano_Betta Could you share a trial version of your system? maybe it could be more understandable … ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [April 29, 2020, 6:19pm UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/28 "2020-04-29T18:19:10Z")
What are you trying to achieve with the count formula? I don’t see it’s relevance here ? Maybe Jeff will know. If I order a meal once a day or 10 times day, how is the count formula helping me or you at your end ? ---
**Author:** ![Mariano\_Betta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariano_betta/32/17895_2.png) [@Mariano\_Betta](https://community.glideapps.com/u/Mariano_Betta)\ **Post date:** [April 29, 2020, 7:17pm UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/29 "2020-04-29T19:17:57Z")
Hello @ fi.low There I pass the link. The application is not finished and surely it still has many errors. Try placing an order from the “Babylon Pizzas” store, confirming it, and then placing another order from the same store. I also do not have the user settings for you to register, so your address will not leave. The error you have for me is the count formula, which must be matrix in the confirmed orders table. He will always give you the same number for the same email and restaurant. It is just that. From your menu table you have to make a column in the editor to search for that result. This image is from the confirmed orders table. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/cfce9f4a934f1fc0447ef44ecd814f33abcdb9f1.png) ---
**Author:** ![Mariano\_Betta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariano_betta/32/17895_2.png) [@Mariano\_Betta](https://community.glideapps.com/u/Mariano_Betta)\ **Post date:** [April 29, 2020, 7:19pm UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/30 "2020-04-29T19:19:10Z")
There I realized that you must first be registered for it to work. [jxpl3.glideapp.io](http://jxpl3.glideapp.io) ---
**Author:** ![Mariano\_Betta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariano_betta/32/17895_2.png) [@Mariano\_Betta](https://community.glideapps.com/u/Mariano_Betta)\ **Post date:** [April 29, 2020, 7:44pm UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/31 "2020-04-29T19:44:47Z")
for example, there it shows me the last order, but if I leave the order halfway and I make another one from another store I would have to show that last one. And then you have to resolve all those unfinished orders, because they will generate an ID for you. for example I make an order today, I don’t finish it and I leave it for several days. When I want to make an order in that same store another day, I will have the same id. They are things to solve. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [April 30, 2020, 1:53pm UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/32 "2020-04-30T13:53:58Z")
Gvalero 🧐Should be releasing it on weekend. I’ve embedded PayPal link by restaurant. Would this sort of thing help businesses in your part of the world. Check it when you get time. Not the best solution but allows payment by PayPal. ---
**Author:** ![fi.low](https://avatars.discourse-cdn.com/v4/letter/f/e79b87/32.png) [@fi.low](https://community.glideapps.com/u/fi.low)\ **Post date:** [May 1, 2020, 1:38pm UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/33 "2020-05-01T13:38:49Z")
@Mariano_Betta could you please unlock the flag to make a copy of your app so I can understand the structure? ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 3, 2020, 3:36pm UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/35 "2020-05-03T15:36:20Z")
Made it available. You can check it out to see if it helps. Tx ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 3, 2020, 3:40pm UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/36 "2020-05-03T15:40:28Z")
You can copy it now. Sorry for the delay. Tx ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [May 4, 2020, 2:22pm UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/37 "2020-05-04T14:22:19Z")
@Wiz.Wazeer Your APP amazing, it has too many options that sometimes I get lost 🙃 What I don’t understand yet is the **Confirm Item switch**. If the order was sent (and closed), why does that switch have some functionality and can change the items within an order yet? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f89868905845705e401d17d5d9678143066337f5.png) Sorry if the question looks obvious but as I wrote above, your APP has so many options!! Saludos Wiz, feliz día! ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 4, 2020, 2:30pm UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/38 "2020-05-04T14:30:28Z")
Thank you. Okay the reason I added this was to allow one thing only. 1. Ability to customer to cancel order. If you look carefully it’s the same button that customers use to Deconfirm orders on the receipt. When they toggle the switch to off, you will notice the order confirmed checkbox goes blank on the receipt.just a clever little trick. I took various scenarios into account. Some don’t allow customers to cancel orders. Others do. So I just that I’d add that button. Other thing I should add is that if restaurant disabled ability to delete receipt, customer would have to phone up to cancel order. Some customers might not like this idea. They just want to order or cancel on the go. The button allows confirmation of cancellation twice. This way restaurant cannot moan and groan. Customer keeps a screenshot of the unchecked box as confirmation of cancellation in any future disputes. 🤓 ---
**Author:** ![Erni\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erni_d/32/9023_2.png) [@Erni\_D](https://community.glideapps.com/u/Erni_D)\ **Post date:** [May 8, 2020, 11:49pm UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/39 "2020-05-08T23:49:24Z")
Hi @Wiz.Wazeer I’m trying to get your orders app but I deleted my copy of your by accident. Any way you can share it one more time? It’s not available anymore! Thanks from the awesome work ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 9, 2020, 10:29am UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/40 "2020-05-09T10:29:29Z")
Tx. Your right I removed it after 24hrs. Making some changes and then will make it available again. Will keep u posted. ---
**Author:** ![Diklat\_MII](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/diklat_mii/32/1047_2.png) [@Diklat\_MII](https://community.glideapps.com/u/Diklat_MII)\ **Post date:** [May 13, 2020, 12:35am UTC](https://community.glideapps.com/t/delivery-app-retrieving-order/7867/41 "2020-05-13T00:35:23Z")
how to put paypal on app? [Previous page](https://community.glideapps.com/t/delivery-app-retrieving-order/7867.md?page=1) [Next page](https://community.glideapps.com/t/delivery-app-retrieving-order/7867.md?page=3)