Select Page

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

View this article in full on our support portal