Hi, everyone! We have an Auto Increment field update: As of today, all EU, US, and AP region apps have received an update to their Auto Increment fields. This update will greatly lessen the instances where gaps in the auto increment ID values occur. As a reminder, auto increment fields are unique…

This is great thanks for fixing this our employer found it very annoying.

[image] Les: greatly lessen This is great and good news, however, the term lessen “greatly lessen” doesn’t ring any confidence to me. It’s either fixed or not, and this seems it’s not. Sorry to be a downer but doesn’t ring confidence when Im building client workflows dependent on consistency…

Think of it this way. If this were a straight SQL autoincrement field it would work correctly with 100% certainty. That’s because SQL is A.C.I.D. compliant . Whatever they’re doing is not simply a straight SQL autoincrement. There’s something else going on peculiar to Knack.

Hi, Phil! Thank you for sharing. I apologize, the way that I phrased that could have been better! :slight_smile: I used “greatly lessen” out of an abundance of caution in case someone runs into any further issues, but the previous issue with auto increment fields has been fixed! :tada: Please let …

Understood Les. Appreciate you addressing this. I sense your cautionary statement is with good intent. It’s still cautionary :flushed:. We will just have to see. Is the DB architecture MongoDB? Many thanks Phil Wesley-Brown +64272515002 Sent on the run, apologies for any typos!

Of course, Phil! :slight_smile: Is the DB architecture MongoDB? We’ve been doing a lot of infrastructure updates and deploying proprietary changes. Since, we have moved away from Mongo to a new proprietary environment. Please let us know if you have any questions specific to your account, and t…

Haha I’m so happy this is finally addressed. Can’t wait to give it a try!

Hi there, Can we clarify this post? When I first read it, it seemed like the bug was that the Auto-Increment will not replace deleted values, and now it does. But after a quick test, I see that is not the case. Deleted values are not renumbered. So if you have 1, 2, 3, and delete #2, then add a…

Hi there! Correct, deleted values are not re-used and this update was not to correct that. This update corrected larger gaps that were occasionally occurring, for example, occasional random 30 record skips in auto increment values. Thank you for sharing your request, and I have shared that with th…

Auto Increment Field Update!

Announcements

MichaelG May 13, 2025, 12:56pm 16

The thread of my subject is more this one:

Topic		Replies	Views
Auto Increment - Update Records After Changes Feature Requests	1	459	October 15, 2018
Auto increment started skipping values 2022-09-20 Get Answers	35	1778	June 16, 2023
Update existing increment fields Get Answers	6	446	August 16, 2023
Restoring data with Auto-Increment Records Knacksters' Idea Lab	2	264	December 9, 2023
Auto-Increment Field - Creating Duplicates! Get Answers	6	726	January 10, 2022

Auto Increment Field Update!

Related topics