Help

Re: Default value for single select column?

Solved
Jump to Solution
2941 0
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
Skylar_Nichols
4 - Data Explorer
4 - Data Explorer

+1 seems like a quick fix but its years later now maybe I’m missing something?

Joseph_Witzel
4 - Data Explorer
4 - Data Explorer

+1 on adding this feature

Stefan_Rickli
4 - Data Explorer
4 - Data Explorer

This is really the very first thing I googled after creating a few test records. Come on…

To create default values, you can use On2Air.

We have the default value option in both our On2Air Actions and On2Air Amplify apps.


With the Amplify app, you add the default values for your fields. Then every time you create a new record in Amplify, the default is automatically added.

Amplify is a record dashboard app that lets you customize how you view records, linked records, linked tables, and more. You can also edit and view any Google Doc, Sheet, or Slide directly inside Airtable.


The Actions app adds the default value as an automation.

With Actions, you also get an additional 60+ features that integrate with Airtable.

Features like creating Google Docs automatically with Airtable data, bulk create, edit, or delete multiple records, set default field values, copy fields, perform financial calculations, sync Google Sheets, and more.

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable
Ben_Frame
4 - Data Explorer
4 - Data Explorer

+1 for this feature request

Cristian_Bell
4 - Data Explorer
4 - Data Explorer

+1 for having a default value for single select.
Sure you can use automations - which we’re doing - or a formula field - which is an unnecessary extra field which makes things unnecessarily complicated. Or whatever grouping option.

None of them is really a good option though.

Luke_Newmeyer
4 - Data Explorer
4 - Data Explorer

Please do add this feature! I have multiple situations where this would solve my problem. I have setup an automation which gets me by. A default, however, is so much simpler

Barbara_Usack
4 - Data Explorer
4 - Data Explorer

UPVOTE! I agree with those above. I have a form that feeds one table. The table was originally two spreadsheets/projects that have been merged and are distinguished by the Origin field.
The form is specifically for ONE origin/project, not the other. I want the default drop down in the form to automatically tag the correct origin, rather than having the user choose. Even if told which one to choose they could get it wrong, user error and all. :winking_face:

BenR
4 - Data Explorer
4 - Data Explorer

I immediately searched for how to do this upon switching to Airtable. 5 years waiting for this?

2022, Airtable please, we need this! Doesn’t seem so complex though

Marcos_Polanco
4 - Data Explorer
4 - Data Explorer

+1. This is needed, people.

Steven_Alig
5 - Automation Enthusiast
5 - Automation Enthusiast

+1 However I assume that the devs must have a reason for not including this basic functionality. It is unfortunate that they do not answer :frowning_face:

mattt
4 - Data Explorer
4 - Data Explorer

Lol how is this not default Airtable functionality after being an active request for 4 years? Are alternatives like NocoDB more actively maintained?

Zacur_Cordova_M
4 - Data Explorer
4 - Data Explorer

Aún esperando la solución para eliminar la opción vacía de una columna Single Select o agregar una opción por Defecto.

Eric_Doty
4 - Data Explorer
4 - Data Explorer

+1 for this feature, please!

GREGOIRE_HABABO
4 - Data Explorer
4 - Data Explorer

+1 for this feature, please!

Raymond_O_Mahon
4 - Data Explorer
4 - Data Explorer

+1 to this request - using automations is frustrating especially as we’re limited in the number of automations per month - which is blocking my team. Really frustrating to not have default values…

AfterShock_Fam
4 - Data Explorer
4 - Data Explorer

I would just make a normal text field and name it "Add Email Form" / "Add Company Form" and then just pre-fill it with a static link!

That way they can add records on a different form and select it on the original form they are filling out.

 

I used this for Pre-Filling:

- Multi-Select Fields

- Single & Multiple Linked Records Fields (I use a an ARRAY formula in a rollup field for each Linked Record field & just put RID at the end for easy denotion)

- Hiding Pre-Fills

 

FORMULA:

{FORM URL} &

"?"&"&prefill_"&ENCODE_URL_COMPONENT("Email List")&"="&ENCODE_URL_COMPONENT({Email})&"&hide_Email%20List=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Greeting")&"="&ENCODE_URL_COMPONENT({Greeting})&"&hide_Greeting=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("First Name")&"="&ENCODE_URL_COMPONENT({First Name})&"&hide_First%20Name=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Last Name")&"="&ENCODE_URL_COMPONENT({Last Name})&"&hide_Last%20Name=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Suffix")&"="&ENCODE_URL_COMPONENT({Suffix})&"&hide_Suffix=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Best Contact Method Dropdown Options")&"="&ENCODE_URL_COMPONENT({Best Contact Method Dropdown Options})&"&hide_Best%20Contact%20Method%20Dropdown%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Teams")&"="&ENCODE_URL_COMPONENT({Teams})&"&hide_Teams=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Birthday")&"="&ENCODE_URL_COMPONENT({Birthday})&"&hide_Birthday=true"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Pronouns Not Listed")&"="&ENCODE_URL_COMPONENT({Pronouns Not Listed})&"&hide_Pronouns%20Not%20Listed=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Pronouns Dropdown Options")&"="&ENCODE_URL_COMPONENT({Pronouns Dropdown Options})&"&hide_Pronouns%20Dropdown%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Gender Dropdown Options")&"="&ENCODE_URL_COMPONENT({Gender Dropdown Options})&"&hide_Gender%20Dropdown%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Gender Not Listed")&"="&ENCODE_URL_COMPONENT({Gender Not Listed})&"&hide_Gender%20Not%20Listed=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Ethnicity Tags Options")&"="&

 

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Ethnicity Tags Options},"/","%2F"),"(","%28"),";","%3B"),")","%29"),":","%3A"),"&","%26"),"[","%5B"),"$","%24"),"]","%5D")," ","%20"),"{","%7B"),"!","%21"),"}","%7D"),"@","%40"),",%20",",")

 

&"&hide_Ethnicity%20Tags%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Ethnicity Not Listed")&"="&ENCODE_URL_COMPONENT({Ethnicity Not Listed})&"&hide_Ethnicity%20Not%20Listed=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Mobile Phone Number(s)")&"="&

 

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Mobile Phone Number(s) RID},"/","%2F"),"(","%28"),";","%3B"),")","%29"),":","%3A"),"&","%26"),"[","%5B"),"$","%24"),"]","%5D")," ","%20"),"{","%7B"),"!","%21"),"}","%7D"),"@","%40")

 

&"&hide_Mobile%20Phone%20Number%28s%29=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Office Phone Number(s)")&"="&

 

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Office Phone Number(s) RID},"/","%2F"),"(","%28"),";","%3B"),")","%29"),":","%3A"),"&","%26"),"[","%5B"),"$","%24"),"]","%5D")," ","%20"),"{","%7B"),"!","%21"),"}","%7D"),"@","%40")

 

&"&hide_Office%20Phone%20Number%28s%29=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Street Address")&"="&ENCODE_URL_COMPONENT({Street Address})&"&hide_Street%20Address=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Unit / Apt #")&"="&ENCODE_URL_COMPONENT({Unit / Apt #})&"&hide_Unit%20%2F%20Apt%20%23=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("City")&"="&ENCODE_URL_COMPONENT({City})&"&hide_City=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("State")&"="&ENCODE_URL_COMPONENT({State RID})&"&hide_State=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("ZIP Code")&"="&ENCODE_URL_COMPONENT({ZIP Code})&"&hide_ZIP%20Code=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Country")&"="&ENCODE_URL_COMPONENT({Country RID})&"&hide_Country=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("States You Want SAFE Updates In Tags")&"="&ENCODE_URL_COMPONENT({States You Want SAFE Updates In Tags})&"&hide_States%20You%20Want%20SAFE%20Updates%20In%20Tags=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Company List")&"="&ENCODE_URL_COMPONENT({Company List RID})&"&hide_Company%20List=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Roles")&"="&ENCODE_URL_COMPONENT({Roles RID})&"&hide_Roles=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("How Did You Hear About Us Tags Options")&"="&SUBSTITUTE(ENCODE_URL_COMPONENT(SUBSTITUTE({How Did You Hear About Us Tags Options},", ","`")),"`",",")&"&hide_How%20Did%20You%20Hear%20About%20Us%20Tags%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Did You Know About Sober Events Before SAFE Dropdown Options")&"="&ENCODE_URL_COMPONENT({Did You Know About Sober Events Before SAFE Dropdown Options})&"&hide_Did%20You%20Know%20About%20Sober%20Events%20Before%20SAFE%20Dropdown%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("How Many SAFE Events Have You Been To Dropdown Options")&"="&ENCODE_URL_COMPONENT({How Many SAFE Events Have You Been To Dropdown Options})&"&hide_How%20Many%20SAFE%20Events%20Have%20You%20Been%20To%20Dropdown%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Text Message Update Preferences Tags Options")&"="&SUBSTITUTE(ENCODE_URL_COMPONENT(SUBSTITUTE({Text Message Update Preferences Tags Options},", ","`")),"`",",")&"&hide_Text%20Message%20Update%20Preferences%20Tags%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("SAFE Newsletter Sign-Up Tags Options")&"="&SUBSTITUTE(ENCODE_URL_COMPONENT(SUBSTITUTE({SAFE Newsletter Sign-Up Tags Options},", ","`")),"`",",")&"&hide_SAFE%20Newsletter%20Sign-Up%20Tags%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Favorite Types Of Events Tags Options")&"="&

 

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Favorite Types Of Events Tags Options},"/","%2F"),"(","%28"),";","%3B"),")","%29"),":","%3A"),"&","%26"),"[","%5B"),"$","%24"),"]","%5D")," ","%20"),"{","%7B"),"!","%21"),"}","%7D"),"@","%40"),",%20",",")

 

&"&hide_Favorite%20Types%20Of%20Events%20Tags%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Favorite Genres Tags Options")&"="&SUBSTITUTE(ENCODE_URL_COMPONENT(SUBSTITUTE({Favorite Genres Tags Options},", ","`")),"`",",")&"&hide_Favorite%20Genres%20Tags%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Favorite Sports Tags Options")&"="&SUBSTITUTE(ENCODE_URL_COMPONENT(SUBSTITUTE({Favorite Sports Tags Options},", ","`")),"`",",")&"&hide_Favorite%20Sports%20Tags%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Favorite Types of Training / Workshops Tags Options")&"="&SUBSTITUTE(ENCODE_URL_COMPONENT(SUBSTITUTE({Favorite Types of Training / Workshops Tags Options},", ","`")),"`",",")&"&hide_Favorite%20Types%20of%20Training%20%2F%20Workshops%20Tags%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("What Resources Are You Interested In Tags Options")&"="&SUBSTITUTE(ENCODE_URL_COMPONENT(SUBSTITUTE({What Resources Are You Interested In Tags Options},", ","`")),"`",",")&"&hide_What%20Resources%20Are%20You%20Interested%20In%20Tags%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("What Resources Have We Connected You To That You Found Most Helpful Tags Options")&"="&SUBSTITUTE(ENCODE_URL_COMPONENT(SUBSTITUTE({What Resources Have We Connected You To That You Found Most Helpful Tags Options},", ","`")),"`",",")&"&hide_What%20Resources%20Have%20We%20Connected%20You%20To%20That%20You%20Found%20Most%20Helpful%20Tags%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Relationship With Drugs & Alcohol Tags Options")&"="&SUBSTITUTE(ENCODE_URL_COMPONENT(SUBSTITUTE({Relationship With Drugs & Alcohol Tags Options},", ","`")),"`",",")&"&hide_Relationship%20With%20Drugs%20%26%20Alcohol%20Tags%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Survey - Increased Skill & Awareness Dropdown Options")&"="&ENCODE_URL_COMPONENT({Survey - Increased Skill & Awareness Dropdown Options})&"&hide_Survey%20-%20Increased%20Skill%20%26%20Awareness%20Dropdown%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Survey - Supports Sobriety Dropdown Options")&"="&ENCODE_URL_COMPONENT({Survey - Supports Sobriety Dropdown Options})&"&hide_Survey%20-%20Supports%20Sobriety%20Dropdown%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Survey - Improved Mental Wellbeing Dropdown Options")&"="&ENCODE_URL_COMPONENT({Survey - Improved Mental Wellbeing Dropdown Options})&"&hide_Survey%20-%20Improved%20Mental%20Wellbeing%20Dropdown%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Survey - Increased Comfort Sharing About My Substance Relationships Dropdown Options")&"="&ENCODE_URL_COMPONENT({Survey - Increased Comfort Sharing About My Substance Relationships Dropdown Options})&"&hide_Survey%20-%20Increased%20Comfort%20Sharing%20About%20My%20Substance%20Relationships%20Dropdown%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Survey - Decreased Self Judgement Dropdown Options")&"="&ENCODE_URL_COMPONENT({Survey - Decreased Self Judgement Dropdown Options})&"&hide_Survey%20-%20Decreased%20Self%20Judgement%20Dropdown%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Survey - Used / Shared Recovery Knowledge & Resources Dropdown Options")&"="&ENCODE_URL_COMPONENT({Survey - Used / Shared Recovery Knowledge & Resources Dropdown Options})&"&hide_Survey%20-%20Used%20%2F%20Shared%20Recovery%20Knowledge%20%26%20Resources%20Dropdown%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Text Message Update Preferences Tags")&"="&ENCODE_URL_COMPONENT({Text Message Update Preferences Tags})&"&hide_Text%20Message%20Update%20Preferences%20Tags=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Social Platforms You Use Tags Options")&"="&

 

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Social Platforms You Use Tags Options},"/","%2F"),"(","%28"),";","%3B"),")","%29"),":","%3A"),"&","%26"),"[","%5B"),"$","%24"),"]","%5D")," ","%20"),"{","%7B"),"!","%21"),"}","%7D"),"@","%40"),",%20",",")

 

&"&hide_Social%20Platforms%20You%20Use%20Tags%20Options=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Personal / Company Website URL")&"="&ENCODE_URL_COMPONENT({Personal / Company Website URL})&"&hide_Personal%20%2F%20Company%20Website%20URL=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("LinkedIn Profile URL")&"="&ENCODE_URL_COMPONENT({LinkedIn Profile URL})&"&hide_LinkedIn%20Profile%20URL=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Instagram Profile URL")&"="&ENCODE_URL_COMPONENT({Instagram Profile URL})&"&hide_Instagram%20Profile%20URL=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Facebook Profile URL")&"="&ENCODE_URL_COMPONENT({Facebook Profile URL})&"&hide_Facebook%20Profile%20URL=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Facebook Page URL")&"="&ENCODE_URL_COMPONENT({Facebook Page URL})&"&hide_Facebook%20Page%20URL=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Facebook Group URL")&"="&ENCODE_URL_COMPONENT({Facebook Group URL})&"&hide_Facebook%20Group%20URL=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Twitter Profile URL")&"="&ENCODE_URL_COMPONENT({Twitter Profile URL})&"&hide_Twitter%20Profile%20URL=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("TikTok Profile URL")&"="&ENCODE_URL_COMPONENT({TikTok Profile URL})&"&hide_TikTok%20Profile%20URL=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Twitch Channel URL")&"="&ENCODE_URL_COMPONENT({Twitch Channel URL})&"&hide_Twitch%20Channel%20URL=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("YouTube Channel URL")&"="&ENCODE_URL_COMPONENT({YouTube Channel URL})&"&hide_YouTube%20Channel%20URL=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Discord Profile URL")&"="&ENCODE_URL_COMPONENT({Discord Profile URL})&"&hide_Discord%20Profile%20URL=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Spotify Profile URL")&"="&ENCODE_URL_COMPONENT({Spotify Profile URL})&"&hide_Spotify%20Profile%20URL=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("SoundCloud Profile URL")&"="&ENCODE_URL_COMPONENT({SoundCloud Profile URL})&"&hide_SoundCloud%20Profile%20URL=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Apple Music Profile URL")&"="&ENCODE_URL_COMPONENT({Apple Music Profile URL})&"&hide_Apple%20Music%20Profile%20URL=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Audius Profile URL")&"="&ENCODE_URL_COMPONENT({Audius Profile URL})&"&hide_Audius%20Profile%20URL=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Bandcamp Profile URL")&"="&ENCODE_URL_COMPONENT({Bandcamp Profile URL})&"&hide_Bandcamp%20Profile%20URL=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Beatport Profile URL")&"="&ENCODE_URL_COMPONENT({Beatport Profile URL})&"&hide_Beatport%20Profile%20URL=false"

 

 

&"&prefill_"&ENCODE_URL_COMPONENT("Prefix Dropdown Options")&"="&ENCODE_URL_COMPONENT({Prefix Dropdown Options})&"&hide_Prefix%20Dropdown%20Options=false"

AtaFarzam
5 - Automation Enthusiast
5 - Automation Enthusiast

I solve this case with automation. 

For each new record ID, I select update RecordID with the default value that I need. It works and no problem with Kanban steps as well.

 

Bridger_Maxwell
Airtable Employee
Airtable Employee

0934EBBD-4C65-4CAE-AC7B-D553986DB762.jpeg

Good news, this launched as a feature today! Now you can set a default value on any single select field.