Jump to content

Updating Serial number with version


This topic is 7236 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I've tried an external file holding serial numbers, but I'm not too comfortable with that concept. All other serial # have been converted to ###### - ####### - ###### format based on time, record number and date, but this is too long for our inventory numbers that are hand written on 1/2" tags.

Is there a way to use the auto increment serial number and update it with a script on solution version update?

Link to comment
Share on other sites

  • 1 month later...

Hi there,

Its no problem.

First make a globan field named "Version global".

Make another field "Version".

Make a script which run automatic every time you print or close the db:

Set "Version global" with Version.

Set "Version" with "Version global" + 1

Make a calculation field:

Serial number & " - " & Version & "."

This give the result: #### - ##.

Good luck!

-Per

Link to comment
Share on other sites

You are better off using a simple sequential serial number for the human readable display (i.e. shown on the screen, printed on labels) and use the other ID number for relationships and program controls, but NEVER, EVER reveal it to the user or allow them any access to it.

This allows you to do ANYTHING that you want with the human readable version, and not have any effect whatsoever on the real ID that is being used programatically.

Link to comment
Share on other sites

This topic is 7236 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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