CRM

AJLaPorte_diagr
Key Advisor

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

There are many times when a datetime field can be beneficial for use in the contact properties. There are currently a few fields (HubSpot defaults) that contain this data but you cannot create a custom property for this kind of data through the editor screen. 

 

HubSpot default datetime fieldHubSpot default datetime field

 

Allowing this would help with building more precise workflows when it comes to email sending or time-sensitive emails like drip campaigns from workflows. 

2 Accepted solutions
SkeeStylus
Solution
Top Contributor | Partner
Top Contributor | Partner

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

Good news @LJohnson83 @TylerA and everyone else, I just saw this is now in PRIVATE beta.  Opt yourselves in!  


Small Juan Headshot HubSpot CommunityJuan C. Perez

HubSpot Enthusiast | Certified Implementation Specialist
Subscribe to weekly product updates in 3 snack-sized bitesBook A Meeting Icon

Was was this helpful? Great, mark it as a solution.



View solution in original post

0 Upvotes
rwebb1
Solution
HubSpot Product Team
HubSpot Product Team

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

👋Hi all, I'm Rachel from the HubSpot Product team. An update - we are now in public beta for 'Create Datetime properties in HubSpot,' which allows you to create custom Datetime properties. You can opt into the beta under Product Updates. A few notes: 

  • When viewing and editing this property, a user’s current time zone will be used. This is based on the time zone set on their device.
  • When filtering with this property, your account’s time zone will be used by default.
  • Any custom datetime properties that had been created via a Support request / via API will now display Date & Time.
  • ‘Date’ properties whose field type can be edited can now be converted to ‘Date and Time.’
  • Datetime properties will be displayed as Date in the Forms Editor. Datetime properties are not yet supported in the new Forms Editor.

View solution in original post

0 Upvotes
95 Replies 95
EMinish
Participant

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

Bump - this still doesn't work for my usecase. 

I need to send emails to tickets that are created after-hours tickets. I can't identify hours for a workflow to work. Nor can I have a custom date/time field actually look for times in workflow enrollments. 
Current properties don't allow this. 

I'd love to hear about alternatives I could do.. 
For instance, I want to send specific emails to (ideal to use a workflow) to tickets coming in between 4:30 pm and 7 pm and separate email and workflow for 7 pm to Midnight. 

My goal is to be sure all tickets get EOD acknowledgments of their inquiry/ticket. With people across many timezones from 4:30 central (company base time zone) all tickets before that I expect staff to be sure to respond to. 

So if created that day and no first response was sent - it would be sent at 4:30 central and new tickets after that would get an auto message. 
Then tickets after 7pm through midnight central would get a different message. 

0 Upvotes
GStarley
Participant

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

@spoole  was that reply to me? Not sure where you're directing me to if so, and not something I can find reference to

0 Upvotes
GStarley
Participant

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

Hello,

 

Are there any plans to adapt this so that the time element can be lifted and used more widely? My specific use case is with the meetings scheduler, which is already a date and time field, however when used as a personalisation token in emails and text workflows, it only ipcks up the date. Not great when it's a customised reminder about an upcoming appointment, and so frustrating because I know the time is in there!

 

I've tried setting up a new field, to copy the info from the meetings scheduler, but I can't work out how to copy the date ansd timestamp over to a new field (because when  tested the new date and time picker, that DID display the date and time - so it's almost there!)

 

Thanks

0 Upvotes
spoole
Contributor

Allow creation of datetime field from Contact Property area (not just API).

SOLVE
This has already been rolled out:

[cid:c493bd28-cf37-464f-96a4-0ca26fa22130]
0 Upvotes
KSchuknecht3
Participant

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

This works well for the actual property but it is still only showing as a date when passed in an email. I'm using a custom datetime field to store a transaction date which I want to include in a transactional email triggered by a workflow and it is only showing the date in the email, although I can see the time in the property as well.

0 Upvotes
EMinish
Participant

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

Happy to see this in public beta. My biggest need still needs some more work to actually use this. 
I need to send emails to specific after-hours tickets. I can't identify "after hours" in workflow enrollments. If I choose a datetime picker as a workflow enrollment trigger -- I would want to choose between specific hours. 
Current properties don't allow this. 

I'd love to hear about alternatives I could do.. 
For instance, I want to send specific emails to (ideal to use a workflow) to tickets coming in between 4:30 pm and 7 pm and separate email and workflow for 7 pm to Midnight. 

My goal is to be sure all tickets get EOD acknowledgments of their inquiry/ticket. With people across many timezones from 4:30 central (company base time zone) all tickets before that I expect staff to be sure to respond to. 

So if created that day and no first response was sent - it would be sent at 4:30 central and new tickets after that would get an auto message. 
Then tickets after 7pm through midnight central would get a different message. 





 

0 Upvotes
TRAMA
Participant

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

Cool this is in beta!

 

Its easy to make this new Date and Time property, but its usability is not so great at the moment. If it is in a card view (tested on a ticket pipeline card), it only shows the date part, not the time.

0 Upvotes
OakIsland
Participant

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

Happy to see this finally happening.

Sorry to see that the time doesn't map over to templates, just the date. It's very important that this datetime field maps the time with AM/PM as well. It's weird that it doesn't. 

0 Upvotes
matt_scott
Top Contributor | Platinum Partner
Top Contributor | Platinum Partner

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

Thanks for putting this in public beta this is great!

There is one small thing that would be so good though!

In the form embed js
https://js.hsforms.net/forms/embed/v2.js
There is this line:
const s = /^[0-9]{4}-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])$/,
u = e => Object(r.a)(e) || s.test(e) && i(...e.split("-")) ? null : [o.INVALID_DATE]

It would be so nice if someone could just update the validation to also accept unix timestamp e.g.

1719510000000, and / or the hours and mins unit 
2024-06-27T18:40:00+01:00

(I've tested these out with the form submission api and they are accepted), It would be great if I could manipulate the date fields on form ready so I can set up my own date time field.

Something like this would work
const s = /^[0-9]{4}-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])$/,
s1 = /^\d{4}-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])T([01][0-9]|2[0-3]):([0-5][0-9]):([0-5][0-9])$/,
s2 = /^\d{13}$/,
u = e => Object(r.a)(e) || s.test(e) && i(...e.split("-")) || s1.test(e) && i(...e.split("-")) || s2.test(e) && i(...e.split("-")) ? null : [o.INVALID_DATE];

I can ofcourse completely stop the default form submission and use form submission API, but it seem's a nicer solution to just adjust the date field.
The form submission API also doesn't have any of the other validations until you submit the data and it fails.

Matthew Scott
Head of Development | Hubspot Solutions Architect

B2B marketing agency: Specialist B2B content marketing and demand generation for SaaS vendors and HubSpot Users | Deeply Digital | HubSpot Partner since 2010


01926 334003

deeplydigital.co.uk

3 Morton Street, Leamington Spa, CV32 5SY, UK
0 Upvotes
rwebb1
Solution
HubSpot Product Team
HubSpot Product Team

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

👋Hi all, I'm Rachel from the HubSpot Product team. An update - we are now in public beta for 'Create Datetime properties in HubSpot,' which allows you to create custom Datetime properties. You can opt into the beta under Product Updates. A few notes: 

  • When viewing and editing this property, a user’s current time zone will be used. This is based on the time zone set on their device.
  • When filtering with this property, your account’s time zone will be used by default.
  • Any custom datetime properties that had been created via a Support request / via API will now display Date & Time.
  • ‘Date’ properties whose field type can be edited can now be converted to ‘Date and Time.’
  • Datetime properties will be displayed as Date in the Forms Editor. Datetime properties are not yet supported in the new Forms Editor.
0 Upvotes
matt_scott
Top Contributor | Platinum Partner
Top Contributor | Platinum Partner

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

Nice to see a private beta, but still doesn't update the form fields if you want someone to enter a date and time

Matthew Scott
Head of Development | Hubspot Solutions Architect

B2B marketing agency: Specialist B2B content marketing and demand generation for SaaS vendors and HubSpot Users | Deeply Digital | HubSpot Partner since 2010


01926 334003

deeplydigital.co.uk

3 Morton Street, Leamington Spa, CV32 5SY, UK
0 Upvotes
SkeeStylus
Solution
Top Contributor | Partner
Top Contributor | Partner

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

Good news @LJohnson83 @TylerA and everyone else, I just saw this is now in PRIVATE beta.  Opt yourselves in!  


Small Juan Headshot HubSpot CommunityJuan C. Perez

HubSpot Enthusiast | Certified Implementation Specialist
Subscribe to weekly product updates in 3 snack-sized bitesBook A Meeting Icon

Was was this helpful? Great, mark it as a solution.



0 Upvotes
TylerA
Participant

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

Our team absolutely needs this field type for SO MANY THINGS, particularly on tickets and contacts, but there are use cases for all record types. In our specific case I'd like to be able to workflow timestamp properties for things like when a trial user connects to our software (completes onboarding) so we can measure and improve our setup flows.

0 Upvotes
LJohnson83
Participant

Allow creation of datetime field from Contact Property area (not just API).

SOLVE
We ultimately ended up creating a drop down with 15 minute blocks using a
standardized time formula. In the end, we could pass those values via API
to Google calendar and Zoom so it met our needs. A bit annoying to set up,
but haven't had any problems since.
0 Upvotes
BHörmann
Contributor

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

absolute necessity

0 Upvotes
blpmedia
Participant

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

It's 2024 and we still don't have the basic datetime field.  Come on @hubspot  This should at least be available for Contacts, Companies, and Deals. 

0 Upvotes
SDuncan
Participant

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

This is critical for so many of our flows AND reporting. This seems pretty basic, would be happy to have a datetime field with no timezone support even. Are there any updates here?

0 Upvotes
spoole
Contributor

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

Why is it only possible to create this property through the API?

0 Upvotes
NDLaRue
Participant

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

Why isn't this a thing yet? AND why do I have to build it in SFDC instead of what is setting the MQL status in Hubspot.. Processes everywhere!

0 Upvotes
froettgen
HubSpot Employee
HubSpot Employee

Allow creation of datetime field from Contact Property area (not just API).

SOLVE

Any updates on this? 

0 Upvotes