# Create a price charting for very product

**URL:** <https://community.glideapps.com/t/create-a-price-charting-for-very-product/56872>\
**Category:** Ask for Help\
**Created:** [January 19, 2023, 1:17pm UTC](https://community.glideapps.com/t/create-a-price-charting-for-very-product/56872 "2023-01-19T13:17:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![shinken](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shinken/32/24658_2.png) [@shinken](https://community.glideapps.com/u/shinken)\
**Post date:** [January 19, 2023, 1:17pm UTC](https://community.glideapps.com/t/create-a-price-charting-for-very-product/56872/1 "2023-01-19T13:17:32Z")

</div>

Hello everyone,

I am with the idea for my project done in glide pages, create a price chart, where you choose the product or search for it and then it shows you how the price of this product has changed over time, number and graphics that facilitate reading.

I was wondering if there are some good practices that you can recommend to me, especially those of you who have done this in the past to do it in the best possible way.

Thanks.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 20, 2023, 12:34am UTC](https://community.glideapps.com/t/create-a-price-charting-for-very-product/56872/2 "2023-01-20T00:34:38Z")

</div>

The most straightforward way is to create a helper table where you store the product’s price over time.

For example:

| Product ID | Date | Price |
| --- | --- | --- |
| P001 | 2022-01-01 | $10.00 |
| P001 | 2022-06-01 | $12.00 |
| P001 | 2022-12-01 | $15.00 |
| P001 | 2023-01-01 | $18.00 |
| P001 | 2023-01-20 | $20.00 |

Then I imagine you can use a relation from the Products table to this helper table using the Product ID, and use a chart to display the change in price.

---

<div class="post-metadata">

**Author:** ![shinken](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shinken/32/24658_2.png) [@shinken](https://community.glideapps.com/u/shinken)\
**Post date:** [January 20, 2023, 12:53pm UTC](https://community.glideapps.com/t/create-a-price-charting-for-very-product/56872/3 "2023-01-20T12:53:49Z")

</div>

Thanks for the help! i can start with this example!

---

<div class="post-metadata">

**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 21, 2023, 12:54pm UTC](https://community.glideapps.com/t/create-a-price-charting-for-very-product/56872/4 "2023-01-21T12:54:41Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.