Hi @maggiebutler
2 workflows that weâve come back to over and over again to workaround certain limitations:
1) Number formatting has always been an issue in Hubspot - even Hubspotâs default Zip Code (Postal Code) property is a text-based property. Additionally, calculated properties donât allow formatting to the output. In both of these cases, we use workflows that take the information in those original properties and just mirror it to a second property that is formatted properly.
- For zip codes, if you have a number Zip Code property and the data is showing up with unnecessary commaâs, mirror that information to a text-based property within a workflow.
- For calculations, create a second property and mirror the calculated output. In this case, you can label you calculated output property as Unformatted, and create a second property to mirror that data with the formatting you need and label is Formatted (ie. currency, number, etc.)
2) This comes into play with the mirroring mentioned above but one of the biggest workarounds weâve found has to do with re-enrollment of Company records. In workflows, Hubspot doesnât allow the re-enrollment of a company into the same workflow when using the âhas been updated in the last X..â filter.
So if you have a Company property that is constantly updated and you want the workflow to mirror the informaton if the new data aligns with the trigger criteria, what other option do you have besides the âhas been updated in the lastâŚâ?
Use the "Is Known" option* rather than the âhas been updated in the last..â
The Is Known option triggers each time new data enters a property and can be used as a re-enrollment trigger.
*If mirroring and you want to clear the data in the mirrored record if the source record data is removed, the workflow should actually have several steps:
Step 1)
Trigger:
Company Property is Known
OR
Company Property is Unknown
= use both of these triggers for re-enrollment
Step 2)
Action:
IF/OR
Company Property is Known
OR
Company Property is Unknown
Branch 1 - If Company Property is Known = Mirror data to other property
Branch 2 - If Company Property is Unkown = Clear data from other property
In this example, each time the original property is updated (whether with new data or cleared), the second property will mirror that. And this works for re-enrollment. Yay!