AnsweredAssumed Answered

3 and 4 digit alphanumeric serials

Question asked by littledrew_1 on Oct 3, 2012

Title

3 and 4 digit alphanumeric serials

Post

     I saw this:


SerialNum = a number field with an Auto-Enter value of Serial number with next value as 1 starting with 1
     
     Serial (calculation with result of text) =
     
     Middle("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ", Int(SerialNum/36)+1,1) & Middle("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ", Mod(SerialNum,36)+1,1)

from http://help.filemaker.com/app/answers/detail/a_id/3260/~/base-36-%28alphanumeric%29-serial-numbers

     I understand how it works, but how could I increase it to 3 and 4 digits?

     thanks!

      

Outcomes