A new knowledge base article has been published on our support portal.
In this example we have an requirement to make sure any Contact does not already have a Queue associated with any if its email addresses.
Note : You will need to make all three email fields ( Email, Email Address 2, Email Address 3 ) visible on the form for this example. You will also need to give some Queue entities an Incoming Email value for testing.
N52 Formula Manager Solution
The Formula Manager solution works like this,
- Whenever a Contact is created or its 3 email fields ( Email, Email Address 2, Email Address 3 ) are updated , the formula is triggered.
- The formula will create a list of every Queue entities Incoming Email.
- The formula will then compare this list to the 3 email addresses on the Contact entity
- If any of the emails match, the field in question is cleared.
Note that this is all done PreOperation to avoid an infinite loop.