Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

How do I create an automatically increasing sequential number or alpha-numeric string?

If you create a formula numeric type of field, you can reference the built in field Record ID # to increment your number automatically. If you're not familiar with creating new fields, please see our Add a New Field help topic.

 

Once you've created your formula numeric field, your formula would look something like this.

[Record ID #] + 100

This formula would take the Record ID # and add 100 to it for each new record. So if the Record ID # is 1, the formula numeric field would return 101.

If your sequential number needs to include letters, create a formula text field instead of a formula numeric field. Your formula might look something like this.

[Record ID #] + 100 & " " & "Support"

If the Record ID # is 1, the formula text field would return 101 Support.

Comments

id auto create

i want to take first 4 letters of name and then add some nubera in it. i dont know how to do it.

Hello,Since the Record ID#

Hello,

Since the Record ID# field is the only field in QuickBase whose value is generated automatically, any formula which has a similar auto-incrementing feature needs to include the Record ID#.

 

However, if you have a Text field called Name and a Numeric field called Number, you can create a Formula - Text field to put them together as you described:

Left([Name],4) & "-" & ToText([Number])

 

Thanks!

Brian

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit