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