Forum Discussion

JeffBrown1's avatar
JeffBrown1
Qrew Trainee
9 years ago

Auto generated numbers

I'm looking to create an auto-generate sequential number....without using the Record ID #. We are almost 3 years into Quickbase using a table that had no record number. Now we want one and I can't start with 4,356, it needs to start with 1. Is there a way to have an auto-generated number without linking it to the Record ID#?

Tables and fields

11 Replies

Sort By
    • RyanRyan2's avatar
      RyanRyan2
      Qrew Assistant Captain
      7 years ago
      what if i needed to use that field as key field for table?
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 years ago
      There actually is a way to have a formula field be a Key field.  It can be set using a manually typed API to set the Key field.  Maybe you can explain your exact situation.
    • ManishTewari's avatar
      ManishTewari
      Qrew Trainee
      6 years ago
      I'm in the same situation. I have a product table which needs a product_ID as a auto generated sequence number. The Product_ID is also the key to this table, so I cannot populate it using Record ID #. Can you provide some pointers to manual API thing to set a formula field as a key field? Thanks.