Brian Dunning's FileMaker Custom Functions

ValidCode ( Code ; Type )

Calculates the check number of various types of codes

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

Klaus-Dieter Brügmann   Klaus-Dieter Brügmann
kade project

Share on Facebook Share on Twitter

  Sample input:
ValidCode ( 978078973028 ; "ISBN" )
  Sample output:

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

ValidCode calculates the checknumber of 13 digit codes like EAN 13 ( European Article Number ), ISBN 13 (International Standard Book Number), ISSN 13 (International Standard Serial Number), of 12 digit code UPC A (Universal Product Code) and also of the 8 digit codes EAN 8 and UPC E. If you leave the parameter "Type" empty or input is "ISBN" or "ISSN" it calculates the check number of a 13 digit code.



Grace   Grace, Melbourne
Sep 16, 2013
How do you custom edit this function to work with my table?
PhilModJunk   PhilModJunk, Modesto
Jan 7, 2014
This function trips an Error in FileMaker 13. Code is not permitted as a parameter name. I had to rename this parameter before I could define the funciton in my database.
Lars   Lars, Hagen / Germany
Jul 2, 2017

is there any update for the newer Filmmaker versions?

I have also the problem with type in filemaker 14

Many thanks
Eddie Albert   Eddie Albert
Jan 8, 2019
To work in newer FM, just substitute the word "code" with "barcode" in the formula. DO NOT change the word "TheCode"

Log in to post comments.


Note: these functions are not guaranteed or supported by 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.