0 Replies Latest reply on Oct 3, 2012 11:01 AM by littledrew_1

    3 and 4 digit alphanumeric serials

    littledrew_1

      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!