Delivery App - Retrieving Order

All the link in this post are screenshot describing my issue since I’m a new user and can’t post more than 1 image

I’m having some issues setting this properly.

Couple of words about the app i’m trying to do:
I’m recreating a food delivery app with multiple restaurants.
Here is the main sheet for all my restaurant:

As you can see there is a relation column for the menu that fetch datas from this other huge sheet with all restaurant’s dishes.

The issue
So when it’s time to make orders i follow this procedure:

  1. Select the restaurant from homepage
  2. Browse the menu and select the food i wish to order
  3. Select the quantity and submit

I’ve then recreated a Custom Cart Tab that takes all the items i add (if the users is signed in and the Quantity is not 0).

The Custom Cart relies on this sheet “Form Response”.
Whenever i select a new item and add a quantity, the sheet get populated and the items get added to the Custom Cart tab.

What I would like to achieve
Whenever a user click on “Submit Order” will have to fill this form with some personal data.
He just need to tell us where he live, his real name and phone number.

I would like to collect all the upcoming orders into a new Sheet called “Order”.
I would like every row gets populated with all user’s personal information and the list of items he ordered, the quantity and the total price.

I’ve already prepared an “Order” Sheet but what i can get is just his personal information.
I don’t know how to fetch all the different dishes the user ordered because they sits on different rows right now.

Plus, I would like that the columns “Is Fulfilled” gets checked so I can initialise the user Custom Cart.


There are several food related apps in the forum if you’re looking for ideas.

Here’s one idea that I wrote about yesterday.

Another restaurant app posted about yesterday.

There are several restaurant and covid related apps you can find here.

1 Like

I didn’t find a proper solution for my issue… the Buffalo Burger case seems pretty close but he only have one restaurant…

If you read though the first link I posted. He is working on orders for multiple businesses.


Hello, what you want to do at this time would not know how, because when you send the order you only fill one row of data and you have the orders in different rows.
If it serves you and your intention is to relate the ordered items, it can do something like this.

On the sheet where the articles are, enter an email & restaurant column and another email & restaurant & count column.
That count would be comparing the electronic & restaurant column with a similar column in that final “Order” table. It can also be done by relating, there are several ways. Then it increases from 1.
When ordering an item, together send those 2 columns to the cart (the user does not need to see them, hidden). And then from the cart when you send the order to that “Order” sheet, incorporate those 2 columns.
The email & restaurant column will help you count.
The email & restaurant & count column helps you link items to the final order.
I hope it is understood.
Jeff_Hager is the one who helped me.

Sorry, I tried so hard but I really can’t get through you solution.
I don’t understand how I can generate the column you are suggesting.

In the Menu sheet, where all the products of all the restaurant are listed, I have no way of having an email to concatenate to a restaurant because that sheet is global for everyone.

I can create a relation but than, when i try to create a template, all the rows get subjected to that template.

I think I’m really close to the solution but it’s getting frustrating.

I’m stucked in the first part of the solution.

In the Menu i’ve created several Columns to get the data you said:

"Is in the cart" Column is a Relation Column with the “Form Response” to check if I ordered an Item and give me back the entire row.

"Email of the Orderer" is a Lookup Column to look for the “Email” address in that relation string.

"Email + Ristorante TEMPLATE" is a IF/ELSE Column that create a template value EMAIL_RISTORANTE

"Email + Ristorante" Finally, is the column that give me the Email + Business as you said.

Here comes the first issue, since if another signed in user make some order it doesn’t work…

To get the email of the person who logged in, here is the explanation.

1 Like

This is one of the main problem.
The app automatically created a sheet called App: Logins for all users who made the log in procedure, but I can’t see it on the app database. Just on google sheet.

I was trying to add that column but I can’t figure out how…

I used my own user sheet. I would look for a way for them to register. And do it based on that sheet.
If you look I had to make several columns in the editor, possibly there is a simpler way, but for now it works.

It’s getting confusing.
I make as you did. Create a “User Profile Sheet” with a google sheet formula that just get the emails of users that already signed in.
Than I created the reference to the Email.

Than in the Menu Sheet i have this situation:

I get the user signed in for every column of the menu. And so the relation is for Every item, not just the one that i put in my cart…

The fact is, i didn’t get the solution. I’m just blindly following the instruction so I get stucked.
Could you show me some of the logics you used behind the columns with images?

Ok so I went through again and again and I’m getting closer.

First of all I added the 2 column EMAIL_RESTAURANT and EMAIL_RESTAURANT_COUNT into the Menu Sheet

I pass the value to the cart once I submit every item, and then I pass the value on the Confirmed Order when I confirm order.

If I try with different users, it seems to work but if I try several times with the same user it keep the same Count in the order sheet…


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.

Hi, I am in the middle of Developing multiple sign up food ordering platform with links to various payment processing companies. Have a look at this and tell me if this is what you seek. It’s not finished yet so ignore a lot of things. Just start ordering and see what happens. Tx.

It’s only demo for u. Is this what you want in your cart?

@Wiz.Wazeer This is exactly what I’m trying to do… Did you used Mariano’s solution?

@Mariano_Betta I really appreciate your help. I try with your logic per your last image. Let’s see…

Thanks a lot. Sorry which is the Mariano app?

Hello @ fi.low, test if it works for you.
But if @ Wiz.Wazeer’s solution is what you are looking for, maybe he can help you in a simpler way.
I am continually changing my application.

Oh sorry I get what you mean now. No I did not follow that chat. I have not finished my app yet. I’m still testing a few functionalities. Let me finish everything and then I’ll share everything with you.

To put it in a nutshell. Jeff was directing you in the right direction but I implemented a completely different methodology. The basic concept is to have two sheets.

  1. Response sheet (orders sheet).
  2. Final order sheet. Inside the orders sheet in your app you would need to create the final order sheet. But here is the trick. The orders sheet and the final orders sheet would have to be almost duplicates. You would use the special column values (Jeff’s idea) from the order sheets to fill the final orders sheet with the missing information from the orders sheet. But I identify confirmation of the final order by checking it against the email and timestamp of the orders sheet. I’m sorry I am just an easy solution seeker. Let me finish it and I’ll share a copy with you. Its not done yet but as you could see it’s already working. Please give me a few days. Tx.