Numbering System

Question

Hoping I can get some help. I'm new to writing formulas so that's not a huge help.

I'm looking to create a unique number system for each entry.

For example the first entry would have "IA2020-001" as the tracking number and the next would be "IA2020-002". I would need the year to roll over as well.

Any help is greatly appreciated.

------------------------------
Matthew Imrie
------------------------------

MarkShnierYou · Answer

Sequential Custom numbering is actually not easy to do in Quick Base especially for a new user. Nine times out of 10 when a client request this there is no valid reason for having that numbering. It is simply because that is the way they always used to do it.

The record ID in QuickBase is a unique number that will count up from one to infinity. If you don't like your records starting at the number one then I would import 1000 records and then the numbers will start at 1000.

If you'd like you can make an identifier which concatenates the year of the project and the Record ID number and that will be unique. But like I said sequential numbering is really a pain to set up and my first reaction is always to push back really hard as to whether they're really really really is a valid business reason for that.

If there is a strong business case for wanting to do this then I can point you at some help text but honestly it's just going to scare you if you are a new user.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community