Skip to main content

Auto Number with Additional Zeros

  • March 3, 2018
  • 2 replies
  • 158 views
K

Hi ~
I am trying to create SKU’s for my designs.
I would like to use a concatenate string which incorporates:
An AUTO NUMBER

Is it possible to set up auto number so it creates a five digit number? Example 00001, 00002? instead of 1, 2, 3,

If not, I want to incorporate my auto numbers as part of the SKU for my designs.
Can I set up a concatenate formula where the number created is the auto number plus zeros in front of it.
This may be problematic because as the numbers increase the number of zeros in front should lessen.
e.g. 00001 -> 00010 '> 00100

I’d like it this way so my designs stay in order as the number of designs grows.

Or does someone have a better solution/suggestion?

Thanks,
Kai

    This topic has been closed for replies.

    2 replies

    W
    Forum|alt.badge.img+5
    • W_Vann_Hall
    • Inspiring
    • March 3, 2018

    This formula will do what you want; incorporate it as part of your SKU-creation routine.

    REPT(
    '0',
    5-LEN(
        {AutoNbr}&''
        )
    )&
{AutoNbr}
      K
      • Kai_Soremekun
      • Author
      • Inspiring
      • March 3, 2018

      This formula will do what you want; incorporate it as part of your SKU-creation routine.

      REPT(
    '0',
    5-LEN(
        {AutoNbr}&''
        )
    )&
{AutoNbr}

      Well that was awesome. That would have taken me at least a day, if not longer, to figure out.
      Thank you!!

      Terms & ConditionsAccessibility statement