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