topic Re: Set a date property as "x days after" day of step in Lists, Lead Scoring & Workflows

Set a date property as "x days after" day of step

SmartAcre — Wed, 22 Aug 2018 23:15:03 GMT

Hi, currently we are working on a new Free Trial experience, whereby users are now given 30 days to test out software and are then shut off after that period.

When users sign up for a free trial, we would like to populate a Date Property that is "30 days after" the time they fill out that form. As far as I can tell, workflows can only set a date property on the day of the step, or a set date. Is there a way around this so we can use that "End Date" property to customize warning emails telling contacts that their trial is running out?

Thanks!

Re: Set a date property as "x days after" day of step

MFrankJohnson — Fri, 28 Aug 2020 22:34:29 GMT

Q: Is there a way we can set a date 'x' days from when an action occurs in HubSpot?

Short A: No. Not within HubSpot (yet), but ...

Longer A:

You can use tools like Zapier or Automate.io to listen for your original date action, calculate a future date, then populate a field in HubSpot. In fact, we do this all the time to push deal close dates out by 30+ days automatically at deal creation time.

Re: Set a date property as "x days after" day of step

Jeaniemparker — Thu, 03 Jan 2019 20:10:05 GMT

Zapier is usually used to connect two applications. In this case it would be Hubspot and ???. Google Sheets maybe. Do I create a formula to add the 90 days?

Any additional help would be great.

Thanks.

Re: Set a date property as "x days after" day of step

Stevie-Kv — Mon, 07 Jan 2019 15:05:48 GMT

Hi Jeaniemparker

Zapier is capable of zapping within a single app, so a zap could do something in outlook when a outlook trigger happens for example.

Although in Hubspot's case and your desired result, hubspot actually has 2 different apps on zapier, Hubspot and Hubspot CRM (I don't know why!)

I created a zap as an example for what you might like:

Trigger - Hubspot CRM - Deal enters stage (30 day trial active)
Delay for 28 Days
Action - Hubspot - Add contact to workflow (Email -- Your Trial ends in 2 days!)

I hope that makes sense? It's pretty long winded for something easily doable by Hubspot themselves. Maybe respond to this idea and kudos the OP to get this happening sooner? https://community.hubspot.com/t5/HubSpot-Ideas/Allow-the-use-of-relative-dates-in-workflow-smart-list-criteria/idi-p/26982

Steve

Re: Set a date property as "x days after" day of step

Stevie-Kv — Mon, 07 Jan 2019 15:27:52 GMT

Hi again Jeaniemparker!

Just having a think about this and I realise this can be done in hubspot workflows but without focusing on the date field in the trigger, instead using a deal stage as a trigger.

So the workflow waits until the contact enters a deal stage (Trial) and waits 28 days with the delay action before sending the contact the reminder email.

There is also the newer features in workflows to focus around a date instead. Allowing you to pre-action/delay the schedule and timing

Re: Set a date property as "x days after" day of step

jdlaguyo — Wed, 24 Jul 2019 06:16:33 GMT

Is this being developed for deal based automation as well?

I would love to have the capability of automatically calculating projected dates from an initial date stamp of a deal property. This would be an invaluable thing for since we are a sourcing company and we have to know our dates from production to delivery. An adjustment at the anywhere on the timeline would have a compound effect on the entire project timeline and manually adjusting these dates is a tedious process.

Re: Set a date property as "x days after" day of step

Arlene — Fri, 28 Aug 2020 18:21:20 GMT

Just to piggy back off of this. I used our zapier connection to do this. The steps were:

Declare a trigger event. I used: [Contact Recently Created or Updated in HubSpot] and picked my "start date" as the property that I wanted to trigger this event.

Then added a zapier filter to only continue if.... then set parameters for: Only trigger if start date does not contain "null" or end date contains "null". I did this so I didn't override what was already inputted manually in HubSpot.

I had to add another step to customize my data / time format so that it would change from the default "UTC" to my timezone "US/Central". Despite having my master settings updated, without this step, my date kept adjusting incorrectly. Instead of adding 90 days it would add 96 days... This corrected that issue, and I haven't had a problem since.

Added a step to add the "data/ time" transform for "add/subtract" time. Since my identifier was a start date, I made that my input data and added "+90 days" as my expression.

Then sent it back to HubSpot but this time as the end date instead of the start date.

Since this only helps with ongoing needs, to back date my data, I created a second zapier flow that was very similar, but it had a different starting trigger.

First, I created a static list in HubSpot that I used as the trigger for this zapier flow.
Second, I went into HubSpot and made a workflow that had the enrollment trigger as "Start Date" property is "known". Then enroll contact into static list.
Third, turned on my zap.
Fourth, turned on my workflow and enroll all eligible contacts.

Re: Set a date property as "x days after" day of step

PamCotton — Fri, 28 Aug 2020 20:29:09 GMT

Hi @Arlene

Thank you for sharing with us your steps!

Kindly,

Pam

Re: Set a date property as "x days after" day of step

JSchiraldi — Thu, 01 Apr 2021 21:44:36 GMT

We are trying to automate based on contact relationship status and 30 days prior to a date field and need this ability as well.

Re: Set a date property as "x days after" day of step

MSchmidl — Wed, 09 Jun 2021 14:50:24 GMT

it would be great to have this as a native feature - I don't want to buy an additional tool to have this kind of basic functionality. If you're running a subscription business for example, I don't want to calculate the term of notice manually, this should happen in the CRM (e.g. calculate Licence End Date minus 90 days)

Re: Set a date property as "x days after" day of step

PDuque — Wed, 23 Jun 2021 21:14:28 GMT

I suggest using GoTellMe Calendar Toolkit https://gotellme.com/which-functions-does-calendar-toolkit-have

https://hubspot.gotellme.com/CalendarToolkit/

Re: Set a date property as "x days after" day of step

HLovatt — Thu, 03 Feb 2022 22:42:32 GMT

We need this as well to set close dates automatically to 90 days in the future, not the end of the current month

Re: Set a date property as "x days after" day of step

SaWells — Fri, 25 Feb 2022 02:42:28 GMT

I can't find pricing, how much does it cost?

Re: Set a date property as "x days after" day of step

DSelucky — Wed, 02 Mar 2022 20:20:29 GMT

Hello everybody,

this is quite a time after the question was posted, but let me exercise here one low key solution.

I had a similar question and what happened is that I came up with 2 simultaneous automation at the same time - just for fun.

The task at hand:

When the deal is created, let the salesperson pick the interval after which he will follow up with the deal based on its ripeness. Make sure the salesperson has the ability to change intervals as he goes.

Solution 1:

Create a simple workflow that once the picked interval is known, set the date of when the interval has been set. This date then being known triggers a workflow that based on the interval picked triggers its own workflow with a delay of the days that correspond to the interval.

Each of the workflows has a goal set that when a property "Restart Timer" is "1" then the deal gets kicked out of the workflow, so it could then enroll again if needed to reset its delay.

In the picture below there is this resetting property set to 1 and then to 0 again and then there is 15 minutes window for HS to realize it has been reset back to its default value. I tried originally 5 minutes, but HS sometimes didn't realize after 5 minutes that the property is back to 0 and it was kicking deals from the next pipeline right after it enrolled. So 15 minutes it is.

See pictures below.

Solution 2: Create a property "Days Till Reminder" which will be basically just a number property that will update daily as a countdown of days till the reminder. Hook it to something that runs through the system daily to be sure it updates as important system properties update with it so you don't get some serious misalignment in data.

I hooked it up with my "Today's Date".

And once it gets to 0 it's up to you if you set a new workflow that triggers a task, or that sends an internal email to your sales that its time to contact them or trigger your Paid Membership Pro integration to limit their access to your paid content. In my case, it is purely decorative so when our sales team opens the deal they see not only the interval that was picked and the start date but also how long till it's due. Needless to say, this value is being reset with the interval once the interval is set as per my first image.

I know it's not much, but on our end, it's doing magic without any other integrations. We try to use as few as we can to keep data in one system, eliminate errors and eliminate costs for additional systems.

Re: Set a date property as "x days after" day of step

RMorgan — Mon, 16 May 2022 12:31:55 GMT

This is such a fundamental feature that's missing for any SaaS business - work arounds are so clunky. Please review this.

Re: Set a date property as "x days after" day of step

kvlschaefer — Mon, 16 May 2022 19:41:11 GMT

Hi @RMorgan,

Thank you for feedback.

I would highly recommend you to please post this product suggestion at our ideas forum.

Our product team, who monitors the forum regularly, can read your specific use case and understand why this would be a useful functionality or change. It also helps other customers facing the same issue to advocate for its implementation on your behalf by upvoting on the thread as well.

Thank you,

Kristen

Re: Set a date property as "x days after" day of step

AFreemerman — Thu, 28 Jul 2022 20:43:20 GMT

Hi,

If you have the operational hub, you can do this date formating on the husbpot workflows:

https://www.linkedin.com/posts/kyleanthonyjepson_hubspottipsandtricks-hubspot-automation-activity-6811624694639288320-blxp

Re: Set a date property as "x days after" day of step

kvlschaefer — Fri, 29 Jul 2022 08:53:07 GMT

Thanks for sharing this tip with us, @AFreemerman!

Re: Set a date property as "x days after" day of step

borisgdrz — Thu, 25 Aug 2022 23:08:57 GMT

Hey for anyone trying to figure this out. You can actually create a custom property and use a workflow to set the time of the step to that custom property upon an action taking place. Then in the next action, you can use the format data feature and modify the previously set date, and finally, you can use this property as a token in your email.

Re: Set a date property as "x days after" day of step

PamCotton — Thu, 25 Aug 2022 23:30:54 GMT

Hey @borisgdrz , thank you for sharing this with us!

Kindly,

Pam