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().