AS_dynamic_Sort ( List_of_FieldNames ; AscDescCustom )

Sort records dynamically by a list of fieldnames and order. (OS X only, AppleScript)

Average rating: 4.3 (19 votes) Log in to vote

Thomas Siebert - Show more from this author
http://www.t-seabird.de

Sample input:

AS_Sort ( "Zip¶LastName" ; "asc" )

Sample output:

Sort records by fields "Zip" and last name in ascending order.

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
AS_dynamic_Sort ( List_of_FieldNames ; AscDescCustom )

version 11
---------------------------------------------
Thomas Siebert, 07.06.2017
thomas@t-seabird.de
www.t-seabird.de
---------------------------------------------

Sort records dynamically by a list of fieldnames and order.

AscDescCustom: asc, desc, ascending, descending, custom

Use the ScriptStep "Perform AppleScript" using the option "Calculated AppleScript"
You also shall use "Perform AppleScript" directly from a button.

*/

Let ([
myTable = Quote ( Get ( LayoutTableName ) ) ; 
myFields = "field \"" & Substitute ( List_of_FieldNames ; [ ¶ ; "\" of table " & myTable & ", field \"" ] ) & "\" of table " & myTable
];

"set SortOrder to " & Substitute ( Lower ( AscDescCustom ) ; [ "asc" ; "ascending" ] ; [ "desc" ; "descending" ] )  & "
¶
¶tell database " & Quote ( Get ( FileName ) ) & "
¶		sort layout " & Quote ( Get ( LayoutName ) ) & " by { " & myFields & " } in order SortOrder
¶end tell"
 

)

Sort records dynamically by a list of fieldnames and order.

Use the ScriptStep "Perform AppleScript" using the option "Calculated AppleScript"
You also shall use "Perform AppleScript" directly from a button.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

AS_dynamic_Sort ( List_of_FieldNames ; AscDescCustom )

Comments

Support this website.

Support this website.