- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 19, 2024 05:27 AM
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
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 21, 2024 02:28 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 20, 2024 12:50 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 20, 2024 04:34 AM
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. 🙏
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 21, 2024 02:28 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 21, 2024 04:32 AM
LOVE IT!!!
I was thinking it was a conditional logic thing, but I couldn't find it. Thanks so much! ✌️
