Oct 12, 2018 11:21 AM
I have a table where I want all new entries (rows) to have a default value for a single select column. Is that possible?
Solved! Go to Solution.
Mar 16, 2023 05:38 PM
Good news, this launched as a feature today! Now you can set a default value on any single select field.
Oct 12, 2018 03:29 PM
Unfortunately, there’s not. Single Select is one of the many fields that currently do not have a default value option where one would be very nice. I believe there’s a #feature-requests addressing this out there already. You might consider looking it up and adding your support there.
Oct 13, 2018 03:28 AM
Hi Karl
This is unfortunately the case - there is a possible solution (work around really) available to you by using Integromat or Zapier. Using either, you could watch for new records where this field is blank and fill it in. The only downside is that this wouldn’t be instant of course.
Hope this helps?
Jan 21, 2019 01:16 AM
I see there has been a feature request for this for several years!
Feb 25, 2019 03:34 PM
Bump, this is something thats pretty important!
Mar 06, 2019 04:04 PM
There is a bit of a workaround that works for me. Group by the column you want the default value in and add new records in that group… for Example, I have a column called “Status”, every new record should default to “Planned”. After adding the Status column to the grouping, I now add new records under the “Planned” group.
May 20, 2019 04:27 AM
This is genius, thanks !!! Worked for me aswell and the view is much cleaner also.
Jun 21, 2019 06:39 AM
I really would like this default feature myself. Please consider it. I don’t see a downside to doing it.
Aug 26, 2019 01:38 AM
Multiple requests for this basic feature since 2016, please keep us updated on the status.
Thanks.
Aug 27, 2019 05:35 PM
Can the Airtable team update us on the status of this feature request?
Sep 09, 2019 04:52 PM
Just chiming in as a new Airtable user: single select default would be a very useful feature. Having the grouped by workaround is nice, but having the option to set a default would be even nicer.
Sep 19, 2019 12:35 PM
How is this not a feature? We’ve been waiting for 3 years now for this.
Jan 01, 2020 03:37 PM
I made a tool that solves this problem. You define a default value, and then the tool will periodically update empty rows with the default value. Works with single select, multiple select, linked records, attachments, etc.
Jan 14, 2020 07:30 AM
Just started using Airtable and that lack of default for single selects seems a major omission so I’m added my voice to the clamour for this.
Jan 23, 2020 07:04 AM
You can also create a computed column in addition to the column that you want to default using the “Formula” type. For example, I have a “Status” column that is my single select and a “Computed Status” that is a formula. My formula is IF(Status = “”, “Lead”, Status).
Feb 12, 2020 09:19 AM
2020 - Please add this in!
Feb 25, 2020 12:28 PM
I agree, this is absurd. Every single form builder and database I have ever used has this option. On the free version of air table right now. Super basic functionality they’re missing is causing me to never want to pay…
Feb 25, 2020 02:02 PM
I agree that this missing functionality is frustrating.
However the workaround described by @American_Appworks on Jan 23 works fairly well.
Here is a slightly modified version of the formula:
IF( {SingleSelectField} = BLANK(),
"default value",
{SingleSelectField}
)
Feb 25, 2020 06:36 PM
Hi @kuovonne. Loving that I just came across the same challenge and youve posted a solution today!
Pardon my novice use of formulas in AT. but how do U define “SingleSelectField”?
Scenario - lead generation from SMS using zapier and click send. Basically a new record is inserted when an sms response is received (works super well) I then want the ‘STATUS’ field default (inserted as null/blank) to be set to NEW. Then all the team need to do is use a drop down to change to either ‘closed/dead’ 'booked" or ‘call back’
Appreciate your guidance in advance.
Russell (from Australia)
Feb 25, 2020 06:44 PM
Ok. worked it out. You need to create a new column with the formula and SingleSelectField = the name of the field that has the dropdown. which kinda means I need to show 2 fields “Current Status” (formula field and “Change Status” (single select field).
Does that sound right?