Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Set defaults on fields

cancel
Showing results for 
Search instead for 
Did you mean: 
Mike_Ball
6 - Interface Innovator
6 - Interface Innovator

Simply the ability to set a default on fields other than numeric

On a date, the obvious is Today

On a string, just set a default value

138 Comments
ottost
5 - Automation Enthusiast
5 - Automation Enthusiast

I support this option too. In order to prefill certain values in creation, like “completed?” -> No, Department, Application date -> Now() (or Today). In forms include not_editable option, but show the default_value.

Dennis_Gneuss
4 - Data Explorer
4 - Data Explorer

+1

Super Needed for Project Management Use Cases.

Victoria_Hay
6 - Interface Innovator
6 - Interface Innovator

Thanks, everyone, for the feedback! As it sounds like you’ve already discovered, we currently support setting default values only for single line text, number, currency, and percent fields. We’ve received requests for default values for other field types as well; thanks for letting us know that this would be useful to you! I’m happy to pass this along to the rest of the team :grinning_face_with_big_eyes:

If you’d like to prefill fields in a form, note that we do have a workaround, but the default values you set will be editable in the form. The workaround is to use query parameters on the form field URL, prefixed with prefill_. See example below:

Form link without prefill: https://airtable.com/shrvzKQgWAnDr2D67

Form link with prefill: https://airtable.com/shrvzKQgWAnDr2D67?prefill_Full+Name=Victoria&prefill_Email=support@airtable.com

Timo_Schuler
5 - Automation Enthusiast
5 - Automation Enthusiast
  • 1

Would be really useful for Kanban view!

Ryan_Lavalley
5 - Automation Enthusiast
5 - Automation Enthusiast

This would be super helpful as many people will be filling out forms for requests for our services, having a single select field default to “Needs Follow-Up” or “In-Process” would be very helpful and save time.

Loir
4 - Data Explorer
4 - Data Explorer

The option to set a default value is such an obvious requirement. Would save user time and should be easy for Airtable to code.

I would also like an option to force the user to select a non-blank value for a single select field.

This would stop blank values.

BenInDallas
7 - App Architect
7 - App Architect

Specific defaults that would be useful to my team:

  • in a collaborator field type, set default to “current user” or any particular collaborator
  • in a date field type, set default value to “today” or “x number of days from today”, etc
  • in a single select field type, set any one option as the default
Brandon_Rowe
4 - Data Explorer
4 - Data Explorer

+1

Especially helpful when a form is submitted.

Noel_Howell
6 - Interface Innovator
6 - Interface Innovator

Hey! Just saw that text fields & number fields can have a default value set. Is this new? AWESOME!

21b6e83248b1d7f887ee9be5e0e55a67f5d76e63.png

The other workaround to the above, is to set up a NEW formula field using an IF statement. (E.g. If the field is blank, then use a default value, otherwise, use the field data.)

Noel_Howell
6 - Interface Innovator
6 - Interface Innovator

0d8ce72c0c4237d98862921e12ce3fcc087f7c15.png

Also- Numbers too!