# Building an Itinerary: Automating Date Increments in Glide

**URL:** <https://community.glideapps.com/t/building-an-itinerary-automating-date-increments-in-glide/77135>\
**Category:** Ask for Help\
**Created:** [October 16, 2024, 1:25pm UTC](https://community.glideapps.com/t/building-an-itinerary-automating-date-increments-in-glide/77135 "2024-10-16T13:25:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![yaniv\_fogel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yaniv_fogel/32/77555_2.png) [@yaniv\_fogel](https://community.glideapps.com/u/yaniv_fogel)\
**Post date:** [October 16, 2024, 1:25pm UTC](https://community.glideapps.com/t/building-an-itinerary-automating-date-increments-in-glide/77135/1 "2024-10-16T13:25:04Z")

</div>

Hi Gliders, thanks for your help!

I’ve built a UI to add new rows to a Glide table, and I’m working on an itinerary. For the date column, I want each new row to reference the previous one and automatically increment by one day. For example, the first row will have a manually defined date, but for each subsequent row (which I’m creating one by one), I want the date to increase by one day based on the previous row’s date.

Is this possible with the UI I built? Currently, I’m changing dates manually.

thanks, Yan.

 ![Screenshot 2024-10-16 at 16.20.17](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/e/4ec61c113d9132ed292fedca255716e1c669329f.png)

---

<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:** [October 17, 2024, 12:02am UTC](https://community.glideapps.com/t/building-an-itinerary-automating-date-increments-in-glide/77135/2 "2024-10-17T00:02:08Z")

</div>

Possible to setup a [Make.com](http://Make.com) flow for this in my opinion, have a start date and a number of days, then loop until the counter reaches the number of days to add as many rows as needed.

If it’s solely in Glide, you have to get access to Call API, and build the API call’s body yourself.

---

<div class="post-metadata">

**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:** [October 17, 2024, 12:47am UTC](https://community.glideapps.com/t/building-an-itinerary-automating-date-increments-in-glide/77135/3 "2024-10-17T00:47:42Z")

</div>

I would recommend following use case #2 in the following post, up to the point where you get a sequentially number index number starting at 0 and counting up as you add rows.

> [@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…

Once you have that index number column, add a basic date column to accept a date and populate it with a date in the first row. Then add a single value column to populate that date on all rows. Finally add a math column with a formula to add the row index number to the date. That should be it.