Select Page

A new knowledge base article has been published on our support portal.

Scenario Overview

In this scenario we require a max character limit of 25 characters for the Account fields Street 1, Street 2 and Street 3. Any characters over this limit will be truncated. We want this rule to be applied to data BEFORE it is committed to the database and no matter where it comes from – e.g. from an import, SDK call, standard input form. The SetEntityTargetRecord function allow us to do this.

N52 Formula Manager Solution

The Formula Manager solution works like this:

  • A formula of type SavePerform Action is created that triggers on creation or updating of Account fields: Address 1: Street 1 , Address 1: Street 2 and  Address 1: Street 3
  • The formula ignores any characters after the 25th character
  • The formula does this at the Pre-Operation stage so that the fields are validated before they are saved into the database 

View this article in full on our support portal