Functions in order of    date added  function name  comments  rating

SQLTableAndField ( fieldForTableNameOrTableName )

Quote a table and field name for use in a FileMaker SQL statement. Prevent hard-coding it's value.

    By Daniel Smith   (0 comments Posted 8 February 2015   Rating:  unrated

BaseFileName ( TOName )

Return the base file name of a table

    By malcolm   (0 comments Posted 22 January 2015   Rating:  unrated

utc.benchmark ( _var.init ; _var.compare )

debug function to benchmark scripts and calculations

    By Fabrice   (0 comments Posted 3 December 2014   Rating:  unrated

ExtractingEmails ( TheText ; Separator )

Extract address eMail, what there is before and after the @ with the predefined separators. ( No to verify address )

    By Agnès   (0 comments Posted 25 November 2014   Rating:  unrated

GetIndexes ( array ; value ; start )

Returns a list of positions of Value in array; Start = start index to search

    By Jeroen Aarts   (0 comments Posted 10 November 2014   Rating:  unrated

GetFieldsByType ( localFieldsOnly ; omitFields ; theFileName ; theFieldTypes ; theLayoutName ; theTableName )

Return list of fields filtered by type

    By Michael W.   (0 comments Posted 17 October 2014   Rating:  unrated

GetHiddenObjects ( LayoutObjectsNames )

Use this function in a DataViewer, a showCustomDialog or wherever you want to get a return-delimited list of all hidden objects names that are on your currently browsed layout.

    By Kim Berthonneau   (0 comments Posted 27 August 2014   Rating:  5.0

Patternize ( direction ; pattern ; replaceChar ; value ; pad? )

Masking or Formatting function. Takes any pattern and replaces any set of characters within it, one by one working from the left or the right, with the respective character from the value.

    By Steve Allen   (0 comments Posted 26 July 2014   Rating:  5.0

TabNamesFrontMost

Gets a return-delimited list of the object names of the frontmost (nested) tabs. Does not include sub-tabs whose parent is not ALSO frontmost. No recursion.

    By DanShockley   (0 comments Posted 18 June 2014   Rating:  unrated

RandomPassword ( passlen )

Generates random password of desired length

    By HOnza   (3 comments Posted 26 March 2014   Rating:  5.0

ConvertFromBase ( str ; base ; charSet )

Converts any number to decimal, so long as the base of the supplied number is specified, and the character set used to represent the number is described.

    By Steve Allen   (0 comments Posted 18 January 2014   Rating:  unrated

ConvertToBase ( charSet ; base ; number )

Convert any decimal number to any base, using any character set to represent the resulting value.

    By Steve Allen   (0 comments Posted 18 January 2014   Rating:  unrated

CRC32 ( asciiText )

Returns a 32 bit cyclic redundancy check

    By Jeremy Bante   (0 comments Posted 5 January 2014   Rating:  unrated

sql.query.builder ( _query ; _param.list )

Helps building naming independent sql queries using # wildcards.

    By Fabrice   (0 comments Posted 5 December 2013   Rating:  unrated

sql.in.clause ( _list ; _dataType )

Builds the IN clause of a SELECT query

    By Fabrice   (1 comments Posted 30 September 2013   Rating:  5.0

 

« Previous 1 2 3 4 5 6 7 8 ... 21 22 Next »

 

 

 

 

 

 

Top Tags

Text Parsing  (33)
List  (32)
Date  (28)
XML  (27)
Format  (23)
Sql  (22)
Dev  (20)
Debug  (17)

 

Layout  (15)
Interface  (15)
Text  (14)
Variables  (13)
Filter  (12)
Layout Objects  (11)
Design  (10)
Array  (8)