La fonction de suggestion automatique permet d'affiner rapidement votre recherche en suggérant des correspondances possibles au fur et à mesure de la frappe.
Increase a Date Picker Property by Specific Amount of Days
Résolue
Hi friends! I am looking to create a workflow that edits a contact property with a date picker field type. The current property that I have in our HubSpot is "Free Trial Enrollment Date," which autopopulates the date a contact began a free trial on our platform. Our free trials are 7 days long. What I'm looking to create is a "Free Trial End Date" property, which will be 7 days after the "Free Trial Enrollment Date" property.
I was hoping to (and trying to) create a workflow that copies the "Free Trial Enrollment Date" value to my new "Free Trial End Date" property, and then increase that property value by 7 days. Unfortunately, the "Increase or decrease property value" action in a workflow will not apply to increasing or decreasing dates. I am open to figuring this out with or without a workflow, I was just hoping to figure it out without the help of our development team since their time is limited! Thank you in advance 🙂
HubSpot does not have a native feature for that. It would require third-party solutions (e.g. passing on property values into a Google Sheet via Zapier, running the calculation there, copying the information back into HubSpot) or custom development.
The fastest way to achieve this would be custom code actions in Operations Hub Professional.
Best regards!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
juin 6, 20226:45 AM - modifié juin 6, 20226:47 AM
Participant | Partenaire solutions Elite
Increase a Date Picker Property by Specific Amount of Days
Résolue
Hello,
I had this same issue (which lead me here) my solution was to use a workflow and use the Format Data function to add 36 months (my required timescale) to the field.
I have added a screenshot of the workflow I created. I hope this is useful.
This can now be easily achieved with such a property, see this example that calculates a date 30 days after the record create date:
The number of days is the first number in brackets. The rest of the numbers are there to calculate the amount of milliseconds as that's the unit HubSpot uses here.
If you want to calculate a date before, simply switch the + for a - sign.
Best regards!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
This can now be easily achieved with such a property, see this example that calculates a date 30 days after the record create date:
The number of days is the first number in brackets. The rest of the numbers are there to calculate the amount of milliseconds as that's the unit HubSpot uses here.
If you want to calculate a date before, simply switch the + for a - sign.
Best regards!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
juin 6, 20226:45 AM - modifié juin 6, 20226:47 AM
Participant | Partenaire solutions Elite
Increase a Date Picker Property by Specific Amount of Days
Résolue
Hello,
I had this same issue (which lead me here) my solution was to use a workflow and use the Format Data function to add 36 months (my required timescale) to the field.
I have added a screenshot of the workflow I created. I hope this is useful.
HubSpot does not have a native feature for that. It would require third-party solutions (e.g. passing on property values into a Google Sheet via Zapier, running the calculation there, copying the information back into HubSpot) or custom development.
The fastest way to achieve this would be custom code actions in Operations Hub Professional.
Best regards!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer