Category Archives: Custom Functions

FormatNumber (FileMaker Pro Custom Function)

Posted on December 2, 2011 by Lewis Lorenz

FormatNumber ( number, format ): Returns text string of number in the requested format. Function allows complete FileMaker Pro number formatting using an intuitive format structure. Examples: FormatNumber ( 14725.3675, “$,.2 US” ) = $14,725.37 US FormatNumber ( -14725.3675, “$(,.2) … Continue reading →

Posted in Custom Functions, FileMaker Pro, Software | Tagged , , , | Leave a comment

FormatDateTime (FileMaker Pro Custom Function)

Posted on December 2, 2011 by Lewis Lorenz

FormatDateTime ( dateValue, timeValue, format ): Format the dateValue and/or timeValue as specified in format. If dateValue or timeValue are empty current date or current time are used. Optionally, use the backslash as an escape code to include text not … Continue reading →

Posted in Custom Functions, FileMaker Pro, Software | Tagged , , , , | Leave a comment

GetValueIndex (FileMaker Pro Custom Function)

Posted on December 2, 2011 by Lewis Lorenz

GetValueIndex (valueList, valueString, matchCase, occurrence): Retrieve the index of the matching valueString in the valueList. Returns 0 if not found. Optionally, toggle case-sensitive searching by passing a boolean through matchCase, and, search for a specific valueString occurrence (a negative occurrence … Continue reading →

Posted in Custom Functions, FileMaker Pro, Software | Tagged , , , , | Leave a comment