Announcements
I have an entity "Questions" in which there is an S.no Column. I used the auto number attribute to assign a value to the S.no column in this format: "QNo" + number with seed value 1000. I have 14 questions in the table(the 14th column has a value QNo1013). After creating a question in the form and deleting it, when I'm trying to create a new question I am getting a value of QNo1015 instead of QNo1014. Is there any way to retain the order of the column values in the auto number variable?
@Anonymous
Autonumber its following a cardinal rule that a primary key is not reused once it is deleted. It makes sense when the key is used to connect to another table to establish a relationship. That being said, there are ways to fill in missing numbers using Sequence() or First(Sort(datasource, number, Descending)).number+1
Thanks a lot @Drrickryp !!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 329 Most Valuable Professional
11manish 209 Super User 2026 Season 2
Mohsin Ali 179
