Auto increment number in a string field with format: "TSA 22-0001

[Andre8]

I would like to auto increment a field when a new record is being created with a format of TSA 22-0001

[Saurav11 · Accepted solution]

Hello,

Please do the below:-

Please go to Number Maintenance

Then over there create a new record with the below configuration, just change the table name to yours and save it.

So now when you create a new record you will have it as prefilled with the format:-

Please mark answer correct/helpful based on Impact.

[Andre8]

Thanks, should the two fields be in sync? please see attached

[Andre8]

The agreement number field is incrementing by 2 instead of 1

[Saurav11]

Hello,

Please do the below:-

Configure the number field dictionary and remove the default value form it and save it.

Then you can check it would increment by  1 only and you don't have to worry about the number field.

Please mark my answer as correct based on Impact.

[Andre8]

The number field is global

[Andre8]

The number field comes from the task table