topic Re: How to set a custom datetime property? in Data Hub

How to set a custom datetime property?

FelipeFelix — Mon, 12 Jul 2021 07:41:35 GMT

Hello!

I'm trying new workflows capabilities with HubSpot Operations Hub and got stuck in one part.

I need to create a custom datetime property that stores the exact time when a Deal entered the last deal stage datetime. This property already exists (has been created through the API), but I can't find a way to input the hour, minute, and second data with HubSpot workflows. Example: 30/06/2021 04:33 GMT-3

Later, this property will be used to sort deals in the pipeline so my team can prioritize the oldest ones to accomplish our SLA - so it's really important to HubSpot understand that this property data it's a datetime so my team can sort records based on this, which doesn't happen with text properties. Right now I just can have the day/month/year but this doesn't help me at all.

Can anyone help me with that? I appreciate! 🙂

Best,

Felipe Felix

Re: How to set a custom datetime property?

jbogaert — Thu, 15 Jul 2021 14:41:11 GMT

Hi @FelipeFelix !!

While I don't have an answer for this myself, I posted this question to our workflow wizards. Does this answer help?

I think the only way to achieve this would be to enroll the deal on the required stage change and then use the “set property value” action and set the date to “date of step” which, if the property is datetime, will include both date and time information.

Re: How to set a custom datetime property?

FelipeFelix — Thu, 15 Jul 2021 17:00:49 GMT

Hi, @jbogaert!

That is what I'm doing today, but without the exact datetime (or at least the hour) my team can't prioritize right. 😞

We have an SLA with our customers that is less than one day, so this part is important.

I tried using Operations Hub workflows and the API, but none worked.

Best,

Felipe Felix

Re: How to set a custom datetime property?

jbogaert — Fri, 16 Jul 2021 09:14:57 GMT

Hi Felipe,

According to them, this does insert the time data including hour and minutes. However, as you want to use that information to sort deals later on - I think the roadblock here might be that the CRM is not showing this datetime information unless you click into the property history, so viewing the exact datetime stamp is hindered by that. Could that be it?

If so, there is sadly not much we can do to work round that with workflows. Even if you use a custom code action to set the timestamp via API manually, you’d still run into the issue that the CRM will still display the property as a datepicker property rather than a datetime property in-app...

Re: How to set a custom datetime property?

FelipeFelix — Thu, 29 Jul 2021 04:22:47 GMT

Hi @jbogaert!

Helped a lot! You're right, the workflow actually does insert the time data, but was not showing in the UI. This is enough to my team as we can sort the Pipeline by that - even without seeing in the UI the hour and minutes 😄

Thanks!
Felipe Felix

Re: How to set a custom datetime property?

jbogaert — Thu, 29 Jul 2021 07:30:04 GMT

That's so great to hear. Happy that we could clear this up!

Re: How to set a custom datetime property?

LachMac — Sat, 11 Feb 2023 08:41:57 GMT

Hi @jbogaert

This looks promising for a similar problem that I have.

However I can't get the field to accept datetime. If I choose text then I can't set to the 'date of step'. And if I set to date picker then it is a date field and I only get the date in the detail of the field property.

What field type did you choose when creating the property?

Thanks
Lachlan