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
------------------------------
Question
Looking for best practice to achieve below functionality
This topic has been closed for replies.
+22The 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
------------------------------
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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.