I built a base to track my medicine but need a time field type to improve it. Any chance that could be developed? You probably want to build in standard time where user can designate their time zone and what is known as military time.
I too would appreciate a Time field (beginning and end), not only to calculate duration, but with outlook integration, it would be a total game changer to have certain things appear on your calendar during the right time frame!!!
+100 for either a CURRENT_TIME function that is persistent, or a button (or key-command, a la Google Sheets) to insert a timestamp. We need this SO badly. Manual entry of date/time is prohibitively laborious.
To be fair, I’d missed until yesterday, that you could double-click within a Date field to pop-up the today button. I’d always assumed you had to start typing the date… That said, though this “discovery” eases things for us a bit, it’s by no means discoverable. We’d still prefer the option of checkbox-for-timestamp, or an in-line “Now” button (maybe even one near full-cell, that appears upon roll-over/hover).
Or hell… A new “Button” field type, that could trigger any number of formulas/scripts. :winking_face: Buttons within a grid layout make natural sense.
If your cursor is selected into a date field (with or without a time), then use the keyboard shortcut Ctrl+; (or Cmd+; on a Mac) it’ll automatically put in the current date/time.
+1 for a time field. Organising timetable for 85 classes over a 12 week university semester and I can’t put in the time that each class starts :unamused:
I’d also appreciate either a standalone “Time” field without a date, OR a formatting switch on the “Duration” field to accommodate time of day display, to be able to store data such as ‘8:00 AM’ or ‘5:00 PM’. The duration field can’t really work for this use case for us, as we don’t use military time and use the AM/PM meridiem designators when entering data. We have recurring weekly time slots, not attached to any particular date, and would like to be able to store these natively and enter them as seamlessly as all our other fields.