Select Page

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

Scenario Overview

You need to generate an AutoNumber for the Account entity within the Account Number field. The format of the AutoNumber needs to meet the following requirements:

  • Have a prefix of “Acc-“
  • Followed by a fixed nine-digit number left padded with zeros
  • A number starting at 1,000 incrementing by 1 each time a new Account record is created 

N52 Formula Manager Solution

Formula Managers solution to this is to build a formula which will,

  • Execute on the create of Accounts within the system
  • Have a formula that generates the auto number requirements
  • Have the formula place the result of the formula into the Account Number field of the Account entity 

View this article in full on our support portal