Skip to main content

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

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’ve seen dozens of people on this board asking for this basic feature as early as 2016, how come is this still not implemented?


I use another workaround:





  1. Create a column called StatusFlag


  2. Set the type of StatusFlag to Number. Set the default value to ‘0’


  3. Create a column called Status.


  4. Set the type of Status to Formula. Enter the following code:


    IF(StatusFlag=1,“Approved”,IF(StatusFlag=2,“Rejected”,“Pending”))




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:






Set Default Value for Airtable Fields - miniExtensions





A tool to automatically set a default value for ANY field on Airtable. Works with Linked records, single & multi select, etc. Supports scheduling & webhooks.


















It works with single select fields and you can schedule it to run regularly so that any new record is automatically filled with the preset value.


You can use this tool that we built:






Set Default Value for Airtable Fields - miniExtensions





A tool to automatically set a default value for ANY field on Airtable. Works with Linked records, single & multi select, etc. Supports scheduling & webhooks.


















It works with single select fields and you can schedule it to run regularly so that any new record is automatically filled with the preset value.


5$ per month! …


I wonder if all functions were to cost 5$ how much wed pay in the end…


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!


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?


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.


Please add this basic feature @airtable, it’s needed for so many projects…


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).


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).


I'm having a hard time replicating this, could you please tell me more about the specific steps involved


I'm having a hard time replicating this, could you please tell me more about the specific steps involved


1) At the top click on "Automations" (next to Data)
2) In the flow diagram, add a trigger. Set the trigger as "When a new record is created". In the side panel, choose the table where you will be adding new records. 
3) In the flow diagram, add an action. Choose "Update a record". In the side panel, choose the same table as above, and choose the record ID from the previous step (you will see it if you click on the "+" icon). Then choose the field you want to set a default for, and choose the default value.

I just did this and it works for me.


Reply