Hello! I’m new to Airtable but have a background in programming and am having a lot of fun setting up bases for my company.
One issue we’re running into: Many of the projects we want to track re-occur monthly and I’d like to be able to track tasks for each month separately so that when we look at our calendar we see everything laid out for the whole year, not just the upcoming month.
Is there an elegant way to do this? Or do I just have to make a “January - order supplies” task for every month individually?
I usually take a checkbox field as a trigger for an automation that copies the task, updates the start date (eg via DATEADD() formula) and updates the month (eg via DATETIME_FORMAT() formula with “M”) for sorting/filter options.
If you can script, that’s no doubt also an option.