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
AppWorks
http://www.app.works

Share on Facebook Share on Twitter

  Sample input:
DataType ("joe@company.com" )
DataType ("1/1..3/15")
  Sample output:
email
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.

 

Comments

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.