Add rows to multiple tables for each date in a range

[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())