Delivery App - Retrieving Order

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…

image

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

I’m following you @Wiz.Wazeer :face_with_monocle:

1 Like

Hello,

I am struggling as well to replicate a checkout for a marketplace. Looking forward to see your solution!

Cheers,
Fabrice

1 Like

Sure. Tx

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.

1 Like

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

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… :weary:

What am I missing?

@Mariano_Betta Could you share a trial version of your system?
maybe it could be more understandable …

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 ?