Set defaults on fields

[Mike_Ball]

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

[ottost]

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]

+1

Super Needed for Project Management Use Cases.

[Victoria_Hay]

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]

• 1

Would be really useful for Kanban view!

[Ryan_Lavalley]

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]

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]

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]

+1

Especially helpful when a form is submitted.

[Noel_Howell]

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

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]

Also- Numbers too!