Building an Itinerary: Automating Date Increments in Glide

[Jeff_Hager]

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?

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.