Brian Dunning's FileMaker Custom Functions

Search Results

32 functions found:

1.   Accordion( NumberedList; selectedGroup; showNumbers )
    Average rating: 4.1
  Bruce Robertson
  Given a numbered list and a selected group number, collapse all items in unselected group.
   
2.   AddRemoveListItems( theList; thevalues )
    Average rating: 4.3
  Bruce Robertson
  Add or remove item from list, also remove empty lines
   
3.   AntiFilterValues( ListA; ListB )
    Average rating: 4.3
  Bruce Robertson
  Return values only contained in ListA
   
4.   ApplyToList( ListA; function, separator )
    Average rating: 4.2
  Bruce Robertson
  Apply FUNCTION to each item in list
   
5.   balance( theText; openbracket; closebracket; instance )
    Average rating: 4.4
  Bruce Robertson
  Get text to length that balances open/close markers
   
6.   cfLayoutLister( whichFile; counter; fieldName; onlyLayouts; result)
    Average rating: 4.6
  Bruce Robertson
  List layouts and fields for specified file. Option to limit to match by field name.
   
7.   cfMatch ( value_to_test; match_Value; match_operator )
    Average rating: 4.2
  Bruce Robertson
  Test input to see whether it equals, contains, less than etc for match_value, returns boolean result
   
8.   Codify( theText; code_option )
    Average rating: 3.9
  Bruce Robertson
  Encode/decode any input text using native code() & char() functions
   
9.   csv.getColumn( array; returnColumn; delimiter)
    Average rating: 4.7
  Bruce Robertson
  Get designated column from delimited array
   
10.   csv.getColumn.if( array; matchColumn; matchValue; returnColumn; delimiter)
    Average rating: 4.6
  Bruce Robertson
  Get column from array for match in another column
   
11.   csv.getrows.if( array; matchColumn; matchValue; delmiter)
    Average rating: 4.5
  Bruce Robertson
  Return entire rows where value of matchColumn = matchValue
   
12.   Distribution( uniqueList; dataList)
    Average rating: 4.7
  Bruce Robertson
  For each item in list 1, counts occurrences in list 2
   
13.   DistributionTR ( uniqueList; dataList)
    Average rating: 4.4
  Bruce Robertson
  For each item in list 1, counts occurrences in list 2
   
14.   FormulaCall(formula; param)
    Average rating: 3.9
  Bruce Robertson
  Universal custom function - write your function outside the CF editor
   
15.   FrontTabs( layoutObjects; parent )
    Average rating: 4.1
  Bruce Robertson
  Provides a list of frontmost tab(s) and any enclosed selected tabs
   
16.   GetNthRecordXML ( theFields ; recNum ; encodeFlag )
    Average rating: 4.5
  Bruce Robertson
  Returns record data in XML format for nth record
   
17.   GetNthRow( fieldlist , N , delim)
    Average rating: 4.5
  Bruce Robertson
  Get multiple fields for Nth record
   
18.   GetNthRowObjectList( ObjectList; N; delim )
    Average rating: 4.5
  Bruce Robertson
  Get data from named layout objects such as fields in portals or record lists.
   
19.   GetRows ( fieldList, N , delim )
    Average rating: 3.9
  Bruce Robertson
  Get multiple fields across multiple records
   
20.   GetRowsObjectList( ObjectList; N; delim1; delim2 )
    Average rating: 4.4
  Bruce Robertson
  Retrieve data from named fields in a portal or record list.
   
21.   GetRowsXML( fieldList; startRow; endrow; type; encodeFlag)
    Average rating: 4.5
  Bruce Robertson
  Returns data in XML format for multiple fields and multiple records
   
22.   GetRowsXMLMatch(fieldlist ; startRow; endrow; type; matchexpression; encodeF
    Average rating: 4.0
  Bruce Robertson
  Get records in XML format for records meeting match criteria
   
23.   ListChanges( oldList ; newList )
    Average rating: 4.3
  Bruce Robertson
  Returns
   
24.   ListFunction( start; end; function )
    Average rating: 4.5
  Bruce Robertson
  Recursive function calculator
   
25.   matchListAB( ListA ; ListB; match_Value; match_operator ; getN )
    Average rating: 4.2
  Bruce Robertson
  Returns items from ListB where corresponding value of ListA meet condition. Option to return item position instead.
   
26.   MoveItem( myList; n1; n2 )
    Average rating: 4.5
  Bruce Robertson
  Moves item at position n1 to position after orignal n2
   
27.   PHP(param)
    Average rating: 3.8
  Bruce Robertson
  Use standard PHP in Filemaker calculations
   
28.   PositionValues( text; searchValue; occurrence )
    Average rating: 4.1
  Bruce Robertson
  Return value position (line number) in list of all occurrences of searchValue
   
29.   RepeatMatchTotal( dataField; matchField; matchValue; reps; record_count )
    Average rating: 4.5
  Bruce Robertson
  Create totals across record set where matchfield=matchvalue
   
30.   RepMatchSum( dataField; matchField; matchValue; reps; recNum )
    Average rating: 4.2
  Bruce Robertson
  Sum repeating field for reps where label field = matchvalue
   
31.   TypeSumField( TypeField; Type; SumField; Counter )
    Average rating: 4.2
  Bruce Robertson
  Sum a numeric field for records where another field matches input value.
   
32.   visualizeNumbers ( content; string)
    Average rating: 4.6
  Bruce Robertson
  Convert a list of numbers into a text line of characters defined by the numbers
   

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:

Under construction. Email me your wish list for improvements.