Brian Dunning's FileMaker Custom Functions

Search Results

30 functions found:

1.   AddAddHiddenSortOrder ( values ; currentValue )
    Average rating: 4.5
  Richard Dyce, Dyce & Sons Ltd.
  Adds a number of BOM chars to the front of value lists for use in MagicValueList sorted pop-ups
   
2.   AddSortOrder ( values ; padWidth ; delimiter ; currentValue )
    Average rating: 4.3
  Richard Dyce, Dyce & Sons Ltd.
  Add a numeric prefix to a lists of values, with leading 0's for easier sorting
   
3.   Array.Create ( columnNames ; rowNames ; nullValue ; delimiter )
    Average rating: 4.6
  Richard Dyce, Dyce & Sons Ltd.
  Creates an empty text array for use with other array.xxx functions found on this site.
   
4.   Array.GetCell ( array ; columnName ; rowName ; delimiter )
    Average rating: 4.7
  Richard Dyce, Dyce & Sons Ltd.
  Fetch the value from the named column and row in a text array.
   
5.   Array.SetCell ( array ; columnName ; rowName ; delimiter ; value )
    Average rating: 4.6
  Richard Dyce, Dyce & Sons Ltd.
  Set a cell within a text array - useful for creating sparse CSV data for virtual list export.
   
6.   BytesToDec ( hex )
    Average rating: 5.0
  Richard Dyce, Dyce & Sons Ltd.
  Converts MSB->LSB hexadecimal bytes to decimal
   
7.   ConcatValues ( listA ; listB ; separator )
    Average rating: 3.5
  Richard Dyce, Dyce & Sons Ltd.
  Quick and dirty recursive concatenation of two valueLists.
   
8.   CustomQuickSort ( values ; valueFunction ; direction )
    Average rating: 3.5
  Richard Dyce, Dyce & Sons Ltd.
  QuickSort using custom evaluation
   
9.   CustomValuesGreaterThan ( values ; reference ; valueFunction )
    Average rating: 3.5
  Richard Dyce, Dyce & Sons Ltd.
  Values greater than reference, evaluated using a custom function
   
10.   CustomValuesLessThanOrEqual( values; reference ; valueFunction )
    Average rating: 4.0
  Richard Dyce, Dyce & Sons Ltd.
  Values less than or equal to reference, evaluated using a custom function
   
11.   ExactPatternCount ( text ; searchString )
    Average rating: 4.0
  Richard Dyce, Dyce & Sons Ltd.
  Case sensitive version of PatternCount
   
12.   ExcludePartialValues ( values ; string )
    Average rating: 4.2
  Richard Dyce, Dyce & Sons Ltd.
  Remove matches from a list that include string
   
13.   ExecuteSQLToJSON ( tableName ; fieldList ; whereClause )
    Average rating: 0.0
  Richard Dyce, Dyce & Sons Ltd.
  Returns the result of a simple query as JSON
   
14.   ExternalBaseTables
    Average rating: 4.6
  Richard Dyce, Dyce & Sons Ltd.
  Returns a list of externally defined tables (no internal tables)
   
15.   FilterPartialValues ( values ; string )
    Average rating: 4.0
  Richard Dyce, Dyce & Sons Ltd.
  Exclude values that contain string.
   
16.   FindNewTimestampedValues ( data ; searchFromDate ; searchUntilDate ; searchFromTime ; delimiter )
    Average rating: 4.5
  Richard Dyce, Dyce & Sons Ltd.
  Pull newer values from order lists of timestamped values.
   
17.   FirstMatchIndex ( values ; string )
    Average rating: 4.0
  Richard Dyce, Dyce & Sons Ltd.
  Returns the index of the first value that contains the search string.
   
18.   FixExcelImport ( value )
    Average rating: 3.0
  Richard Dyce, Dyce & Sons Ltd.
  Cleanup imported numbers from Excel, suffering from rounding issues
   
19.   GetAsHexBytes ( number ; bytes )
    Average rating: 5.0
  Richard Dyce, Dyce & Sons Ltd.
  Displays number as bytes in hexadecimal format
   
20.   HiliteMentions ( text ; r ; g ; b )
    Average rating: 0.0
  Richard Dyce, Dyce & Sons Ltd.
  Adds a highlight to @mention tags within text.
   
21.   LetterCount ( text ; summary )
    Average rating: 3.7
  Richard Dyce, Dyce & Sons Ltd.
  Returns the letter counts within a string
   
22.   ListMentions ( text )
    Average rating: 0.0
  Richard Dyce, Dyce & Sons Ltd.
  Pulls out all @mentions from the text.
   
23.   LocalBaseTables
    Average rating: 4.8
  Richard Dyce, Dyce & Sons Ltd.
  Returns a list of local defined tables (no external tables)
   
24.   ParseName ( name )
    Average rating: 5.0
  Richard Dyce, Dyce & Sons Ltd.
  Parses a name into a JSON object
   
25.   ParseNameToJSON ( name )
    Average rating: 0.0
  Richard Dyce, Dyce & Sons Ltd.
  Parses english-format persons name into a possibly useful JSON object
   
26.   PatternCountValues ( haystack ; needles )
    Average rating: 0.0
  Richard Dyce, Dyce & Sons Ltd.
  Does a pattern count for multiple values at once, counting the number of times values in the second value list appear in the first value list.
   
27.   RandomChoiceFromList ( values ; required )
    Average rating: 4.0
  Richard Dyce, Dyce & Sons Ltd.
  Returns the required number of randomly selected elements from a value list.
   
28.   ReverseByteOrder ( bytes )
    Average rating: 5.0
  Richard Dyce, Dyce & Sons Ltd.
  Switches MSB->LSB ordered bytes to LSB->MSB and vice versa
   
29.   ShannonEntropy ( text )
    Average rating: 4.0
  Richard Dyce, Dyce & Sons Ltd.
  A function for calculating the entropy of a string - how difficult is it to encode.
   
30.   XORValues_18 ( ListA ; ListB )
    Average rating: 0.0
  Richard Dyce, Dyce & Sons Ltd.
  A FileMaker 18+ internally recursive function, using While( ).
   

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: