This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.
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
Thanks for the feedback! Could you explain a little more about wanting to default to a relative date/time? Do you have a specific use case in mind for something like this? When you say “current time plus 2 hours,” does “current time” refer to the time at which the record was created, the time at which the date field was modified, or are you asking for something that automatically updates to always show the time two hours from the present time?
In the meantime, it might be useful for you to use the keyboard shortcut Ctrl + ; (or ⌘ + ; on Mac). This will automatically put in the current date/time into a datetime field (“current” here means “the time at which the keyboard command was input”).
I’ve never been able to short cut the current date/time on Mac OS, Safari or FireFox. On both it’s a Zoom function.
Can you check please,
Hi Katherine, I am referring to the “Default Value” (of a new record) such as when using a database as a journal or fitness log, it would record date and/or time when the user begins entering a new log. Also, when using a database to log GPS waypoints- new records would include the date and time the record was created. Even a contact list, a calendar event, a photography database, job-seeking, hiring, car maintenance, pretty much any time a user would want the current date and time to be recorded when a new entry (record) is created. In other programs (Microsoft Access) every field type is allowed to have a Default Value, and that value can be a static value or a programmed value (such as CurrentDate, CurrentTime, UserName, etc). I see that some field types in Airtable are allowed Default Values (text fields for example), however it would be very useful if date fields did also.
Are you clicked in to the date field when you use the keyboard shortcut? If you’re not clicked in, ⌘ + ; is mapped to spellchecking, at least on Chrome on Mac.
I also would like to have a way to have Airtable automatically fill in date or time or date and time in a field. This becomes the time stamp of when the record was added. Much easier than typing in the data or using date picker. Also on my windows 10 computer when I use Cntl + all I do is zoom in my display. Cntl - zooms out.
Firefox also treats CNTL + as window zoom in. What are we missing here?
Sorry, I guess I wasn’t clear when I was explaining the keyboard shortcut. I didn’t mean “+” as the “the key on one’s keyboard which returns the plus sign.” I meant “+” as “and.” So, the steps in order are:
I would also like to have this feature added.
Why: it would be extremely useful on the iPhone where I can’t use keyboard shortcuts, and I’m on the go / pressed for time to enter everything
I would agree that this feature would be very valuable when on the go form the mobile devices.
I second this request. Default values should be available for almost all field types.