Skip to main content
Question

Planning tool

  • November 17, 2025
  • 1 reply
  • 24 views

Forum|alt.badge.img+1

Hello, 

 

At the moment we have our planning tool in google sheet - per name / per day / what to do (fixed sessions per week) 
I want to add the planning to my airtable base (which i have done now) BUT:
at the moment i have per day - per person - per week 
But if i have to change the date every week - it will be a task extra 
How can I do this so that I have a planning for weeks/ maybe months etc.. 

1 reply

TheTimeSavingCo
Forum|alt.badge.img+31

Hm, this depends a lot on the tasks that you want to create I’m afraid

I’ve created an example base here that assumes we want to create 5 tasks per week, one week in advance and here’s a gif of the automation being triggered via a checkbox

If you could provide some screenshots of your tasks and examples of what you’d want to create and how much in advacne you’d want them done I’ll see what I can do to help!

In practice, this automation would:

  1. Trigger on Sunday night
  2. Look for the latest 5 Task records
    1. This is done by using a Find Record step like this:
    2. We set the maximum record limit to be 5 to grab the latest 5, and the view ‘Latest to Earliest’ is sorted by date descending:

       

  3. We then add a Repeating Group step that will create one record per found record and with the new date:
    1. And the field ‘Date + 1 week’ is set up as. formula field that adds 1 week to the current record’s date:

      1. DATEADD(Date, 7, 'days')