AnsweredAssumed Answered

Need help with base 36 serials

Question asked by EricSmith on Feb 11, 2011
Latest reply on Jun 12, 2018 by bigtom


Need help with base 36 serials


Hi, I'm a filemaker newbie. I'm creating an asset management database and need to generate a 4 digit base 36 serial number. I found a great writeup in the knowledge base for making a 2 digit one with the following calculation:

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) 

It works great, BUT, I need to expand it to 4 digits and so far everything I've tried has been a bust (I can get a 4-digit number, but it looks like 111Z then 222Z or something along those lines). I think I'm missing something simple, but have no clue what it is...

Can anybody help me out?