Add rows to multiple tables for each date in a range

[James_Plouffe]

I have a trip planning document which uses a Form view of a table to capture some basic details of the trip (see the Data Setup page in Copy of Trip Planning Template) including the departure date and the overall duration (in days).

I would like to automatically add a row for each day of the trip to other tables in the document (e.g. the [Distance, Time, and Calories] table on the Route Planning page and the [Daily Meal Details] table on the Meal Planning page) once the form has been completed. The start date, of course, is given. The end date is easy to calculate based on the form input. I would like to get each of the dates in between and automatically create rows for them.

Thanks
/JP

[James_Plouffe]

Found a solution from a combination of places.

First, some helpful guidance on getting dates in a range:

Count specific weekdays between two dates / date range

I am trying to count the number of particular Weekdays between two dates. For example I want to know how many Sundays there were between DayX and Today(). I tried to use a formula like this: Countif(Weekday(Sequence([DayX],Today())),CurrentValue=1). However, looks like Weekday formula does not operate on a list, only on a specific date input. Do you have any suggestions how to run this so it works? Bonus question: what equation would be if I wanted to count multiple types of weekdays (for exam…

Second, some help advice on simulating a For loop:

Simulate a For Loop (Reference position inside FormulaMap)

So I was struggling with a problem where I needed to evaluate multiple lists simultaneously. A classic use case for a loop. Coda doesn’t have built-in formulas for classic loops such as for or while. The closest thing being FormulaMap. It takes a list as input and runs every item through an expression. Inside the expression, you use CurrentValue to reference the current item being evaluated. As a result, CurrentValue can be of any type (row, date, etc). But there’s no obvious way to get the ke…

Then I just added an Automation Rule to the document which runs every time the form is completed:
Sequence([Trip Info].[Departure date], [Trip Info].[Return date]).FormulaMap(AddRow([Distance, Time, and Calorie Estimates], [Distance, Time, and Calorie Estimates].Date, ToDate(CurrentValue)).List())