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

I suggest a numerbing system based on the formula [Record ID#] - 4,356

what if i needed to use that field as key field for table?

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.

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.

I have never testing using a record ID# as a Key field as part of a formula field.If you want to test that in a copy fo your app, you can type the APIyou would get to the tale and then observe the URL. Then after the ? in the URL you would erase what is there and typeact=API_SetKeyField&fid=99where 99 is the field ID of the formula field.So..1. i have never tested using the [Record ID#] in a formula as the Key field.2. I would test this in a copy of the app first.During this process disable the need for Application Tokens in your app.

Auto generated numbers | Qrew Discussions

QuickBaseCoachD
Qrew Captain
9 years ago
I suggest a numerbing system based on the formula

[Record ID#] - 4,356
- RyanRyan2
  Qrew Assistant Captain
  8 years ago
  what if i needed to use that field as key field for table?
- QuickBaseCoachD
  Qrew Captain
  8 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
  Qrew Trainee
  7 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.

Forum Discussion

Auto generated numbers

Related Content

Generate a number

Roundup whole number

PDF Document Generator, automatically attached to a record

Auto-ordering or Auto-issuance system

Auto change record to 'Expired' when copied.