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