Brian Dunning's FileMaker Custom Functions

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
 

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: