AnsweredAssumed Answered

How to create serial numbers that contain letters and number

Question asked by fmpro_novice on Feb 8, 2018
Latest reply on Feb 8, 2018 by fmpro_novice

I prepared a data base that has a simple - replace with serial number script. I wrongly assumed that all the serial numbers would be numbers so I created a number field for the Serial Number.

 

Then, I'm told that the Serial Numbers will contain a letter and a number.

 

When I insert A100000 as a variable and tell it to create serial numbers with this starting variable, the A gets dropped. The next number is just 100001. How can I make it keep the A?

 

Thanks!

Outcomes