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