Functions in order of    date added  function name  comments  rating

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

sql2FM.dataType ( _type ; _data )

Translates SQL data into FileMaker

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

fm2sql.dataType ( _data ; _type )

Translates FileMaker Data into SQL

    By Fabrice   (0 comments Posted 30 September 2013   Rating:  unrated

time.DaylightSavings ( _countryCode ; _timeStamp ; _stateCode )

Type of result: boolean True if the timestamp is during daylight savings, False otherwise. Parameters: _timeStamp : if not defined, current host timestamp will be used. _countryCode : the ISO short code (2 letters) _stateCode (only for countries with

    By Fabrice   (0 comments Posted 29 September 2013   Rating:  unrated

fm.field.list ( _omit.string.list ; _begin.string.list )

returns a list of full filed names in all tables of the current file, starting with the _begin.string and omitting field beginning with one of the values in _omit.string.list

    By Fabrice   (0 comments Posted 30 August 2013   Rating:  unrated

fm.table.list.unique

Returns a list of table occurrences with 1 item per Base table

    By Fabrice   (0 comments Posted 19 July 2013   Rating:  unrated

 

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

 

 

 

 

 

 

Top Tags

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

 

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