Barcodes / Check Digits · Copy of Playground Doc

Link to page

Barcodes and Check Digits

Check Digits for UPC's

UPC's are 12 digits. The UPC generator generates from an 11 digit number because the 12 digit is a calculated "check" digit.

Check Digit Calculator:

https://www.gs1.org/services/check-digit-calculator⁠

⁠

Check Digit Info:

https://en.wikipedia.org/wiki/Check_digit⁠

⁠

How to Calculate Manually:

https://www.gs1.org/services/how-calculate-check-digit-manually⁠

⁠

Suppose that you want to find the check digit of an 11 digit UPC-A number 72641217542.

From right to the left, start with odd position, assign the odd/even position to each digit.

Sum all digits in odd position and multiply the result by 3: (7+6+1+1+5+2)*3=66

Sum all digits in even position: (2+4+2+7+4)=19

Sum the results of step three and four: 66+19=85

Divide the result of step four by 10. The check digit is the number which adds the remainder to 10. In our case, divide 85 by 10 we get the remainder 5. The check digit then is the result of 10-5=5. If there is no remainder than the check digit equals zero.

Check Digit Calculator

Check Digit Calculator

UPC without Check Digit

Number List Reversed

Check Digit

72641217542

24571214627

46783958762

26785938764

4678395876244

4426785938764

There are no rows in this table

⁠

This formula works for all cases:

If(Remainder(Sequence(1,thisRow.[Number List].Count(),2).FormulaMap(thisRow.[Number List].Nth(CurrentValue)).Sum()*3 + Sequence(2,thisRow.[Number List].Count(),2).FormulaMap(thisRow.[Number List].Nth(CurrentValue)).Sum(),10) = 0,0,10-Remainder(Sequence(1,thisRow.[Number List].Count(),2).FormulaMap(thisRow.[Number List].Nth(CurrentValue)).Sum()*3 + Sequence(2,thisRow.[Number List].Count(),2).FormulaMap(thisRow.[Number List].Nth(CurrentValue)).Sum(),10))

QR Code to Open a Row

QR Code to Open a Row

Name

Place the following in it's own section and can be printed on it's own:

Concatenate([QR Code to Open a Row].Filter(Name="Ben Lee").[QR Code],Character(10),[QR Code to Open a Row].Filter(Name="Ben Lee").Combined)

⁠

Ben Lee Coda Community $1,000,000.00

⁠

Another print example using two separate canvas formulas and the Image() formula to set the size of the QR code:

⁠

[ ]

⁠

Ben Lee Coda Community $1,000,000.00

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.