Newbee to automations here and would like to hear if I’m doing this right because it feels wrong
I added a couple of automations which change a status field based on conditions. So as “Action” I select “Update record”, select the table and record ID from the trigger.
But then when I add the fields to be changed and I select the “Status” field (which is a Single Select field type), I just get an free type text field instead of a dropdown with the labels/options from that Status field.
This seems to work fine as long as I type in the exact words/phrase used for the single select options, but if somewhere in the future someone changes the dropdown labels/options, this will then immediately break the automation without any kind of warning.
(well it wouldn’t “break” the automation in the sense that it would still run, but the automation would just keep using the old label which could cause all kinds of unintended things).
So… Is this indeed the way to create these kinds of automations in Airtable or is there a more foolproof solution?