Forum Discussion

RajeevShukla's avatar
RajeevShukla
Qrew Member
6 years ago

Looking for best practice to achieve below functionality

How we can generate a 5 digit auto incremented sequence for a field in a particular table. For Example: Row 1 : 00001 Row 2 : 00002 ------------------------------ Rajeev Shukla ---------------...
Formulas and functions
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
The best practice is to use the [Record ID#] field and make a formula from it.

Try this as a formula text field.

PadLeft(ToText([Record ID#]), 5, "0")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
RajeevShukla's avatar
RajeevShukla
Qrew Member
6 years ago
Thanks Mark ,

This looks promising ,

But we can not use  [Record ID#]  field as we are going to reset this sequence in end of every year . 

Idealy, we want to update one field  ProjectID  whenever a record is added in that Table  .

#1 Format Will be (Field1-CCYY-Sequence of 5 Digit)

CC- Country Code
YY- Year(Last two digit of year i.e 2020 it will 20)
Field1 - Another column in the same Table.

For Example Project ID  : 2536-US20-00025 (Complete Format we need ).

We will reset the sequence at end every year.

Please provide you suggestion on the same 



Thanks,​

------------------------------
Rajeev Shukla
------------------------------