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