# List Unique Dates in Rows

**URL:** <https://community.glideapps.com/t/list-unique-dates-in-rows/81834>\
**Category:** Ask for Help\
**Created:** [May 12, 2025, 10:07am UTC](https://community.glideapps.com/t/list-unique-dates-in-rows/81834 "2025-05-12T10:07:33Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Curtis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curtis/32/59826_2.png) [@Curtis](https://community.glideapps.com/u/Curtis)\
**Post date:** [May 12, 2025, 10:07am UTC](https://community.glideapps.com/t/list-unique-dates-in-rows/81834/1 "2025-05-12T10:07:34Z")

</div>

I have a table of costs with the date the cost was received.

I’d like to create some more tabs where users can see the costs grouped by the date received.

I’m aware of the Group by options but this doesn’t achieve what I’m looking for.

Is it possible to have a separate table with a row for each unique date in the costs table? I can then create a relation and will have much more flexibility.  
If there’s a column type which can achieve this besides using a looping workflow to create rows that would be good.

---

<div class="post-metadata">

**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:** [May 12, 2025, 10:26am UTC](https://community.glideapps.com/t/list-unique-dates-in-rows/81834/2 "2025-05-12T10:26:26Z")

</div>

Yes, you can do that with a helper table.

Before starting, I would advise checking the actual date values to see if they also include different times. If they do, then I would first use a math column to convert them to integers using the following:

```auto
Year(Date)*10^4
+Month(Date)*10^2
+Day(Date)

```

- In your helper table, add a RowID column and add enough empty rows to cover the maximum number of unique dates.
- Number your rows beginning at zero using the Lookup-\>Find Element Index method.
- Add a Lookup column that targets all of the Dates. This will give an array containing all dates.
- Add a unique elements column that targets the array of dates
- Add a Single Value column that targets the unique array, taking N from start where N is the row index. This should give you a list of unique dates, one per row.
- You can then create a relation or query back to your data table, and add whatever rollups you need to aggregate the data by date.

---

<div class="post-metadata">

**Author:** ![Curtis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curtis/32/59826_2.png) [@Curtis](https://community.glideapps.com/u/Curtis)\
**Post date:** [May 12, 2025, 10:31am UTC](https://community.glideapps.com/t/list-unique-dates-in-rows/81834/3 "2025-05-12T10:31:40Z")

</div>

> [@Darren\_Murphy](#):
>
> Lookup-\>Find Element Index method.

Thanks Darren,

Could you clarify the setup for the Lookup-\>Find Element Index method.

---

<div class="post-metadata">

**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:** [May 12, 2025, 10:36am UTC](https://community.glideapps.com/t/list-unique-dates-in-rows/81834/4 "2025-05-12T10:36:50Z")

</div>

See the second use case below:

> [@How do I create an auto-incrementing row number with Glide Tables?](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572):
>
> This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…

---

<div class="post-metadata">

**Author:** ![Curtis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curtis/32/59826_2.png) [@Curtis](https://community.glideapps.com/u/Curtis)\
**Post date:** [May 12, 2025, 10:41am UTC](https://community.glideapps.com/t/list-unique-dates-in-rows/81834/5 "2025-05-12T10:41:38Z")

</div>

Perfect thanks!

---

<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:** [May 19, 2025, 10:42am UTC](https://community.glideapps.com/t/list-unique-dates-in-rows/81834/6 "2025-05-19T10:42:24Z")

</div>

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