returns the type of a data ("Number, TimeStamp, Date, Time, Container, or Text )
For data processing, customized lists.
Avoids hard-coding in FileMaker by using IDs instead of names. Full documentation here : http://www.1-more-thing.com/FileMaker-Avoid-Hard-coding.html
Translates HTML encoded text into standard text
Counts the number of related records that match a given criteria.
Allows you to run the "Repeating / Related" math functions that normally only accept Repeating / Related input's - directly on a list. E.g. Average, Count, List, Max, Min, Stdev, Sum etc.
Filters a text with ASCII, Extended ASCII, or UTF-8 table. Useful to get rid of unexpected characters copied from some crappy word processors like MS Word
Finds the position (index) of Value in Array, a return-separated list of values.
to compare and filter values, lists with different attribute
Converts a partial date into a valid date.
To sort a list, "Text" or "Number" or "Date" or "Time"or "TimeStamp"
Helps you to debug your sql function in the data viewer
Declares local variables from an xml structure
Creates a real path to a temporary file, by adding the FMTEMPFM string before the filename.
A generic way to exit (nested) loops