Functions in order of    date added  function name  comments  rating

hierarchy ( _id.list ; _primaryKey ; _parentKey ; _direction ; _numberOfLevels )

returns the list of 'ancestors' or 'descendents' in a recursive data structure (tree view)

    By Fabrice   (0 comments Posted 27 March 2013   Rating:  5.0

FieldAndContentList ( TagValue ; TagField ; NotContain ; Contain ; AddFieldList ; TypeField ; EmptyValue )

returns field names and contents of all the field are on a layout (repeatingField and related records included)

    By Agnès   (0 comments Posted 12 March 2013   Rating:  unrated

SqlNumber ( number )

Convert a filemaker number-value into a SQL-numbervalue

    By menno   (0 comments Posted 25 February 2013   Rating:  5.0

TrimAll_CR ( Text )

All redundant returns will be removed. Leading, trailing and the extra ones between lines.

    By menno   (0 comments Posted 25 February 2013   Rating:  unrated

Trim_CR ( Text )

Remove redundant leading and trailing carrige-returns

    By menno   (0 comments Posted 25 February 2013   Rating:  unrated

WeekFiscalToDate ( Firstweekday ; WeeknrOfYear ; Yearnr )

Calculate date from the given fiscal weeknumber in the given year at the given Firstweekday

    By menno   (0 comments Posted 25 February 2013   Rating:  unrated

SQLTimestamp ( theTimestamp )

Convert a timestamp for use in an SQL Query.

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

SQLTime ( theTime )

Convert a time for use in an SQL Query.

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

SQLQuote ( text )

Wrap text in single quotes, for use with SQL queries. The purpose of the Substitute is to "escape" any internally embedded apostrophes, e.g., O'Malley becomes 'O''Malley', which SQL will convert into O'Malley

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

SQLField ( fieldOrFieldName )

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

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

SQLDate ( theDate )

Convert a date for use in an SQL Query.

    By Daniel Smith   (0 comments Posted 6 February 2013   Rating:  unrated

GetAsSqlDate ( dateFromSqlResult )

Returns date parsed from text in the format of "YYYY-MM-DD".

    By Daniel Smith   (0 comments Posted 6 December 2012   Rating:  5.0

DoubleInList ( _values )

Returns values existing more than once in a list

    By Tanguy Colles   (5 comments Posted 22 November 2012   Rating:  unrated

SQLTable ( fieldForTableNameOrTableName )

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

    By Daniel Smith   (0 comments Posted 14 November 2012   Rating:  unrated

setDocumentPath ( filename ; extension )

Gets de documents path for Mac and PC

    By Diego D'Alessio (solfilemaker)   (0 comments Posted 20 October 2012   Rating:  unrated

 

« Previous 1 2 3 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)