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: 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: Select the restaurant from homepage Browse the menu and select the food i wish to order 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. Thanks!

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.

1041/5000 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. [image] How to create an app for taking Sales Orders 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" Next in the products sheet, create…

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: [Screenshot 2020-04-27 at 12.10.52] "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. [image] List Relation "Data" BAM! I figured it out. First create an If/Then column on the user profile sheet that fills the column with the word ‘Name’ if signed in user. [image] Next, on every sheet you want to display the name: Create a template column that contains the word ‘Name’. Create a relation column that joins the name template to the name template in the user profile sheet. Create a lookup column that gets the name from the relation. Bonus - make it look pretty. [image] [image]

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. [image] How to create an app for taking Sales Orders I managed to get an id to send each product. Your recommendation helped me, I’m not sure if I did as you tell me, but it was based on your idea. In the products table I already had the trade in each row, so I only had to add the mail, concatenate it to control with the confirmed table. While I succeeded, I had to make multiple columns in the editor. Surely there is a simpler way, but I’ll show you to see. In the spreadsheet I entered the word name to all the products, to relate it to the use…

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: [Screenshot 2020-04-27 at 15.11.12] 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?

Delivery App - Retrieving Order

Ask for Help

Mariano_Betta April 27, 2020, 12:24pm 8

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

Topic		Replies	Views
How to create an app for taking Sales Orders Ask for Help	92	10112	May 1, 2021
[UPDATED] Buffalo Burger :hamburger: Project Showcase	49	3908	September 10, 2021
Shopping cart without Stripe (Cash payment at reception) Feature Requests	1	753	May 27, 2020
Grocery app? Ask for Help	19	745	March 19, 2021
My first project, and im a little stuck:-) Ask for Help	31	973	November 28, 2022

Delivery App - Retrieving Order

Related topics