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