Generate a record for each day in the month with a pipeline

Here's a stupid simple approach for those who are not into fancy Jinja looping syntax.
Make a helper table with 31 records in it. Number the records in a field called [Day #] from 1 to 31.

Make a formula field to calculate the date of the current month.  Call it [Date]. 

Today() + Days([day #]-1) 

Make a Checkbox field called [Day is in current month?]

Month(Today()) = Month([Date])

Then have a pipeline run every month to search that table every month for where the 
[Day is in current month?] is yes and then FOR EACH Loop to create a record in the target table. 


​​​

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------