Incremental digit - 3 digits long
I have a Record ID created that is an incremental number: 1-1, 1-2 , 1-3, 1-4. I want for the list to run incremental but it is running 1-1, 1-2, 1-21, 1-22, so on. So I think the best way is to m...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendCan you post your current formula? It's an easy fix.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- ID formula:
"D-"&[Tag#]&"-"[Task #]
Task # :
If(not IsNull([Snapshot Task #]), [Snapshot Task #]+1,[Default Task #]+1 )
------------------------------
Sarah Burres
------------------------------- MarkShnier__Youtry this
"D-" & PadLeft(ToText([Tag#]),3,"0") & "-" [Task #]
what this part says
PadLeft(ToText([Tag#]),3,"0")
is to convert the Tag# to text and then make it three characters long, and to the degree that it's too short, then pad it from the left with the character "0")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------Worked like a charm. Thanks Mark!
