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 20 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: