Save the date! Join us on October 16 for our Product Ops launch event. Register here.
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.
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?