Update date property based on NO change to another property

SOLVE
MattFreestone
Member

Hi!

 

We have a date field in our company records that is 'Product Funding Ends' - this shows when the funding ends for the company.


Most companies pay yearly, so this date field needs changing 1x per year by our accounts/admin team, easy.

 

The problem is with customers who pay monthly. Their funding date is the end of the month, if they keep paying (AKA no one says they've cancelled - via our Company Status field) it needs to update to the end of the next month and so on. When we change company status to 'Cancelled' it will then cease to keep +ing a month.

 

I have seen some proposed solutions with Zapier, but this all relies on an update to the company. I need it to be triggered by essentially nothing changing...

 

Thinking out loud, could a workflow in HS change a property such as 'No changes/Changes' which is then used to trigger Zapier?

 

Thanks in advance for any input in this solution.

 

Matt

0 Upvotes
1 Accepted solution

Accepted Solutions
KTownsend
Solution
Participant | Diamond Partner

@PamCotton Thanks for tagging me. Hi @MattFreestone, what I'm thinking here is that you could use a workflow based on no updates to the property 'Product Funding Ends'. So you could set the enrolment trigger as Product Funding Ends has not been updated in the last X number of days, then create an action to 'Set property value'. You could then create a property, like you mentioned, called 'No change' as a single checkbox field, then set this to Yes via the workflow. Then, you'd be able to use that property to trigger the Zapier flow. 

 

I hope this helps!

 

View solution in original post

3 Replies 3
PamCotton
Community Manager

Hello, @MattFreestone happy Friday! I will add some top experts to this matter to help with some workarounds, @Josh @KTownsend any suggestions to @MattFreestone?

 

Thank you!

Pam

Você sabia que a Comunidade está disponível em outros idiomas?
Participe de conversas regionais, alterando suas configurações de idioma !


Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !




0 Upvotes
Josh
Recognized Expert | Platinum Partner

Hi @MattFreestone,

 

Does this need to happen on the last day of every month exactly or on a running 30 days? 




Did this post help solve your problem? If so, please mark it as a solution.

Josh Curcio

HubSpot support and inbound marketing for OEMs, contract manufacturers, and industrial suppliers.
HubSpot Platinum Partner & HubSpot Certified Trainer

KTownsend
Solution
Participant | Diamond Partner

@PamCotton Thanks for tagging me. Hi @MattFreestone, what I'm thinking here is that you could use a workflow based on no updates to the property 'Product Funding Ends'. So you could set the enrolment trigger as Product Funding Ends has not been updated in the last X number of days, then create an action to 'Set property value'. You could then create a property, like you mentioned, called 'No change' as a single checkbox field, then set this to Yes via the workflow. Then, you'd be able to use that property to trigger the Zapier flow. 

 

I hope this helps!

 

View solution in original post