Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Default value for single select column?

Solved
Jump to Solution
39678 62
cancel
Showing results for 
Search instead for 
Did you mean: 
Karl_Berggren
4 - Data Explorer
4 - Data Explorer

I have a table where I want all new entries (rows) to have a default value for a single select column. Is that possible?

62 Replies 62
Attila_Fulop
4 - Data Explorer
4 - Data Explorer

Just discovered Airtable. Really neat tool. Strongly considering to become a paying customer and take our team of 7.
Field defaults feature is the very first thing I had to google for after I started transferring an existing app from google sheets/scripts. It should really be available, Airtable.

Oddly, some field types give you the ability to specify a default field value, but not others. For the others, you can now do it with Airtable Automations. Not the ideal workaround, but it definitely works.

I became a paying customer anyway :slightly_smiling_face:
Albeit I can live without defaults for select columns, it will be a nice addition once it’s gonna happen.

mdmtr
6 - Interface Innovator
6 - Interface Innovator

Just adding my voice to this. Workarounds like Kuovonne’s are possible but this basic feature should be available. C’mon Airtable, it couldn’t possibly be this hard.

Casey_Nave
4 - Data Explorer
4 - Data Explorer

I was able to work around this in three ways. Sorry if i don’t type my explanation out well:

  1. In form view, limit the number of “available” options to select and just pick the one you want to default to. Select ‘drop down’ and boom, its the only option by default in that form.
  2. Automation - Trigger - On New Record. Action - Write " Default " for field xx
  3. When grouping by a field, any new record in that grouping will default to the values of the fields grouped there by.
JM1234
6 - Interface Innovator
6 - Interface Innovator

+1 on this as a feature

Joseph_Leveque
5 - Automation Enthusiast
5 - Automation Enthusiast

This would be a really nice addition! Have to go around with an automation for now

Brett_D
6 - Interface Innovator
6 - Interface Innovator

About time please Airtable!

Joanathan_McInt
4 - Data Explorer
4 - Data Explorer

+1 on adding this feature.

Andre_Oldani
4 - Data Explorer
4 - Data Explorer

+1 for this simple yet powerful feature