set order by with automations are triggered

[mirkolando]

Hi Airtable Community,

I have a base with different automations with the same trigger. I would like to set an order by with these automations are triggered.
For example, I would like Automation one to be triggered first. After automation 1, the automation 2 should start immediately.

the easiest would be, to just add another “Find records” and another Repeating Group in this automation. Unfortunately, its not possible to add anything behind a repeating group.

I Want specific phases and tasks for projects to be generated. Both needs to be linked to the project and the tasks should be linked to the phases. To do so, I need the phases to be created first (trigger=new project meets condition). After that, I need the tasks to be created and linked to the phases. When both automations start at the same time, some of the tasks are not properly linked because the phase was not created yet. (see Screenshot). 

Can anyone help me with this? 

Best

Mirko 

[TheTimeSavingCo]

Hmm, perhaps Record Templates might come in handy here? https://support.airtable.com/docs/using-record-templates-in-airtable

If not, may I know what problems you faced setting up the task creation automation to trigger when the phase record got created?

[mirkolando]

Hi @TheTimeSavingCo, 

thank you for your quick reply. 

I found a solution. I added a "count phases" column and triggered the second automation, when all phases are created. 

But i faced another problem.

Now i have all tasks linked to the phases. Every task has a start and a end date. i would like the start date of the phase, be the earliest start date of the linked tasks and the end date should be the latest end date. 

Any Ideas?

Best regards

Mirko  

[Pascal_Gallais-]

Hello,

You can do this with rollup type fields:

Tickets in this example would be your task table and entry date would be your task start date.

For the phase end date rollup field, do the same using the "MAX" function.

Regards,

Pascal

[mirkolando]

Hi @Pascal_Gallais- 

thats an awesome function. Never used it. Thank you very much!

[Pascal_Gallais- · Accepted solution]

Hi Mirko,

If it did answer the question, could you mark it as solved to close the subject?

Thanks

Pascal

[mirkolando]

@Pascal_Gallais- would it also be possible to do the same for the status of the phases? 

For example: if all the tasks are in status done, the phase should be in status done. When one of the tasks are "in progress" the others are in "to do" the status of the phase should be "in progress". 

[Pascal_Gallais-]

Hello Mirko,

You can do it this way:

Field "satuses" is a rollup field:

Field Status is a formula :

IF(FIND("In Progress",statuses)>0,"In Progress",

IF(FIND("To Do",statuses)>0,"To Do",

IF(statuses="Done","Done"

)))

You could do it all in the Rollup field, but I find it easier to maintain when separated in to fields.

[Blake_D]

If you create dependencies for the phases and tasks, you can set up an automation to when any predecessor phase or task is changed to "Complete" then the successor phase/task is changed to "In Progress", or when all tasks under a phase are "Complete" then the phase is changed to "Complete".  In the pictures the "Asset" can be changed to "Phase" with the tasks linked to it and using a lookup field for status trigger.