Brian Dunning's FileMaker Custom Functions

DataType ( Stuff )

Returns type of data, ie Integer, Date, Email, Phone, Text

  Average rating: 4.7 (35 votes) Log in to vote

Matt Navarre   Matt Navarre

Share on Facebook Share on Twitter

  Sample input:
DataType ("" )
DataType ("1/1..3/15")
  Sample output:
date range

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

This function is designed as part of a single-field search system. It's job is to look at the data provided by the user, and use that information to determine which tables/fields to search. For example, if the user enters a date or a date range, the search script would look in the 'Invoice Date' field, but not the 'First Name' field.



Log in to post comments.


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

Under construction. Email me your wish list for improvements.