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