Auto Numbering Records

Question

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

markshnier__you · Answer

What is you formula for auto numbering?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

stevevenne · Answer

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.&nbsp;

&nbsp;Concat Vendor, Procurement and Status

Formula - Text

&nbsp;
formula
109
&nbsp;

&nbsp;Latest Update

Formula - Rich Text

&nbsp;
html, formula
122
&nbsp;

&nbsp;Set up in TD Synnex's Systems for Procurement

Formula - Date

&nbsp;
formula
9
&nbsp;

&nbsp;Set up in TD Synnex's System for Support

Formula - Date

&nbsp;
formula
10
&nbsp;

&nbsp;Removed from TD Synnex's Systems for Support

Formula - Date

&nbsp;
formula
11

------------------------------Steve Venne------------------------------

markshnier__you · Answer

If you can locate the formula and post it here, then we can help with the formula.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

stevevenne · Answer

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&nbsp;has related options.

Unique

Must be unique

Sample Data
Show

------------------------------Steve Venne------------------------------

markshnier__you · Answer

It is likely that when you look at the field list, this is field ID# 3.&nbsp; If so, that field is the [Record ID#].&nbsp; 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------------------------------

Forum Discussion

Auto Numbering Records

6 Replies

Related Content

Auto numbering report rows

Button: save the new record and edit the new record

Assigning reference numbers to records

Auto numbering using Grid Edit

How to add list of attachments on child record from parent record

Recent Discussions

Updating predecessors in a pipeline

Create Child Record, Save and then Edit button

Date to show as MMM YY

Pipeline Make Request - Return Make Request JSON Output into fields

An API(?) button to copy fields from the form, to other fields

Concat Vendor, Procurement and Status		Formula - Text		formula	109
	Latest Update		Formula - Rich Text		html, formula	122
	Set up in TD Synnex's Systems for Procurement		Formula - Date		formula	9
	Set up in TD Synnex's System for Support		Formula - Date		formula	10
	Removed from TD Synnex's Systems for Support		Formula - Date		formula	11