I’ve been loosing my mind over the past days trying to find a way to either solve this automation or find an alternative even if it requires a manual check.
However it got to the point where I am willing to pay for much needed dedicated help.
Here’s the situation:
I have 2 Bases.
The first one is a very simple setup on a free plan where collaborators drop basic input: Airtable - Registro de Producciones (that’s it, nothing fancy here).
The second base is on a different workspace on a Pro account. I’m using the Sync feature to pull the data onto this Base.
Create a new linked record when the field of either “Videographer”, “Photographer”, “Producer” or “Videographer 2” is not empty.
Add an Emoji to represent their role (this is very important because of other formulas running behind everything)
- Update records whenever a collaborator modifies the role on free plan base.
- I’ve managed to trigger the automation to create the new linked record adding the corresponding emoji.
Records are created correctly, but then they changes
Example : https://vimeo.com/546732758/e8bcdbb485
When updating a record, it changes other recods as well:
Example : https://vimeo.com/546733130/d4c0fb0eee
I would appreciate any experts recommendations you could provided. I’m thinking perhaps we can tackle this in a single video call session.