Adding days by row

Hello,
In the spreadsheet,
it is very easy to add days in each row based on the input of the planned number of days as shown in the image below.


My question is how to do it with tables inside Glide? Thank you.

You want to count the number of days between Start and End?

Just use a Math column with the formula End - Start

Thank you for the quick response Darren,
End day is start + days -1, and the new start day on the next row is end + 1. This is a flow calculation.
The user is only allowed to input the duration of the day.

use math column to add days to a date, make sure all dates are in date format

ah, I see.
But isn’t that simply a matter of taking the values from the existing (last) row, and using those together with the input number of days to calculate the values for the new row?

Am I still missing something?

Maybe Darren has caught my point because my English is bad, I try to explain again.
This is a Gantt Chart model date calculation where the start date is added vertically based on the input day duration. Horizontal addition of course can be done in Glide, but I can’t find a way how to move it vertically on the next row of the start day.

oh… you wanna calculate the next row in a glide? that impossible… it takes really big workaround to make it happen

okay, I’m starting to understand.
Is the data added one row at a time, or are you looking for a way to add all rows at once? (with a single action)

1 Like

Can we try it? Or maybe there are features that need to be completed by Glide, of course, there is no need to go through a big workround.

Right :sweat_smile:

let me understand it better… you wanna add the next row with a calculated date? that is easy… or you wanna calculate existing rows based on the previous row? that’s hard…
in your google sheet screenshot I see that the next row is calculated based on days in the middle… but these days are existing or you are adding them one by one?

Which one is right?

One row at a time?
Or all rows at once?

When the user inputs the duration, it will be gradual from top to bottom, starting from the initial start of the project for the first activity item. This will return the first end date, then add one day to the second line start date. Here the user needs to input the second duration to generate the second end date, and so on.
Is this what is called one row at a time, I didn’t define it? Without input duration, all will not be filled alias empty.

InkedScreenshot 2021-12-21 091550

Okay, I get it now. And I think it should be doable. Once you have the first row, then each time a user adds the number of days you would have an action that does two steps. Firstly a Set Column values on the current row to update the End Date and the number of days, and then an Add Row action to create the next row with a calculated Start Date.

I don’t have time right now, but I can see if I can make an example sometime later today.

1 Like

Very appreciated.
In addition, I expect your solution for the start and end date columns to be written back into the spreadsheet, as these have links to several other sheets. I hope my expectations are not too much. Thank you.

try if that’s what you are looking for?

is my sample good?

Thank Uzo, I will learn it later…

1 Like

the screen is empty???

Looks like you’re getting close, and are you currently doing maintenance? Now I’ve managed to open and try it then all the lines are gone again.
Do you use a custom form and fill it with values from a math column?

I will try again.