# How to dynamically change price of product based on the users size selection?

**URL:** <https://community.glideapps.com/t/how-to-dynamically-change-price-of-product-based-on-the-users-size-selection/53661>\
**Category:** Ask for Help\
**Created:** [November 9, 2022, 12:26am UTC](https://community.glideapps.com/t/how-to-dynamically-change-price-of-product-based-on-the-users-size-selection/53661 "2022-11-09T00:26:50Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Linda\_De](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/linda_de/32/36787_2.png) [@Linda\_De](https://community.glideapps.com/u/Linda_De)\
**Post date:** [November 9, 2022, 12:26am UTC](https://community.glideapps.com/t/how-to-dynamically-change-price-of-product-based-on-the-users-size-selection/53661/1 "2022-11-09T00:26:50Z")

</div>

I have build an app for an organic buying coop and it works really well, but I am looking to add products that have size variations such as 200g, 1kg, 25kg with different price points. I would really like the user to be able to select the size from a choice option and then the price changes based on the selection.

I have searched this group and google but haven’t been able to find a solution, so wondering if this can bed done? 🙏

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [November 9, 2022, 1:13am UTC](https://community.glideapps.com/t/how-to-dynamically-change-price-of-product-based-on-the-users-size-selection/53661/2 "2022-11-09T01:13:55Z")

</div>

Certainly possible. As long as you have a unit rate, you’d just use a math column to multiply the unit by the rate and display the answer to the end user.

---

<div class="post-metadata">

**Author:** ![Linda\_De](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/linda_de/32/36787_2.png) [@Linda\_De](https://community.glideapps.com/u/Linda_De)\
**Post date:** [November 9, 2022, 1:27am UTC](https://community.glideapps.com/t/how-to-dynamically-change-price-of-product-based-on-the-users-size-selection/53661/3 "2022-11-09T01:27:30Z")

</div>

Thank you Robert for your answer but unfortunately the unit rate is different based on the sizes as it gets cheaper the more you buy. For example

Plain Flour

- List item 1kg $4.95

- List item 5kg $22.25

- List item 25kg $77.50

So I am not sure if I can use columns on the product line on the google sheet to list the prices and sizes separately and this can then be used to offer a choice? Currently I just use rows and the items are listed separately on the app with the different sizes. I am just wondering whether I can have an option to select size and then the price shows?

![Screen Shot 2022-11-09 at 11.26.14 am](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/8/08c76673dcb787077958382b7a12257ccb38aa65.png)

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [November 9, 2022, 1:43am UTC](https://community.glideapps.com/t/how-to-dynamically-change-price-of-product-based-on-the-users-size-selection/53661/4 "2022-11-09T01:43:20Z")

</div>

Yes, have one table for items (with an item id) and another table for item variations (with item ids and prices). Create a multiple relation linking the two tables. On the form screen, point the choice component to the relation.