I am trying to create a sequence of automations and every time I think I might have it, it's not working as I would like, after closer inspection.
The automations involve 3 apps: Speaking Engagements, Projects, and Tasks. Here is what I'm trying to do, in this order.
User submits form to add record to Speaking Engagements.
Automation creates new record in Projects, based off form submitted to Speaking Engagements.
Automation creates a record in Tasks that references fields in the newly added Speaking Engagement Record AND links back to newly created project created in step 2.
The problem that I am running into is that the automation I've set up to auto-generate the record in Tasks, is currently triggered by a record being updated in Speaking Engagements, which causes TWO duplicate tasks to generate. The first task is created when the form is submitted, and is not linked to the project. The second task is created when the record in Speaking Engagement is updated with the link back to the project that was created in step 2. This second task has the Project linked to it (which is what I want).
How do I get the automations set up so that only the second task is generated?