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?