This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
This seems like a glaring omission. At our charity we have volunteers entering dates into forms tablets. 99% of the time it is the current date. But 1% of the time it isnโt so we canโt automatically record todayโs date. Shortcuts donโt work on an Android tablet. Also the pop-up virtual keyboard gets in the way of the date picker. It is all very clunky. An option to make a date field default to todayโs date would make life a lot easier.
Need ability to set default value for single select fields. (Default status field to in process rather then it showing blank each time record is created)
It seems that date fields currently do not support default values. I frequently want a date field to default to the current date or current time or both. It would even be nice to be able to choose to default to a relative date or time (such as current time plus 2 hours, or current date plus 1 day). I think this would be a feature that a lot of people would useโฆ who agrees?
How do I implement this with my existing date field? Or do I need to create a new field for it referencing the original? If the latter, that rather defeats the object. I just want the existing date field to default to today, not add another field.
What Iโve done in a couple of Bases (which isnโt elegant) is to have a field to enter an override date and then have a formula provide the actual date for the record which uses the Created Date unless the Override Date is not entered:
IF({Invoice Date (if not now)} = BLANK(), CREATED_TIME(), {Invoice Date (if not now)})
In this case, field {Invoice Date (if not now)} is my override date and the result is an Invoice Date.
Thank you for idea Victoria but unfortunately there is no way to use this method for the current date, such as NOW() or TODAY(). I hope this feature will be added.