Brian Dunning's FileMaker Custom Functions

CreditCardType ( CreditCardNumber )

Returns Credit/Debit Card Type, e.g. Visa, MC, AmEx, Discover, JCB, China Union, etc.

  Average rating: 3.5 (2 votes) Log in to vote

Will Loving   Will Loving
Dedication Technologies, Inc.
http://studioschoolpro.com

Share on Facebook Share on Twitter

  Sample input:
CreditCardType( 5128351752976780 )
  Sample output:
MasterCard

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

This is a revision of Geoff Well's implementation of Brian Dunning's Card Validator. It performs a Luhn validation check on the card number - all charge card numbers must pass this validation test - and then if it passes, reports the type of Card. This function requires that the 3 Luhn custom functions - Luhn, LuhnDoubleEven, LuhnProduct - available at http://www.briandunning.com/filemaker-custom-functions/

This version reflects new brands and current card number ranges including the new "2" BIN ranges for Mastercard (issued starting October 2016; 222100-272099), other 17-19 digit length card numbers, and older 13 and 14 digit numbers. For current card number ranges and brands, see http://en.wikipedia.org/wiki/Payment_card_number for current ranges.

The following discontinued brands have been removed: Bankcard, Diners Club enRoute, Laser, Solo, Switch. I have also removed the detailed breakdown of various Visa cobrands such as Electron, Visa Purchasing, etc. Please reports any errors or suggested improvements in the comments at briandunning.com.

To obtain the Issuing Bank and type of card (debit or credit) for a specific BIN / IIN (Bank Identification Number / Issuing Institution Number), use the binlist.net online service with an HTTP POST request.

 

Comments

Lee Smith   Lee Smith
May 6, 2017
I think you need to add your Parameter to the name. i.e. CreditCardType (CreditCardNumber).

Because FileMaker is looking for CreditCardNumber as a parameter.

When I use the Clip Manager link, Clip Manager, provides reditCardTyp as the Parameter, which then has top be changed to CredCardNumber.

Lee
 
Will Loving   Will Loving, Dedication Technologies, Inc.
May 6, 2017
Thanks Lee. Should read correctly now.
 

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.