Recurring Task and Sub Task once completed, duplicate with a different due date

[DennisyuTSS]

I've built a task list table, and have some recurring tasks that comes with sub tasks in another table that are linked.

I am hoping that when my Task is completed, airtable will create the exact same task, except to change the dead line based a formula field, and link up to a new set of sub tasks also created once this main task is done.

I am doing this because I want to keep record of when the records were completed, using the last modified date field.

Is this possible?

[TheTimeSavingCo · Accepted solution]

Hm I think so.  Your automation would trigger once the "Status" was set to done and it would have a "Create record" action

I assume you have a field that indicates the start date of the task somewhere?  If you don't you'd have to add one in, and you'd place the last modified date field's value into this "Start date of task" field, which your "Deadline" formula field would reference to calculate the deadline based on the start date

For the subtasks, you would use repeating group functionality and create one record per subtask record linked to the triggering record

This should do exactly what you need I think

[DennisyuTSS]

Oh this is wonderful, thank you!

then create the new record in the main task accordingly.

Thanks Adam