# Creating POS System with GlideApps **URL:** \ **Category:** Ask for Help\ **Created:** [June 19, 2022, 1:58pm UTC](https://community.glideapps.com/t/creating-pos-system-with-glideapps/43253 "2022-06-19T13:58:29Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\ **Post date:** [June 19, 2022, 1:58pm UTC](https://community.glideapps.com/t/creating-pos-system-with-glideapps/43253/1 "2022-06-19T13:58:29Z")
**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 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 19, 2022, 2:12pm UTC](https://community.glideapps.com/t/creating-pos-system-with-glideapps/43253/2 "2022-06-19T14:12:54Z")
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. ---
**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\ **Post date:** [June 19, 2022, 2:21pm UTC](https://community.glideapps.com/t/creating-pos-system-with-glideapps/43253/3 "2022-06-19T14:21:55Z")
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: ![Screen Shot 2022-06-19 at 10.18.00 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/8/58931505bff9b98116cc1d6b89403807b532c6df.png) 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 ---
**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\ **Post date:** [June 19, 2022, 2:23pm UTC](https://community.glideapps.com/t/creating-pos-system-with-glideapps/43253/4 "2022-06-19T14:23:46Z")
The goal is to have a list displayed showing the items + quantity + total cost. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 19, 2022, 2:28pm UTC](https://community.glideapps.com/t/creating-pos-system-with-glideapps/43253/5 "2022-06-19T14:28:28Z")
> [@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. ---
**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\ **Post date:** [June 19, 2022, 2:39pm UTC](https://community.glideapps.com/t/creating-pos-system-with-glideapps/43253/6 "2022-06-19T14:39:26Z")
![Screen Shot 2022-06-19 at 10.36.38 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/b/eb69643f62bdf1205da450935e1c44b09a13afb7.png) Okay done, here’s where I’m at now. ![Screen Shot 2022-06-19 at 10.39.18 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/b/5b6bddafbee6768b22bbb9b8d371f7157b9686c2.jpeg) ![Screen Shot 2022-06-19 at 10.41.12 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/7/57fd8ef9554975127ae4ee3ebbd1e472c0606966.jpeg) Isn’t this now just another problem? Because now we have to group the display messages that are the same? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 19, 2022, 2:44pm UTC](https://community.glideapps.com/t/creating-pos-system-with-glideapps/43253/7 "2022-06-19T14:44:27Z")
Gimme a few minutes, I’ll give you a video. ---
**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\ **Post date:** [June 19, 2022, 2:44pm UTC](https://community.glideapps.com/t/creating-pos-system-with-glideapps/43253/8 "2022-06-19T14:44:46Z")
You’re a legend, thank you so much aha \<3 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 19, 2022, 2:50pm UTC](https://community.glideapps.com/t/creating-pos-system-with-glideapps/43253/9 "2022-06-19T14:50:46Z")
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. ---
**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\ **Post date:** [June 19, 2022, 3:14pm UTC](https://community.glideapps.com/t/creating-pos-system-with-glideapps/43253/10 "2022-06-19T15:14:04Z")
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? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 19, 2022, 3:15pm UTC](https://community.glideapps.com/t/creating-pos-system-with-glideapps/43253/11 "2022-06-19T15:15:18Z")
> [@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. ---
**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\ **Post date:** [June 19, 2022, 3:27pm UTC](https://community.glideapps.com/t/creating-pos-system-with-glideapps/43253/12 "2022-06-19T15:27:45Z")
Thank you so much, it works. You’re amazing man ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [June 20, 2022, 3:28pm UTC](https://community.glideapps.com/t/creating-pos-system-with-glideapps/43253/13 "2022-06-20T15:28:40Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.