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.
Possible to setup a 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.
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.
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.
