Jump to content
Sign in to follow this  

Autogenerating a suffix number

Recommended Posts


I have a field where the user currently enters a product code into a text box, made up of 4 letters, and then 3 numbers. I need the 3 number part to be automatically generated. How can i do this? I haven't written a script before, but can easily learn as i have a good knowledge of programming functions in other applications. Or maybe it is a simple text control. Thanks in advance.

Share this post

Link to post
Share on other sites

This is a calculation problem.

Create a new number field, and set its entry options to auto-enter a serial number.

Then, you can create a new calc field "dsp_ProductCode" = Product Code & SerialID.

Don't use this field as a key. Use the serialID as the primary key.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.