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.
