Create Article Numbers

Hi Kimberly,

You could combine a Calculation field with Text Concatenation along with a Number field with the Auto-Increment option turned on to do what you want.

So a formula like this might work:

Article Type Prefix + “-” + Article Number

So you’ll need 3 fields. Your Calculation field, an Article Type Prefix which is a Text field, and an Article Number field which is a Number field.

You can set the Pick List of article types on the Article Type Prefix field.

When you add a new record, the Article Number value will be incremented and displayed. You can perhaps also set a Default Value for the Article Type Prefix field so you get a fully formed result in the Calculation field. Then if you need to change it, click the Pick List to select a different prefix value.

The only issue is you’ll get an ever increasing Article Number value for ALL prefixes. Your example shows the same Article Number value for different prefixes.

If you set the Default Value on the Number field to 1000, then that’s the value Tap Forms will start at when you create new records.

Hope that makes sense.

Brendan

Hi Kimberly,

The auto-increment function works only on when you create a new record. It won’t update existing records.