Aug 20, 20205:07 PM - edited Aug 27, 202011:20 AM
Contributor | Diamond Partner
Re-activate WF
SOLVE
EDITED: I apologize all, I was mistaken about the particular steps below. Turns out that datetime fields (the default ones that HubSpot provides) are different than the date picker custom fields you can create. You cannot copy info from a datetime field such as Last modified date to a date picket field or even to a sinlg-line text field. You must use the HubSpot API. More info here: https://knowledge.hubspot.com/workflows/compatible-source-and-target-properties-for-copying-property...
There is a potential workaround to this if you create a custom property, then use a separate workflow to populate that property.
First, create a custom date property called "Last modified date COPY" or a name that you choose.
Next, create a workflow. The enrollment triggers will be when "Create date" is "known" and when "Last modified date" is "known." Click on that enrollment step, and for the re-enrollment trigger, click "Allow contacts who meet the trigger" to re-enroll, and check the "Create date is known" box. The next step will be to copy the value of "Last modified date" to your new custom property "Last modified date COPY." Turn on the workflow, and all of your contacts will continually run through it. Every time the Last modified date changes, it will be copied to your custom property.
Now, create the workflow you initially intended to create, but use the COPY property as your trigger. You should be able to set up re-enrollment so that when this COPY date becomes "known," the workflow will fire.
If it works for you, please mark this as a "solution." Thanks!
Thanks, I tried that @yfundora but I can´t change this field every day... I manage a lot of WF and it´s impossible for me and my team. I found a solution playing with the if/then branch and time delays. If the contact was in the stage "1", then will pass automatically to the "stage 2", and so on...
There is a simple solution I've just implemented and is working for me:
As we know, "Last modified date is known" is not a trigger criteria for re-enrolment, but if you instead put "Last modified date is after 10-12-2020 (yesterday)" HS allows to add it as trigger re-enrolment, so every time a company change this will be updated with a date after yesterday 😁.
Thanks, I tried that @yfundora but I can´t change this field every day... I manage a lot of WF and it´s impossible for me and my team. I found a solution playing with the if/then branch and time delays. If the contact was in the stage "1", then will pass automatically to the "stage 2", and so on...
Aug 20, 20205:07 PM - edited Aug 27, 202011:20 AM
Contributor | Diamond Partner
Re-activate WF
SOLVE
EDITED: I apologize all, I was mistaken about the particular steps below. Turns out that datetime fields (the default ones that HubSpot provides) are different than the date picker custom fields you can create. You cannot copy info from a datetime field such as Last modified date to a date picket field or even to a sinlg-line text field. You must use the HubSpot API. More info here: https://knowledge.hubspot.com/workflows/compatible-source-and-target-properties-for-copying-property...
There is a potential workaround to this if you create a custom property, then use a separate workflow to populate that property.
First, create a custom date property called "Last modified date COPY" or a name that you choose.
Next, create a workflow. The enrollment triggers will be when "Create date" is "known" and when "Last modified date" is "known." Click on that enrollment step, and for the re-enrollment trigger, click "Allow contacts who meet the trigger" to re-enroll, and check the "Create date is known" box. The next step will be to copy the value of "Last modified date" to your new custom property "Last modified date COPY." Turn on the workflow, and all of your contacts will continually run through it. Every time the Last modified date changes, it will be copied to your custom property.
Now, create the workflow you initially intended to create, but use the COPY property as your trigger. You should be able to set up re-enrollment so that when this COPY date becomes "known," the workflow will fire.
If it works for you, please mark this as a "solution." Thanks!
@Hollyce thanks for the suggestion with the edited remarks. I've attempted this hack (I did create a new date/time property via the API), but it does not pick up changes made to a contact record. Based on the logic, I'm not sure how it would? Since the "last modified date" cannot be a re-enrollment trigger, how do updates to the contact record trigger this workflow?
I've been searching for a way to trigger a workflow when any contact property is updated (without the need to include every property as a re-enrollment trigger with an "is known" status) and it would be great if this solution worked.
Thanks for any tips or recommendations you might have.