It is likely that when you look at the field list, this is field ID# 3. If so, that field is the [Record ID#]. That field is one of the 5 built in fields , and just counts up from 1 to basically infinity as records are added.
My suggestion is to just not adjust for the missing records which were deleted, as this will happen if records are deleted.
If for some reason you want to have an Auto numbering start at 1 and some records were deleted, then rename that field back to be called [Record ID#] and make a new field with the formula [Record ID#]-2
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com------------------------------
Original Message:
Sent: 05-23-2023 12:05
From: Steve Venne
Subject: Auto Numbering Records
Addition info from Field Properties
Label | | |
Type | Numeric | |
Key | | This field is the Key field for this table, needed for relationships, importing and more. Advanced Settings has related options. |
| |
Unique | Must be unique | |
------------------------------
Steve Venne
Original Message:
Sent: 05-23-2023 11:20
From: Steve Venne
Subject: Auto Numbering Records
This was the recommendation ([Record ID#]+100) but I started at 1 but I can't seem to find the formula field for the auto numbering. This is what I have for formula fields in this table.
------------------------------
Steve Venne
Original Message:
Sent: 05-23-2023 09:19
From: Mark Shnier (Your Quickbase Coach)
Subject: Auto Numbering Records
What is you formula for auto numbering?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 05-23-2023 09:09
From: Steve Venne
Subject: Auto Numbering Records
I have an Auto Numbering set up and used two of them in a test record. Is there anyway to reset to get those two numbers back?
------------------------------
Steve Venne
------------------------------