# Advance relations challenge **URL:** \ **Category:** Ask for Help\ **Created:** [January 17, 2025, 6:18pm UTC](https://community.glideapps.com/t/advance-relations-challenge/79294 "2025-01-17T18:18:30Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![kormoranil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kormoranil/32/83656_2.png) [@kormoranil](https://community.glideapps.com/u/kormoranil)\ **Post date:** [January 17, 2025, 6:18pm UTC](https://community.glideapps.com/t/advance-relations-challenge/79294/1 "2025-01-17T18:18:30Z")
Hello everyone! I’m building my first app, and this is my biggest challenge… The app is a management system for bulk order quantities of products. The system only serves as an information record for my users, They upload information about the orders, suppliers, prices etc… just to save their info. I have: - Products - Suppliers - Orders Here’s the challenge: Each product has it’s price per unit, but the price depends on the order’s quantity. Example: Let’s say the user opens an order #1, with: 100 pieces of “soccer ball model A” that costs 2.8$ per unit 2000 pieces of “uniforms model Z” that costs cost 2.2$ per unit And order #2, with: 1000 pieces of (the same) “soccer ball model A”, this time it costs 1.5$ 4000 pieces of (the same) “uniforms model Z” this time it costs 1$ So, the price depends on the order’s quantity. How would you relate the price to the product and the quantity and the order all together? Thank you! ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [January 17, 2025, 7:02pm UTC](https://community.glideapps.com/t/advance-relations-challenge/79294/2 "2025-01-17T19:02:32Z")
If I understand correctly, you are asking for a calculation of the Price Per Unit, Right? The **`Total Price`** is calculated as: ```auto Total Price = Quantity * Price Per Unit ``` And the **`Price Per Unit`** depends on certain conditions, which we need to define. You can use an **If-Then-Else** column in the **Products** table to dynamically set the **`Price Per Unit`** based on conditions like quantity. Here is how you can handle it: 1. Create an **If-Then-Else** column in the **Products** table (or better, in **Orders** , since prices are specific to each order). - **If** the `Quantity` (linked from the order) is below _1000_, then set the price to 2.8$. - **Else** , set the price to 1.5$. - e.g.: If `Quantity < 1000`, then 2.8$. Else 1.5$. 2. **Calculate the Total Price** : - Add a **Math** column: ```auto Total Price = Quantity * Price Per Unit ``` ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 17, 2025, 8:18pm UTC](https://community.glideapps.com/t/advance-relations-challenge/79294/3 "2025-01-17T20:18:49Z")
How is your data structured? Do you have multiple rows for each product with different quantity/price, or are all the price combinations in the same product row? ---
**Author:** ![kormoranil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kormoranil/32/83656_2.png) [@kormoranil](https://community.glideapps.com/u/kormoranil)\ **Post date:** [January 19, 2025, 10:23am UTC](https://community.glideapps.com/t/advance-relations-challenge/79294/4 "2025-01-19T10:23:11Z")
Hey! Thank you for your time. I’m not asking for the calculation of price per unit. I’m wondering where (In what table) should I store the data, and how to relate the product & the price & the quantity. The complexity is that the same product has different quantity and price in each order. So, where should I save the data? In which table? I thought about letting them duplicate the same product. So for example: “Model A” in 100 pieces will have a price of 2.8$ And “Model A” in 200 pieces will have a price of 2.5$ They’ll have “model A” in quantity of 100 in a price of 2.8$ And if they want to order the same product again, but this time 200pcs, they’ll have to duplicate “model A” and update the new price (cause 100 pcs don’t cost the same like 200pcs). \*\*It’s NOT a ecommerce store It’s just for my clients to STORE their date What did they order, in how many pieces, at what price. ---
**Author:** ![kormoranil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kormoranil/32/83656_2.png) [@kormoranil](https://community.glideapps.com/u/kormoranil)\ **Post date:** [January 19, 2025, 10:30am UTC](https://community.glideapps.com/t/advance-relations-challenge/79294/5 "2025-01-19T10:30:12Z")
> [@Jeff\_Hager](#): > > How is your data structured? Do you have multiple rows for each product with different quantity/price, or are all the price combinations in the same product row? Right now I have 3 tables: Products Orders Supplier I thought about creating another table, that will store the different scenarios… maybe this way i can relate the product, price and quantity together? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f545ff54539086b570988e4446f26e994ca16ea2.png) ---
**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:** [January 19, 2025, 10:31am UTC](https://community.glideapps.com/t/advance-relations-challenge/79294/6 "2025-01-19T10:31:37Z")
> [@kormoranil](#): > > The complexity is that the same product has different quantity and price in each order. That just means you need to store both the quantity and price per unit with each order. Can I assume there could be multiple line items for each order? Assuming that’s the case, you could split orders up into two tables. Firstly, an Orders table which would have the following columns: - RowID (OrderID) - Date - SupplierID And then an Order Items table with the following columns: - OrderID (link to the parent order) - ProductID - Quantity - Unit Price ---
**Author:** ![kormoranil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kormoranil/32/83656_2.png) [@kormoranil](https://community.glideapps.com/u/kormoranil)\ **Post date:** [January 19, 2025, 8:39pm UTC](https://community.glideapps.com/t/advance-relations-challenge/79294/7 "2025-01-19T20:39:33Z")
That is a GREAT idea! I’ll implement it. ---
**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:** [January 26, 2025, 8:39pm UTC](https://community.glideapps.com/t/advance-relations-challenge/79294/8 "2025-01-26T20:39:56Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.