With custom code actions in Operations Hub Professional, yes, but not out of the box, unfortunately. It would require coding and the Operations Hub subscription.
Best regards
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
Moving deal between pipeline stages automatically after set amount of time
SOLVE
Hi Karsten,
Thanks so much for your help in this matter! To automate our customer’s pipeline, we used the custom code from Operations Hub Professional. Here’s how I managed to do it:
Create a scheduler that starts the workflow at a certain hour everyday.
Create an “If” block that checks if the start date for the pipeline stage was already set. It does it by checking if my custom property that I made, which is “startDateRun-check”, is equal to 0. If it is not, it sets today's date to property “startDateRun” then it sets “startDateRun-check” to value “0”. Then, it moves to the custom code. If the start date was already set - it automatically moves to executing the custom code.
In the custom code, I check if a month has passed with few “if” statements. Custom code should return the “output” value “True” if months passed or “False” if not. You only need input from the “startDateRun” property that holds the date to do that.
Next, I copied the “output” value from my custom code to the property “Deal Output”.
With the “if” block, I checked if “Deal Output” is True or False. If it is True, then I move the deal to the next stage, if not I end the workflow and it will start again the next day.
Moving deal between pipeline stages automatically after set amount of time
SOLVE
Hi @karstenkoehler, I would like to measure 3 months when the deal enters pipeline stage. We have 5 pipeline stages: 1. Onboarding 2. Engagement 3. Ongoing 4. Renewal 5. Long Term Client/Resigned.
So I want to start measuring time when deal enters first stage then after 3 months it moves to other stage automatically.
Thanks for help. Just one more question. Because months have different number of days is it possible to set workflow that it will change deal stage exactly after one month. So if deal will start 1th January it will move to other stage exactly at April 1th. With hard setting at 90 days when months have different number it could create problems.
With custom code actions in Operations Hub Professional, yes, but not out of the box, unfortunately. It would require coding and the Operations Hub subscription.
Best regards
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
Moving deal between pipeline stages automatically after set amount of time
SOLVE
Hi Karsten,
Thanks so much for your help in this matter! To automate our customer’s pipeline, we used the custom code from Operations Hub Professional. Here’s how I managed to do it:
Create a scheduler that starts the workflow at a certain hour everyday.
Create an “If” block that checks if the start date for the pipeline stage was already set. It does it by checking if my custom property that I made, which is “startDateRun-check”, is equal to 0. If it is not, it sets today's date to property “startDateRun” then it sets “startDateRun-check” to value “0”. Then, it moves to the custom code. If the start date was already set - it automatically moves to executing the custom code.
In the custom code, I check if a month has passed with few “if” statements. Custom code should return the “output” value “True” if months passed or “False” if not. You only need input from the “startDateRun” property that holds the date to do that.
Next, I copied the “output” value from my custom code to the property “Deal Output”.
With the “if” block, I checked if “Deal Output” is True or False. If it is True, then I move the deal to the next stage, if not I end the workflow and it will start again the next day.
Yes, it generally is – could you specify when you would start measuring those 3 months? With this information, I can draft this workflow.
Generally, you would enroll deals into a deal-based workflow, based on whatever date you would start measuring from. After a 90 day delay, you would use the "Set property value" action from the right sidebar, choosing the Deal stage property. This is where you can pick the pipeline and stage you want to move this deal to.
Best regards
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer