Search Results
65 functions found:
| 1. | @JsonFixElement ( serialNum ; param ) |
| Alex Zueiv, Tashkent | |
| A helper for the native function JSONSetElement() to force objects appear in the order you set them. | |
| 2. | @sortValues ( the_values ; optional_datatype ; optional_locale ) |
| Tony White, Tony White Designs, Inc. | |
| wraps built in Function: SortValues ( values {; datatype ; locale } ) and trims training return | |
| 3. | AddAddHiddenSortOrder ( values ; currentValue ) |
| Richard Dyce, Dyce & Sons Ltd. | |
| Adds a number of BOM chars to the front of value lists for use in MagicValueList sorted pop-ups | |
| 4. | AddSortOrder ( values ; padWidth ; delimiter ; currentValue ) |
| Richard Dyce, Dyce & Sons Ltd. | |
| Add a numeric prefix to a lists of values, with leading 0's for easier sorting | |
| 5. | AS_dynamic_Sort ( List_of_FieldNames ; AscDescCustom ) |
| Thomas Siebert | |
| Sort records dynamically by a list of fieldnames and order. (OS X only, AppleScript) | |
| 6. | BubbleSort ( inputValues ; iterations ) |
| Greg Lane, The Moyer Group | |
| Sorts a list of return-separated values. | |
| 7. | BubbleSort_SlideValue ( inputValues ; target ) |
| Greg Lane, The Moyer Group | |
| BubbleSort_SlideValue is used by the BubbleSort function. | |
| 8. | cf_cwSort ( dat ; sep ; start ) |
| Fabrice Ricker, Kultur und Computer | |
| Shows from a date the calendas week in the form yy (separator) cw ... With the right year! | |
| 9. | CombineValues ( list1 ; list2 ) |
| Jonathan Stark, Jonathan Stark Consulting | |
| Combines two lists of values, sort of like php's array_combine function | |
| 10. | CustomQuickSort ( values ; valueFunction ; direction ) |
| Richard Dyce, Dyce & Sons Ltd. | |
| QuickSort using custom evaluation | |
| 11. | CustomValuesGreaterThan ( values ; reference ; valueFunction ) |
| Richard Dyce, Dyce & Sons Ltd. | |
| Values greater than reference, evaluated using a custom function | |
| 12. | CustomValuesLessThanOrEqual( values; reference ; valueFunction ) |
| Richard Dyce, Dyce & Sons Ltd. | |
| Values less than or equal to reference, evaluated using a custom function | |
| 13. | DateTimeAsSerial ( DateTime; ElemSep ; SectSep ) |
| Doug Larsen, August Technology | |
| Returns the date and time in a TEXT string that can be ordered properly. | |
| 14. | DateToSortableText ( thedate ) |
| Theo Ros | |
| Returns a sortable textual representation of a date value | |
| 15. | DeDupe ( startstring ; valuelist ) |
| Rob Westergaard, DataStorm Solutions | |
| This function removes duplicate values from an alphabetical value list. | |
| 16. | dispjahr (sorted;index) |
| Mathias Drexler, acib GmbH | |
| Collapses a list of sorted year numbers to a more readable format | |
| 17. | DistanceList ( BaseLat ; BaseLong ; ListOfLatLongIdentifiers ; Delimiter ; Units ; SortableDistance ) |
| Hal Gumbert, CampSoftware | |
| Prefixes a Value List containing Latitude, Longitude, and an Identifier with the Distance to the Base Lat, Long | |
| 18. | FlipDigits ( value ) |
| Theo Ros | |
| flips decimal digits for textual sort purposes | |
| 19. | fnAddressParser ( address ; type ) |
| Drew Wesley, Drewsol | |
| This CF parses address parts, allowing developers to create calculation fields for single address fields for display and sorting. | |
| 20. | fnNameParser ( name ; type ) |
| Drew Wesley, Drewsol | |
| c. 2012 Drewsol. This CF parses specified name parts (first, last, middle) from a single name field for the flexibility of sorting and/or display. fnNameStraight now handles Spanish names, and some middle-eastern names. | |
| 21. | FormatTimestamp.YMD_HMS (~timestamp ) |
| Thomas DS | |
| Convert a given timestamp to specific format: YearMonthDay_HourMinuteSecond | |
| 22. | GetNthRecordSet ( fieldName ; recordNumStart ; recordNumEnd ) |
| Jonathan Mickelson | |
| Calculates a return delimited and sorted, values list from related, or local, field data. | |
| 23. | GetNthRecSetUnq ( fieldName ; recordNumStart; recordNumEnd ) |
| Doug Jacobs, Restylers Choice | |
| Calculates a return delimited and sorted, values list from related, or local, field data. Eliminating duplicate values fromthe list. | |
| 24. | Get_Index ( TableName ; FieldName ; RecordSeparator ) |
| Chris Belanger, Innovative Solutions | |
| Use SQL to obtain a sorted "Index" [ValueList] on a Field | |
| 25. | IPToSortableText ( IPaddress ) |
| Theo Ros | |
| Returns a sortable textual representation of an IPaddress. | |
| 26. | isFirstRecordWithValue ( sortedBy ) |
| Max Heller, fmax software | |
| Used to hilite the first record of a given value in a sorted list of records. | |
| 27. | ITC_list__DateToTextList ( valueList ) |
| SL, ITC | |
| Convert a list of dates in the format DD/MM/YYYY to a list of dates in the format YYYY/MM/DD | |
| 28. | ITC_list__TextToDateList ( valueList ) |
| SL, ITC | |
| Convert a list of dates in the format YYYY/MM/DD to a list of dates in the format DD/MM/YYYY | |
| 29. | JSON.ArraySort ( array ; nestedPath ; fmDataType ; direction ; sortLocale ) |
| Josh Willing, Willing Apps | |
| Sort a json array. | |
| 30. | JSON.SortArray_v2 ( $jsonConfig ) |
| Kyle Williams, Augusto Digital | |
| Sorts a JSONArray using a JSONArray | |
| 31. | JSONAllKeys ( json ; prefix ; cont ; res ) |
| Ãngel MartÃnez Fernández, Lesterius Barcelona | |
| Get all keys of a JSON | |
| 32. | LeapYear ( yourDate ) |
| Shawn Rowland, Webconsort LLC | |
| Leap Year Boolean | |
| 33. | ListFieldsFromTable (TableOccurrenceName) |
| Andrew Duncan, Databuzz | |
| Returns a sorted list of all Field Names for specified Table Occurrence in the current FileMaker Pro v12 file (Table Occurrence can reference external files) | |
| 34. | ListOfJSONArray ( prefix ; theList ; cont ; res ) |
| Ãngel MartÃnez Fernández, Lesterius Barcelona | |
| Make a list of an JSONArray Element of a path | |
| 35. | ListSort ( ValueList ) |
| Theo Tromp, XS Consultants | |
| Sort of a (short) list without subfunctions (recursive) | |
| 36. | NamedLayoutObjects ( Layout ) |
| Ibrahim Bittar Torres, Eikonsys, S.A. de C.V. | |
| Returns a clean, sorted list of named layout objects for a given layout | |
| 37. | NaturalToOriginal ( value ; cont ) |
| Ãngel MartÃnez Fernández, Lesterius Barcelona | |
| Converts "natural" values to values | |
| 38. | NumToLetter ( integer ) |
| Shawn Rowland, Webconsort LLC | |
| Converts an integer 1 - 26 to the corresponding letter of the alphabet | |
| 39. | NumToSortableText ( value ; decimals ) |
| Theo Ros | |
| returns a textual representation of a number for sort purposes | |
| 40. | OriginalToNatural ( value ; cont ) |
| Ãngel MartÃnez Fernández, Lesterius Barcelona | |
| Converts values to "natural" values | |
| 41. | PortalSortKey ( parameter ; PortalFieldNames ) |
| Ugo Di Luca, DLSYSTEMS | |
| Using this calculation for your portal sorting key should render things easy. One script of 2 lines should be enough to sort any column either asc. or desc. | |
| 42. | PrependToList ( theItem ; theList ; cont ; res ) |
| Ãngel MartÃnez Fernández, Lesterius Barcelona | |
| Prepend a value into each value of a list separated by a point | |
| 43. | PutValue ( ValueList ; ValueNumber ; ReplaceString ) |
| Bill Thurmes, MDCA | |
| Replaces a designated value in a value list with another value | |
| 44. | QuickSort ( list ) |
| Jeremy Bante, OshVay Systems, Inc. | |
| QuickSort( list ) sorts list with the popular and reasonably efficient quicksort algorithm | |
| 45. | randomSort ( _string ) |
| Teruhiro Komaki, frudens Inc. | |
| Sorts strings randomly. | |
| 46. | ReverseAlphabet |
| Ugo Di Luca, DLSYSTEMS | |
| Helpful to dynamically sort ascending or descending by simple toggle | |
| 47. | reverseSortedNumberList ( start ; iterations ) |
| Jonathan Fletcher, Fletcher Data Consulting | |
| Number list (i.e. years) for reverse-sorted value list | |
| 48. | ReverseValue_CFpub ( text ) |
| Tony Miller, Fahrsoft | |
| Returns the text in reverse, including numbers; useful for reversing a portal sort calc | |
| 49. | shuffleList ( listToShuffle ) |
| Jan Bardi | |
| Standalone, quick & dirty list sort order randomizer using recursion. | |
| 50. | SortableTextWithNumbers ( text ) |
| Daniele Raybaudi, ACI | |
| Returns an alphanumeric string suitable for sorting mixed numbers and characters | |
| 51. | SortArray ( valueList ; sortDirection ; dataType ) |
| Mogens Brun, FM Integrator | |
| Sort an array (text, number, date or time ) ascending or descending | |
| 52. | SortArray_Merge ( leftList ; rightList ; sortDirection ; dataType ) |
| Mogens Brun, FM Integrator | |
| Merge two sorted lists of text, number, date or time values | |
| 53. | SortAsymptote ( ordinal ) |
| Jeremy Bante, | |
| Limits an ordinal to (-1,1), for nested sort calculations | |
| 54. | sortEncodeQueryString ( _queryString ) |
| Teruhiro Komaki, frudens Inc. | |
| Sort and encode the QueryString like "CanonicalQueryString" in Signature Version 4 of aws. | |
| 55. | SortList ( theList ) |
| Steve Thoms, International Plastics | |
| Sorts a return delimited list | |
| 56. | SortList ( ValueList ; Sort ; Type ) |
| Agnes Barouh, Tic Tac | |
| To sort a list, | |
| 57. | SortRecordsByJSON_AppleScript ( sort_array ) |
| Thomas Siebert | |
| Dynamic sorting for hierarchical field order to create nested subsummaries (macOS only) | |
| 58. | SortValue ( Value ; AscDes ) |
| Koji Takeuchi, TonicNote, Inc. | |
| Sort return-separated text. | |
| 59. | SortValues ( list ; sortAscending ) |
| Theo Ros | |
| Sorts the values in a list ascending or descending | |
| 60. | SortValues2 |
| Joshua Paul, Neo Code | |
| Sorts the values in a list ascending or descending. | |
| 61. | stringWithParams (string; paramList) |
| Nicolas Bourré | |
| Function that substitute parameters in a string. The parameters are placeholders with a specific format. This function act some sort like the printf function in C. | |
| 62. | ValuePlaceInSList ( SList ; Value ; Offset ) |
| Steven Zeidel, Zeiteq | |
| Returns the value line number (plus offset), in an ascending list of numbers, of the search value or the next highest value | |
| 63. | ValuesGreaterThan ( listvalues ; reference ) |
| Theo Gantos, TEKA, Inc. | |
| Returns all values in a list that are greater than the reference; it is referenced by QuickSort ( listvalues ). | |
| 64. | ValuesLessThanOrEqual ( list ; reference) |
| Jeremy Bante, OshVay Systems, Inc. | |
| ValuesLessThanOrEqual( list; reference) returns all values in list that are less than or equal to reference; it's used by QuickSort( list). | |
| 65. | _fn_Insert2SortedNumList(SList; Value; Order) |
| Lizhe Xu, APHIS USDA | |
| insert a numeric value into a sorted numeric list | |