Automating tasks - script

Hi all,

I’m creating a task management Airtable and want to be able to create periodic tasks. I think this can be achieved by Automations - using something like the ‘due date’ is passed or ‘complete’ is ticked as the trigger. It’s at this point I’m out of my depth as I think I then need to run script to copy the trigger record and add a new due date.

Is anyone possibly able to help please? I would be prepared to pay someone if they want a little consultancy task to help me out.

Many thanks!