Re: Automation to assign Airtable users when a record is updated in a linked field

478 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I'm trying to set up an automation in a base that will manage grant application and status reporting deadlines. 

I want the trigger to be when the field linking to the program is updated to automatically assign the appropriate team members. My setup is below, and the automation says it ran successfully, but it did not perform the action. What am I doing wrong? 

Programs.pngTeam Members.pngTrigger.pngAction.pngAutomation Run.png

2 Replies 2
8 - Airtable Astronomer
8 - Airtable Astronomer

Is your "Programme Name Value" field a formula derived from the link field? If so, it may be that the automation is working faster than the formula.

What this means is that when the automation runs to the conditional steps, nothing is in that formula field YET for it to know which condition to take. You may be able to change the conditions to read the link field directly.

Let me know if this was the issue 🙂

Hi, no, it is not a formula. It is just a link to another table. I've tried using both the linked field and the lookup field to see if that makes a difference, and it is not working either way.