Automation - updates field and also deletes content but doesn't stay deleted

[leepettijohn]

https://www.loom.com/share/75e6d81b7dc7414d9bdd62eba0e7f791?sid=a551b367-107b-4d5e-b2e3-c5573874cf5c

Steps:

• Enter a role required to be at an event
• Finds people associated with that role
• Updates people required at the event

When I delete the role required, the automation seems to run twice and deletes the people required, but then adds everyone associated with that project, and when I check the Run History, it only runs once.

Any idea what's going on?  Thanks in advance

[TheTimeSavingCo]

This is pretty difficult to troubleshoot without seeing how the automation's setup

Could you create a duplicate of your base with no records in it and provide a read only link? That will help a lot with helping you with this, and here's a guide on how to duplicate your base without records as well as providing a read only link:
https://support.airtable.com/docs/creating-a-new-empty-base#duplicating-airtable-bases
https://support.airtable.com/docs/creating-airtable-base-share-links#sharing-an-entire-base

[leepettijohn]

Here's the read-only link - https://airtable.com/appsF92oFdffe1dVi/shrDK7gRuQ4CEY2lZ

I don't think you can see the Automation, so I added the screenshots here

Thanks for your help.  🙏 

[TheTimeSavingCo · Accepted solution]

Thank you very much for the automation screenshots as well as the link!  I think the issue might be occuring due to the fact that, when we run the "Find Records" step with the "Role Categories Required" field empty, it returns everything in the "Casts and Crew" table

To overcome that I've created a conditional that checks whether it's empty, and if it is it'll just clear out the linked field:

Link to base

Should do what you need now I think!

[leepettijohn]

LOVE IT!!!

I was thinking it was a conditional logic thing, but I couldn't find it.  Thanks so much!  ✌️