Creating POS System with GlideApps

[moshi]

The Goal:
Customer generates a new order from their app. Then on my end I can edit their order and add items & create their total amount owing.

Where I’m at:
Customer creates order
data get’s sent to a sheet called, “Orders”
I created a sheet of possible items & their price
I displayed the price sheet on GlidePage & created an action to add item name/price/order# to a sheet called Transactions
Created a relation between “Orders” sheet & “Transactions” sheet, where Orders have MANY transactions
On the front-end when I click on a specific order it will show me a breakdown of all the transactions, however it won’t group the transactions with the same name. Say order #34 bought 4 apples. It’ll show 4 different transactions with 4 lines.

What should happen → is there a way to show a summary of the order? Where it will group the same name items, so instead of it being 4 lines of the same item, it’ll show 1 line saying “Apples x 4 = total price”

I tried doing this and am having a lot of trouble. My gut tells me I’m supposed to create another sheet that summarizes each order? Idk

Summary of Sheets:

1. Orders
2. Items
3. Transactions

Sorry this was long-winded, been stuck on this for a while now. Not looking for a detailed explanation, maybe an overall picture of what’s supposed to happen, that would be great <3

[Darren_Murphy]

I think you could create a template column in your Transactions table that concatenates the order number and the item. Then create a multiple relation that matches that column to itself. You can then use a rollup through that relation to get an item count. And finally another template column to join the item description and item count.

[moshi]

Thank you for your response, here’s where I’m at so far

@Darren_Murphy

create a template column in your Transactions table that concatenates the order number and the item.

Did that, named it “Current Line”

@Darren_Murphy

create a multiple relation that matches that column to itself.

Did that, called it “Grouping Same Transactions”

Now i’m stuck, here’s what I have:

Am I supposed to create the rollup on the Orders page?

In this case, the summary should be:
Order #55
Apples x 2
Oranges x 2
Cost = $116

[moshi]

The goal is to have a list displayed showing the items + quantity + total cost.

[Darren_Murphy]

@moshi

Am I supposed to create the rollup on the Orders page?

No, all the columns I described should be in your Transactions table.

You should make sure your Item Cost column is configured as a Number type, otherwise you won’t be able to do a rollup to get the total cost per item/order.

[moshi]

Okay done, here’s where I’m at now.

Isn’t this now just another problem? Because now we have to group the display messages that are the same?

[Darren_Murphy]

Gimme a few minutes, I’ll give you a video.

[moshi]

You’re a legend, thank you so much aha <3

[Darren_Murphy]

It’s a little complicated, but hopefully you can follow along. If I thought about it a bit more, I might be able to simplify it a bit.

[moshi]

That was the craziest thing I’ve ever seen lol. I re-watched the video at least 7 times.

First time using a joined list being used. Thank you so much Darren!

So i’m guessing from there I go to the Orders section and create a relation to the transactions VIA order number to retrieve the order summary right?

[Darren_Murphy]

@moshi

So i’m guessing from there I go to the Orders section and create a relation to the transactions VIA order number to retrieve the order summary right?

yep, that should do the trick.

[moshi]

Thank you so much, it works. You’re amazing man