6 Replies Latest reply on Sep 5, 2014 2:24 PM by x4der

    Check Digit for barcode

    x4der

      Title

      Check Digit for barcode

      Post

      I made a database to generate barcodes for a 20 character G128. I figured out how to do the check digit, but when I concatenate it with the code, it is separated on two lines.

      FileMaker_Pro_AdvancedScreenSnapz002.png

        • 1. Re: Check Digit for barcode
          eoin

          Your concatenation formula works, however I have no way of knowing what data is in the two fields prior to the concatenation  

          Perhaps as a suggestion you look to your check digit calculation to be sure it's not adding anything to the result?.

          • 2. Re: Check Digit for barcode
            x4der

            I know this is sloppy programming and should be done with variables but I will only have a few hundred records. However the company that I am doing this for has hefty chargebacks for getting it wrong. I don't see where the return character came from.

            • 3. Re: Check Digit for barcode
              eoin

              Your formula is working perfectly ...

              But you must have a carriage return in your G128_Number field

              That is the only way I can get your formula to give me the problem you are describing

              Check the population of your G128_Number field.

              Regards.

              ps I always thought a GS1 128 Barcode didn't necessarily need a check digit and if it did the module 103 method was used to calculate it.

              I'm not saying your method is wrong, it just looks basically the same as an EAN13 check digit calculation. 

              It might be worth checking out ... If I'm wrong I apologise ...

              • 4. Re: Check Digit for barcode
                x4der

                Sometimes you look too hard to find an answer that should be obvious. There was a carriage return that was inadvertently put into the GS128_Number field, and it doesn't show when you are looking at it.

                We are doing this for shipments to LL Bean and they require a check digit for their 19 digit code- 20 in all.

                Thanks for the help.

                • 5. Re: Check Digit for barcode
                  philmodjunk

                  You might want to set up a filter expression as an auto-enter calculation that strips out characters, such as returns that would generate obvious errors.

                  • 6. Re: Check Digit for barcode
                    x4der

                    Or a quick and dirty way would be to set the maximum number of characters to 19.