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
[email protected]
------------------------------