Discussions

Expand all | Collapse all

Incremental digit - 3 digits long

  • 1.  Incremental digit - 3 digits long

    Posted 20 days ago
    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
    ------------------------------


  • 2.  RE: Incremental digit - 3 digits long

    Posted 20 days ago
    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
    ------------------------------



  • 3.  RE: Incremental digit - 3 digits long

    Posted 20 days ago
    ID formula: 
    "D-"&[Tag#]&"-"[Task #]

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



    ------------------------------
    Sarah Burres
    ------------------------------



  • 4.  RE: Incremental digit - 3 digits long

    Posted 20 days ago
    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
    ------------------------------



  • 5.  RE: Incremental digit - 3 digits long

    Posted 20 days ago

    Worked like a charm.  Thanks Mark!