Script to populate a sequential number
I'd like to create a script that generates a sequential number. Our products are numbered with two proceeding letters. Such as CL0001, CL0002, CL0003 or NN0001, NN0002 and so on...
I'd like to have a button that will run a script asking the user if the product is a CL or an NN and then populate the field with the next sequential number?