HubDB: allow custom times in "Date and Time" property
I suggest that the "Date and Time" property be upgraded to either:
- accept a custom time value input by the user (with validation to ensure it is in the proper time format).
- OR be configurable to offer selectable times in 1 minute increments instead of 30 minute increments.
Who is this for?
This idea will benefit anyone using HubDB tables to develop web content based on configurable times and dates.
What problem does this idea fix?
In HubDB tables, the "Date and Time" property is limited to times in 30 minute increments.
The drop-down menu has values starting at 12:00AM, then 12:30AM, then 1:00AM, then 1:30AM, and so on. The user cannot select or input any other time.
This is inflexible and renders the "Date and Time" property unworkable for developing things like agendas where sessions have start times and end times that don't match the 30 minute increments.
A more flexible "Date and Time" property would fix this problem.
Examples of this solution elsewhere
HubSpot already uses a Date and Time select property for blog post publishing and email sending based on 1 minute time increments.
What value will this add?
Anyone using HubDB tables to develop web content based on configurable times and dates will have greater flexibility. In particular, it will be possible to use HubDB to create agenda for events and webinars where start times and end times can be at any time and not only at 30 minute increments.
Fixing the "Date and Time" property is better than using a single-line text field to accommodate any custom time value, because the "Date and Time" property is based on a formal timestamp and can be used more reliably to sort items by date and time and to display a time in a consistent format.