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
Hello,
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:
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.
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.
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.
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?
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.
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.
Response sheet (orders sheet).
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.
