hey everyone, need help with how can i apply filter in view based on time for instance if i want to see the calls connected between 10 am to 11 pm???
Hi @ENadeem,
In the HubSpot user interface of filtered views (on the call index page), you can’t. You can however export your calls, then the ‘Activity date’ column in the export file with also have the time stamp and you can filter there:
Alternatively, in a custom call report, you can also access the hour of day as a date part of the activity date:
Lastly, in a call-based workflow, you could use a custom code action to extract the hour of the day from the activity date property and store it in a dropdown property, for example, that has options for each hour of the day, allowing you to filter directly from the call index page. Any major gen AI tool (ChatGPT, Claude, Gemini) can assist with coding this short custom code action.
Best regards
ummm… can i do this in contact view?
basically i want contacts who were connected on call between 10- 11
@ENadeem if you go the route of creating a custom code action, you can then filter a contact segment by that new call property.
If you create a custom report for contacts + calls and configure as shown in my previous reply, you could see which contacts had a call I’m that hour of the day.
Directly on the contact index page without a custom code action and supporting segment, no.
if i apply this hourly thing in report then which time zone hour will it give me?
if i make a report using hour of the day, will i be able to apply filter on hour -- like only give me results between 11 am to 3 pm, i dont think so this is achieveable, let me know if it is?
@ENadeem wrote:
if i apply this hourly thing in report then which time zone hour will it give me?
For me, it is displaying the account time zone.
@ENadeem wrote:
if i make a report using hour of the day, will i be able to apply filter on hour -- like only give me results between 11 am to 3 pm, i dont think so this is achieveable, let me know if it is?
No, neither call index pages nor call reports can be filtered by hour of the day.
You would either have to create the custom code action and populate a call custom property or create a report for contacts + calls, then export the report so you can see in your export file the exact time stamp and associated contact.