Hi all,
just to 100% finish this subject, I helped @Piyush_Patil with automatic creation of his Date & Time table, using @Agile_Dynamics trick for a while loop, as it does not seem possible to run Multiple ForEach() https://community.coda.io/t/simple-while-loop-in-coda/29748
Then, OP has Date and Time he wants to fill with several date, and several times for each date. Then I created a TimeWithinDay Table, and also a creation table with :
- start date
- end date
- some button and variables related to the while loop
The master creation formula is this one
- As long as the difference between the “loopDate” and the EndDate is positive or equals to 0 I start a ForEach() loop on the TimeWithinDays table, I create as many rows in the master table, with the current time (CurrentValue) of TimeWithinDay table, and the current “LoopDate”. When I’m done, I change the value of loopdate to +1, and start the while loop again until LoopDate reaches end date.
To prevent issue, I ask the user to be sure that loopdate=startdate before I launch the main button
Quite scalable !!!
Here we go :
I think this subject has been seen quite deeply now 