3 Replies Latest reply on Oct 29, 2013 9:20 AM by philmodjunk

    Generating random codes for pre barcode stickers

    ShaikhAtta

      Title

      Generating random codes for pre barcode stickers

      Post

      Hello, I want to develop codes for printing of pre made barcode stickers. The format of the code should be in 10 digits and unique. Plz help

        • 1. Re: Generating random codes for pre barcode stickers
          philmodjunk

               Why do the codes need to be random? Wouldn't a unique serial number be sufficient?

               An auto-entered serial number can be defined as a field in your table and it will enter a unique value each time you create a record in the table.

               A calculation field can then format this value with leading zeroes to serve as the value for the barcodes:

               Right ( "0000" & SerialNumber ; 5 )

               This will work for codes from 00000 up to 99999.

          • 2. Re: Generating random codes for pre barcode stickers
            ShaikhAtta

                 Thanks Phil, 

                                       Its good and worked out well, Actually the user will want to generate a given number of serials by entering the quantity of serials required. 

                  

                 For example the user enters 100 in the quantity field and then 100 serials are generated, then again when ever he wants to create more serials he will again enter a qty and more serials are then generated with increment from the last 100 serials generated. 

            • 3. Re: Generating random codes for pre barcode stickers
              philmodjunk

                   A script can generate a specified number of new records in the table to generate that number of new codes. The user enters a number in a global field and then performs the script which loops to create the number of new records specified in the global field.