# Select data/rows with same date

**URL:** <https://community.glideapps.com/t/select-data-rows-with-same-date/62517>\
**Category:** Ask for Help\
**Created:** [June 6, 2023, 10:44pm UTC](https://community.glideapps.com/t/select-data-rows-with-same-date/62517 "2023-06-06T22:44:25Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![LoloCmoi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lolocmoi/32/60056_2.png) [@LoloCmoi](https://community.glideapps.com/u/LoloCmoi)\
**Post date:** [June 6, 2023, 10:44pm UTC](https://community.glideapps.com/t/select-data-rows-with-same-date/62517/1 "2023-06-06T22:44:25Z")

</div>

Hi,  
In my glide, a form is used several times per day. Every time, a row is created with a column containing date, and another contain a number.  
I would like to calculate the sum of these numbers for each day, and in a new table create a row per day with two columns : day and sum.  
And all of these automatically : when the form is used a new day, a new row is created, and the sum grows during day.  
I don’t know if my idea is understandable.  
Sorry for my english, I’m french.  
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:** [June 7, 2023, 12:27am UTC](https://community.glideapps.com/t/select-data-rows-with-same-date/62517/2 "2023-06-07T00:27:08Z")

</div>

Please do these steps:

- Create a query column on that table, filter by “day” is within “this row \> day”.

- Create a rowID column.

- Create a single value column, returning the first rowID from the query column.

> [@LoloCmoi](#):
>
> and in a new table create a row per day with two columns : day and sum.

This will be used as a “unique” function that won’t make you create another table.

- Create a rollup column on top of the relation, returning the sum of the “number” column. You now have the sum of each day.

- Show a collection of that table, filter by rowID equals the “single value” column, and show the sum from the rollup column.

---

<div class="post-metadata">

**Author:** ![LoloCmoi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lolocmoi/32/60056_2.png) [@LoloCmoi](https://community.glideapps.com/u/LoloCmoi)\
**Post date:** [June 7, 2023, 4:50pm UTC](https://community.glideapps.com/t/select-data-rows-with-same-date/62517/3 "2023-06-07T16:50:57Z")

</div>

Thanks a lot! It’s perfect!  
It’s difficult for me because there is not user manual in french, so sometimes I don’t find what I search.  
I hope I will not ask too much questions.

---

<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:** [June 7, 2023, 11:56pm UTC](https://community.glideapps.com/t/select-data-rows-with-same-date/62517/4 "2023-06-07T23:56:09Z")

</div>

Don’t worry, just ask questions here and we’ll try our best to help! Hope the solution above is easy for you to apply.

---

<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:** [June 8, 2023, 11:56pm UTC](https://community.glideapps.com/t/select-data-rows-with-same-date/62517/5 "2023-06-08T23:56:27Z")

</div>

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