A new knowledge base article has been published on our support portal.
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 Save- Perform 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