Set defaults on fields

+1, yeah, I would really like this feature for at least my “Single Select”. When a new record is created, its status could be set by default to something. That would be helpful.

Still need this, especially for Single Select fields!

We’d love more defaults too, specifically being able to select a default time for date + time fields. Right now it defaults to midnight which sometimes causes confusion across time zones - e.g. for some people it’s today, for others it’s tomorrow.

Heavy +1 on default values, especially current date and checkbox

I’m working on a solution using AirTable API, letting you create forms with default values, validation logic, custom logic on submit and more.

Anyone wants to give it a try & give me feedback? Let’s get in contact https://airtable.com/shrvNWXRawvupNPCf

I needed this for automatic deadlines (for user requests), overcome this with formula:
DATEADD(CREATED_TIME(), 7, 'day')

@Mike_Ball, would you please consider adding to your excellent feature request the ability to set the default value via either formula or string expressions?

For instance, where you suggest that

• “on …date [fields], the obvious [default value] is Today”,
• such a default could be implemented by typing the following formula in the default field: today()

Additionally, by allowing a FORMULA to be entered as the fields default value, it allows users to prepopulate each record with more value scenarios which could easily account for and predict the default value for 30-90% of the time, yet still allow the user to quickly and CLEANLY override the default value.

For instance, instead of simply setting the default value of a field as Today() a business could set the expiration of a short term lease as Today()+90, but allow the two parties to adjust it to more amenable/responsive terms.

(See my earlier post for more details)

Totally agree. Need an option to have a default value on both string fields as well as single/multi select fields

Would love to see this implemented but don’t feel hopeful since it has been going on almost 2 years since the original question.

+1 request for the ability to use form prefill for date and time to NOW().

Chiming in. This would be incredibly useful.

Definitely this, default value for all field types

Make no sense to not have a default value for a single select… !!!

Kanban looks ugly with “Uncategorized” because of this!

Yet another +1 for defaults on single select, and others too. Why not? It seems strange for it NOT to be an option.

+1, much needed — this would make data entry much faster

Has anyone managed to get this to work with Zapier? I tried the suggestion to filter by a kanban view but zapier does not list kanbans in the list. Searching the field for “Uncategorized” or leaving blank both don’t work.

I’m very surprised this hasn’t been implemented considering the $150 million+ raised in 2018. For single select this would be as easy as adding one of those switch toggles used in filtering (“none of” option) to flag which should be the default. What gives?

Update: I was able to set up an Integromat integration that updates all empty records (Status=’’) to the default value. It runs at 15 minute intervals in the free tier which is sufficient for my needs.

• 1 defaults for datetime.

I use my table as a task tracker tool for my team.

FormNano now has the ability to set default values for fields, thanks to all who worked with me on this :grinning_face_with_smiling_eyes:

I’d also like this functionality to make it possible to create empty fields in case of duplicating.

Use case: a lot of linked fields are hidden in complex bases (e.g. API filled fields). When people duplicate a row those hidden links are duplicated with it. That’s not always behavior that’s wanted.

Hi, if you haven’t come to a solution yet, press CMD+ò to insert the current date on italian keyboard. I pressed all the keys to get it…

Please, please, please can we have defaults for every field?!

It looks like plenty of people have chimed in but: Dear Airtable, please allow single selects to have a default value. Without it, I’m spending time manually going in and adding the status of the record every time I add a new one. And frankly, if I forget, my team thinks the record isn’t there… I might try the workaround in the meanwhile, mentioned above, but this is a clear need for Airtable.

We built this tool: miniextensions.com/autofill-default-value-for-airtable-records. It allows you to set a default value for single selects or any other field. It can be scheduled to periodically autofill new records with the default value so that your table is always updated.

How is this still not an option? I literally do not understand. I need a default for a multi-line text field - why does it only exist for single line? This makes no sense.