Form Submitted Timestamp

[JerikaNguyen]

I want to get the submitted timestamp for each form into a Contact property called form_submitted_timestamp (type = date and time picker). I have added a hidden field in my form with a default value as current date) but it seemed like Hubspot failed to get all timestamp although my field type is date and time. How could I solve this?

[karstenkoehler]

Hi @JerikaNguyen,

If you're referring to just one field, HubSpot does this automatically, within the contact property "Recent conversion date".

If you want this per form, you would need one date property for each form –  and set this via a workflow:

1. Enroll contacts when they submit the form
2. Use the "Set property value" workflow action to log the date in the custom date property

If you want to do this via a hidden field in your form, this would require additional Javascript, if I'm not mistaken, and some light development based on the HubSpot Forms API. https://legacydocs.hubspot.com/docs/methods/forms/forms_overview

Let me know if you have any follow-up questions!

[JerikaNguyen]

Yes I'm able to log the custom date properties. However, I would like to get the timestamp.

For example:

If “Form Submission Time” is between 01:00 and 10:00 CET, assign to account_1@gmail.com

If between 10:00 and 16:00 CET, assign to account_2@gmail.com

If between 16:00 and 01:00 CET, assign to account_3@gmail.com

[karstenkoehler · Accepted solution]

@JerikaNguyen why store the information in a date property then?

This could be achieved with three workflows, each with configured working hours as you described: https://knowledge.hubspot.com/workflows/manage-your-workflow-settings#timing

Workflow 1 only running between 01:00 and 10:00 CET

Workflow 2 only running between 10:00 and 16:00 CET

Workflow 3 only runinng between 16:00 and 01:00 CET

The workflow set up would be as follows:

• Enrollment based on 'When filter criteria is met' > Contact has submitted form AND Contact owner is unknown
• Unenrollment based on Contact owner is known [this is important!]
• First and only action of each workflow is to assign the owner using the 'Set property value' workflow action