Forum Discussion

SteveVenne's avatar
SteveVenne
Qrew Member
12 months ago

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 -----------------------...
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion

What is you formula for auto numbering?



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
SteveVenne's avatar
SteveVenne
Qrew Member
12 months ago

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. 

 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


------------------------------
Steve Venne
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    12 months ago

    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's avatar
    SteveVenne
    Qrew Member
    12 months ago

    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
    Sample Data Show


    ------------------------------
    Steve Venne
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Qrew Champion
      12 months ago

      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
      ------------------------------
      • SteveVenne's avatar
        SteveVenne
        Qrew Member
        12 months ago

        Thank you!



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