+4https://www.loom.com/share/75e6d81b7dc7414d9bdd62eba0e7f791?sid=a551b367-107b-4d5e-b2e3-c5573874cf5c
Steps:
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
Best answer by TheTimeSavingCo
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. 🙏
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!
+31This 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
+4This 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
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. 🙏
+31Here'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. 🙏
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!
+4LOVE IT!!!
I was thinking it was a conditional logic thing, but I couldn't find it. Thanks so much! ✌️
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.