A new knowledge base article has been published on our support portal.
Scenario Overview
In this scenario, we want to ensure the quality of all Contact Addresses. We want to run a check on the addresses in the Contact entity to make sure they do not use the special characters ” , ; , < , >
We will run this formula whenever a Contacts Address fields have been changed (or created) . It will catch the changes to the Contact record before they are sent to the database and remove any of the special characters above.
N52 Formula Manager Solution
The Formula Manager solution works like this:
- A formula of type ‘Save – Perform Action’ is created on the Contact entity
- This Formula will be triggered whenever an Contact is created or any of the fields below are updated
- Address 1: Street 1 Address 1: Street 2 Address 1: Street 3 Address 1: City Address 1: State/Province Address 1: ZIP/Postal Code Address 1: Country/Region
- The formula will search the address fields and remove any of the following characters ” ;,<> before the fields are saved to the database