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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth:

Under construction. Email me your wish list for improvements.