Mar 29, 2021 07:50 AM
I need this because I want to log phone calls and there I also need the start and end time of a phone call.
Mar 29, 2021 11:23 AM
Welcome to the Airtable community!
If you open the form from a button field in Airtable, you can set the formula for the button to prefill fields with the values from the functions
TODAY(). You will probably need to fiddle with nesting these functions inside
DATETIME_FORMAT in order to get the exact results you want.
If you want help creating the formula for the prefilled forms, you can us this app.
Mar 30, 2021 07:39 AM
Since I only want to use the form to add new entries, how can I add this button to the form? Its not listed in the fields list.
Mar 30, 2021 07:59 AM
@M_F You can’t automatically add the current date or time onto an Airtable form on behalf of the person filling out the form, but the person can just click on the “TODAY” button that shows up in a date/time field, and it will automatically fill in today’s date & time.
Alternatively: As soon as the form is submitted into Airtable, Airtable can give you the creation date & creation time of the newly-created record. You can do this by adding a “Created Time” field type in your table.
Otherwise, if you need the current date & time to actually appear on your form without any interaction from your users, then you would need to use an advanced form building tool like JotForm.
Mar 30, 2021 08:09 AM
The hotkey in Airtable to fill a date field with the current date and time also works in Airtable forms. On the Mac it’s ⌘ + ; (Command + semicolon). My hunch is that Windows users will use the Ctrl modifier instead of the Command modifier. Check Airtable’s hotkey popup (top-right of the UI: Help → Keyboard shortcuts).
Pop into the start time field when you begin a call and hit that hotkey combo. When the call ends, do the same in the end time field, then submit the form.
Mar 30, 2021 08:21 AM
Wow, that’s a good one! I didn’t know about that keyboard shortcut!
Mar 30, 2021 09:03 AM
Sounds good, but this hotkey doesn’t work on a German keyboard because the semicolon requires a shift key and I suspect that’s why the hotkey interpreter recognizes it as another hotkey which isn’t set.
Mar 30, 2021 12:19 PM
Ah, good point. In that case, perhaps consider a tool like Typinator, where you can make your own shortcodes that expand into whatever you want. It should be easy to make one that outputs the current date and time in the format required by the field.