I recently added a temporary workaround for this challenge.
Set up
Set up 4 properties
"Time" - Single-line text property
"Hour" - Number property
"Minute" - Number property
"AM/PM" - Dropdown property with values "AM" and "PM"
Set up 1 workflow
Enrolment criteria (re-enrolment turned on for all)
"Hour" is known
"Minute" is known
"AM/PM" is known
If/Then branch - IF Minute is between 0 and 9, go to branch 1, else go to branch 2.
Branch 1
Action
Set property value for "Time" to "{{ Hour }}:0{{ Minute }}{{ AM/PM }}" using tokens.
Branch 2
Action
Set property value for "Time" to "{{ Hour }}:{{ Minute }}{{ AM/PM }}" using tokens.
Form
Add the hour, minute and AM/PM properties as a row into the form.
Set the hour property to have a limit to the numbers accepted
Minimum 1
Maximum 12
Set the minute property to have a limit to the numbers accepted
Minimum 0
Maximum 59
Set all 3 fields to mandatory
Result
You'll have a form that contains 3 fields for your contacts to fill out the exact time they want, without the need for millions of dropdowns.
8:05AM
12:47PM
Etc
The workflow will combine the values into a single field for you to use.
Branch 1 of the workflow adds a 0 before the minute where it's a single digit number (0-9), otherwise you'd end up with 8:5AM instead of 8:05AM.
Limitations
The resulting time property is single line, which limits any filtering you'd use in numbers, etc. You'd be forced to use value contains "10:" and "AM" to find times for 10am as an example.
There are no filters around time, so you wouldn't be able to look for "Time after 10am" for example
Having 3 fields requires that all the fields are filled in rather than 1. This would force you to make them all mandatory which doesn't always work out in a form where it should be optional.
These limitations are the main reasons I'd still be requesting the property type from Hubspot in the future, but hopefully it helps you all in the meantime.
The last Product team update was February 24, 2022 08:25 AM - is there any update for 2023 please?
The ability to view not only Date but Date/Time format for key fields such as Create Date, Last Modified Date, Close Date etc for both Deals and Tickets is a high priority for my Pro and Enterprise clients.
Yes please! This is an urgent need, as it would help me monitor and manage my sales and support teams as they interact with a custom object, where we need to track response time in minutes, not days.
As a partner that builds custom objects for our clients requently, time is definetly something we get requested frequently to trigger on for workflows. Send a confirmation an hour before an event, send a call to action an hour after an event. This needs to be a property type option please!
