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”).
Hi Katherine,
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.
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:
Press the “⌘” (Command) key, or the “Ctrl” (Control) key if you’re on Windows.
While still holding down the key from step 1, press the “;” (semicolon) key.
