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.
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.