Functions in order of    date added  function name  comments  rating

FileMakerFileFormat

Returns the file name extension or file suffix for the active version of FileMaker Pro or FileMaker Pro Advanced

    By DamonCasey   (0 comments Posted 20 September 2012   Rating:  unrated

GetValueIndex ( valueList ; valueString ; matchCase ; occurrence )

Retrieve the index of the matching valueString in the valueList with optional case-sensitivity and occurrence restrictions.

    By Lewis Lorenz   (0 comments Posted 4 August 2012   Rating:  unrated

sql.debug ( _executeSQL )

Helps you to debug your sql function in the data viewer

    By Andries Heylen   (8 comments Posted 28 July 2012   Rating:  5.0

DateCalculation ( Days ; Months ; Years ; From )

Add years, months and/or days values to a source date to get a new date.

    By dawolfe   (1 comments Posted 3 July 2012   Rating:  unrated

sql.ts2FMdate ( _TS )

converts a Timestamp returned by ExecuteSQL function (type text) into a valid FileMaker date.

    By Fabrice   (0 comments Posted 4 May 2012   Rating:  unrated

ListBaseTables

Returns list of all unique underlying Base Tables for all Table Occurrences in the current FileMaker Pro v12 file

    By Andrew Duncan   (0 comments Posted 3 May 2012   Rating:  unrated

ErrorDescription ( errorNumber )

Returns the English description for the error number returned by the Get(LastError) function. Updated for FileMaker Pro v12.

    By Andrew Duncan   (0 comments Posted 3 May 2012   Rating:  unrated

IsDate ( _var )

return valid date as number of days since 0001-01-01 or nothing if invalid

    By Rewolfer   (0 comments Posted 24 April 2012   Rating:  unrated

sql.match ( _match ; _matchFieldName ; _requestedFieldName )

makes writing a _VERY_ simple and standard sql query easier and naming independent.

    By Fabrice   (0 comments Posted 11 April 2012   Rating:  unrated

FM.baseTable ( _tableName )

Returns the base table name of a table occurrence

    By Fabrice   (0 comments Posted 5 April 2012   Rating:  unrated

FM.table.info ( _tableName )

Returns table occurrence information as XML

    By Fabrice   (0 comments Posted 5 April 2012   Rating:  unrated

ExcelColumn ( _column )

Converts : - an Excel column header into a number (BR -> 70) - a number into an Excel column header (70 -> BR) Limited to ZZ (702)

    By Fabrice   (0 comments Posted 27 March 2012   Rating:  unrated

ExitLoop ( ExitValue ; LoopLevel ) ( ExitValue ; LoopLevel )

A generic way to exit (nested) loops

    By Arend van Asselt   (7 comments Posted 25 March 2012   Rating:  unrated

xml2var.clear ( _variable )

Clears all variables declared by xml2var.

    By Fabrice   (0 comments Posted 22 March 2012   Rating:  unrated

solfm_getLastID ( valueList )

Last ID obtained from value list

    By Diego D'Alessio (solfilemaker)   (1 comments Posted 21 March 2012   Rating:  unrated

 

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

 

 

 

 

 

 

Top Tags

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

 

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