⚙ Operations Hub

HubSpot Product Team
HubSpot Product Team

Tips, Tricks & Best Practices for Data Quality Automation

The Format Data Action feature makes it easy for you to keep a clean CRM and gives you more control over the formatting of your data. Here are a few tips to make that process easier!


Tip 1. Tell your workflow what to do with the formatted data

It’s important to remember that the Format Data Action will format the property you’ve selected, but then you have to choose what to do with that formatted data. For example, if you want to ensure that all last names are capitalized, you can add a Format Data action to a workflow:



But just having that action doesn’t update the last name in your contacts. To do this, you will need to use the Copy Property Value action and tell it to copy the value from “Format Data”.


You can then select which property type and property to update. 





You’ve just automated the capitalization of all last names in your contact records! You’re one step closer to a clean CRM. 


Tip 2. Refer to the Hubl Developer Documentation

While most of the format options are simple and straightforward, a few of them require you to use our HubL templating language.You can learn more about the HubL language here. Just find the format you’re looking for and ensure that you’re using the correct formatting. 


Those are all our tips for now, but please feel free to add your own to the comments section below and we’ll be keeping this post updated with new best practices along the way!

0 Replies 0

0 Replies

No replies on this post just yet

No one has replied to this post quite yet. Check back soon to see if someone has a solution, or submit your own reply if you know how to help! Karma is real.

Reply to post

Need help replying? Check out our Community Guidelines