Forum Discussion
MarkShnier__You
Qrew Legend
3 years agoHere'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)
[email protected]
------------------------------
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)
[email protected]
------------------------------