I have a table with a single select field called “Status” that has 3 values (Pending, Refused, Granted)
I want that every new record to be receiving default “Pending” value and i also want to be able to change it afterwards to either Refused or Granted.
Not a default per se, but if you group your view by the single select field, then you can click or use SHIFT+ENTER to create a new record within any group, and it will have the given single select value by ‘default.’
Currently, selecting a default single select option is not possible.
I use another workaround:
Now, setting the value of StatusFlag to 0,1 or 2 will result in the Status column displaying ‘Pending’, ‘Approved’ or ‘Rejected’. Because the StatusFlag has a default value of 0, all new records will be ‘Pending’.
You can use this tool that we built:
A tool to automatically set a default value for ANY field on Airtable. Works with Linked records, single & multi select, etc. Supports scheduling & webhooks.
Looks like a lost cause to try to get the default option on single select list unless we pay for this most basic feature or very clunky work around. Maybe I should start looking for other solutions and I suggest all new comers to do the same as well unless you want to pay through your nose!