# Set Auto Increment Options
**URL:** https://forums.knack.com/t/set-auto-increment-options/9631
**Category:** Feature Requests
**Tags:** number-fields
**Created:** [July 12, 2015, 7:59pm UTC](https://forums.knack.com/t/set-auto-increment-options/9631 "2015-07-12T19:59:00Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@DanielYoun21557](https://forums.knack.com/u/DanielYoun21557)
#### Post date: [July 12, 2015, 7:59pm UTC](https://forums.knack.com/t/set-auto-increment-options/9631/1 "2015-07-12T19:59:00Z")
I would like to be able to setup/adjust the Auto Increment with options like "Prefix", "Suffix" and start number so I could end up with PO-00006 as my first record for example.
---
### Author:  [@GregHoward31345](https://forums.knack.com/u/GregHoward31345)
#### Post date: [August 1, 2018, 2:28am UTC](https://forums.knack.com/t/set-auto-increment-options/9631/2 "2018-08-01T02:28:10Z")
Came up with this. I was trying to make any new records match existing field ID FID-00###### (8 digits, pad left with zeros)
Auto Increment (starts at 1)
AutoIncrementBaseAdd = Auto Increment + 100000123 (assuming my first value needs to be 124, with a bunch of zeros to left)
Field ID = FID-right({AutoIncrementBaseAdd},8)
Result is FID-00000124, FID-00000125, etc.
---
### Author:  [@ThomasHull90972](https://forums.knack.com/u/ThomasHull90972)
#### Post date: [June 6, 2018, 6:38pm UTC](https://forums.knack.com/t/set-auto-increment-options/9631/3 "2018-06-06T18:38:59Z")
Agreed!
---
### Author:  [@BRUNOCERQU60563](https://forums.knack.com/u/BRUNOCERQU60563)
#### Post date: [July 31, 2017, 11:55am UTC](https://forums.knack.com/t/set-auto-increment-options/9631/4 "2017-07-31T11:55:27Z")
+1
nothing yet?
A custom starting number is a must and very easy to setup for knack.
---
### Author:  [@GuyRichard42322](https://forums.knack.com/u/GuyRichard42322)
#### Post date: [March 16, 2017, 5:05am UTC](https://forums.knack.com/t/set-auto-increment-options/9631/5 "2017-03-16T05:05:15Z")
+1
I can imagine a fairly extensive equation that would do this, but it seems something that would normally be pretty easy for you guys from a settings level? (or maybe not!)
---
### Author:  [@BRUNOCERQU60563](https://forums.knack.com/u/BRUNOCERQU60563)
#### Post date: [April 18, 2016, 2:01pm UTC](https://forums.knack.com/t/set-auto-increment-options/9631/6 "2016-04-18T14:01:29Z")
+1
---
### Author:  [@JasonVesko77380](https://forums.knack.com/u/JasonVesko77380)
#### Post date: [April 12, 2016, 7:27pm UTC](https://forums.knack.com/t/set-auto-increment-options/9631/7 "2016-04-12T19:27:30Z")
I will add my two-cents to the thread and say that this feature would be a benefit for the work that I do.
---
### Author:  [@JeffScheur18571](https://forums.knack.com/u/JeffScheur18571)
#### Post date: [January 5, 2016, 7:22am UTC](https://forums.knack.com/t/set-auto-increment-options/9631/8 "2016-01-05T07:22:39Z")
Yes please! I have a client whose job numbers need to start over with a new prefix designator and number count every year. The current setup requires a lot of reconfiguration and setup to make this possible and keep historical data.
---
### Author:  [@seunodusot60258](https://forums.knack.com/u/seunodusot60258)
#### Post date: [August 6, 2015, 3:59am UTC](https://forums.knack.com/t/set-auto-increment-options/9631/9 "2015-08-06T03:59:26Z")
I will like that too