Creating a North52 AutoNumber Formula

Leave a comment

To create a formula in North52, go to Settings->N52 Formula:

The following window will open. Click New:

This will open:

We will create a new AutoNumber formula. Select AutoNumber from the formula type:

We will add this to the Account entity and keep the editor as Classic. Click Create on the bottom right:

This opens the window below.

Note the events you can run this on:

Let’s say we want our account number field to be a sequential number starting at 1000.

We will set the Auto No Value to 1000:

Now, we will want AutoNumber to run on the Account Number field, so we select this from the list. Also set the target property to Account Number:

Now we will build our formula. Click on Functions and you will see all the functions available:

We will search for autonumber. Click on it to bring it across to the formula pane:

We now need to supply the field we will be updating. Go to Source and search for Number. Select Account Number:

As we will need a string returned, we will use ToString to convert it:

Now, we will need the account number to increment. So, we will add +1:

Now, save the function.

Go to Accounts and create a new account. On saving, the Account Number will be populated with 1000:

Create a new account, and the number is incremented:

Note, if you delete these and create a new account, it will start at 1002.

If we want to add a prefix to the formula:

 

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Leave a Reply

Your email address will not be published. Required fields are marked *

six − 1 =