Forum Discussion

SarahBurres's avatar
SarahBurres
Qrew Trainee
5 years ago

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 make my incremental numbers 3 digits.  Is there a way to have my snapshot be 1-001, 1-002, ... , 1-010, ... 1-100 and so on? 


------------------------------
Sarah Burres
------------------------------
  • Can 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
    ------------------------------
    • SarahBurres's avatar
      SarahBurres
      Qrew Trainee
      ID formula: 
      "D-"&[Tag#]&"-"[Task #]

      Task # :
      If(not IsNull([Snapshot Task #]), [Snapshot Task #]+1,[Default Task #]+1 )

      ā€‹

      ------------------------------
      Sarah Burres
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        try 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
        ------------------------------