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 🙂
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.
I just read the following on the use of "contains" elsewhere on the board:
"Has any of" requires linked records or lookup values in Airtable. On the other hand, "contains" is a string operator which works in various conditions.
Was also wondering if contains was case-sensitive, or possibly being confused by the "/" character in that particular name.