HubSpot Ideas


Ability to Create a List to identify data that does not comply with Data Validation Rules

I set a Validation Rule for a field I created called Branch Postal Code. I chose "Set min character limit" to 5. However, this is only a go-forward validation, meaning only future times someone fills in this field will it not allow a zip code with less than 5 digits. There is currently no way within HubSpot for me to identify exisitng zip codes that have less than 4 digits. I know I can export to Excel and use a formula to identify and fix the errors, but it would be easier if I could Create a List within HubSpot. Even better, would be the ability to run a workflow to add 0 to the front of any 4 digit zip codes since that is the primary issue.