I’m trying to use Airtable Automations to an update to a single select field that I use for status on my records.
I cannot see a way to tell my automation to change the value in this field to one of the pre-defined possible values for my status field, so I tell it to just use the name of one of my values.
The Automation then creates an entirely new status for my single select filed, with that name, so I wind up with a duplicate value in my single select field, and the record status is set to that duplicate value with an identical name, rather than to my desired value.
This means that my downstream automations triggered from that desired status do not fire, because the record is set to some new status which is completely separate, even though it has the same name.
How can I make my automation update the single select field value to one of my predefined possible values?
Solved! Go to Solution.
Thanks for the reply Mike, yes I’m performing a simple automation basically same as in the documentation you linked to.
Not sure in your answer are you implying that same spelling should result in it picking an existing field value?
I’m updating my field with a value that is the exact same spelling as for one of the existing options in my single select field, however it creates a new option for that field - the new option has exact same name and spelling as one of the pre-existing options.
Is there any way to make it use the pre-existing value?