Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 10, 2019 05:30 AM
Hi,
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.
Thank you
May 10, 2019 08:06 AM
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.
Aug 23, 2019 06:48 AM
I’ve seen dozens of people on this board asking for this basic feature as early as 2016, how come is this still not implemented?
Nov 21, 2019 03:00 AM
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’.
Jan 10, 2020 11:37 AM
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.
Jan 13, 2020 07:22 AM
5$ per month! …
I wonder if all functions were to cost 5$ how much wed pay in the end…
Jul 15, 2020 03:16 AM
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!
Jul 24, 2020 10:48 AM
If they ever do it, they’ll make you go to a high pricing tier to get it. I mean, if they want you at the highest tier just to be able to bold a field, you know that’s how this will go.
Sep 15, 2021 10:47 AM
Please add this basic feature @airtable, it’s needed for so many projects…
Dec 21, 2021 06:58 AM
You can do this with an automation to set a field value upon a new record being created (or form being submitted if that’s the case).