Brian Dunning's FileMaker Custom Functions

CheckDigit_GTIN_14 ( IndicatorDigit ; CompanyPrefix ; SerialNo )

Generates the check digit for GTIN 14 number

  Average rating: 4.4 (28 votes) Log in to vote

W Brent Simon   W Brent Simon
Sweet Pea Data Solutions
http://www.SweetPeaData.com

Share on Facebook Share on Twitter

  Sample input:
CheckDigit_GTIN_14 ( 1 ; 0794451 ; 11032)
  Sample output:
2

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

The Produce Tractability Initiative (PTI) uses a Global Trade Item Number (GTIN) to identify produce sold around the world. This function calculates the check digit for GTIN-14 numbers.

 

Comments

Julzerator   Julzerator, Everett, WA
May 5, 2014
I need something that will just calculate the checkdigit number when inputting the 13 digits before.

I'm still new to Filemaker Pro but I have this working in Excel.

Help?
 
W Brent Simon   W Brent Simon, Central California
May 6, 2014
Not sure if I follow. Are you following the GTIN-14 structure?
 
Maxwell Klein   Maxwell Klein, Maxwell Klein Consulting
Feb 19, 2015
I ran into an issue where my client was issues a 9 digit Company Prefix (only 000-999 serial numbers). But the function got me on the right track when accounting for this and offsetting CompanyPrefix and SerialNo. Thanks!
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.