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.

[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.

[sujata sakhare]

1.navigate to number maintenance.

2.create new record change your table name.

3.write in number field TSA 22-0001.

4.save it..

It will automatically increment the number..while creating records.

Thanks.

[Andre8]

Thanks, is there a way to do this for a string field? a field other than the default number field?

[Saurav11]

Hello,

If you want to do for a string field open the dictionary of the field and in the default value check dynamic default and fill the reference value with get next padded number and save it:-

Then that field will have the format

Please mark my answer as correct based on Impact.