Opinion: The Best Sort System I've Seen (so far) скачать в хорошем качестве

Opinion: The Best Sort System I've Seen (so far)

Check out this clever and efficient sorting system for FileMaker list views, adaptable to any FileMaker solution. I've been using different methods for sorting in FileMaker for ≥30 years and this is one that I love and use in every solution. 0:00 Introduction and the problem with traditional sorting methods. 0:10 Demonstration: Sorting by clicking column headers (Company, Last Name, First Name). Ascending, descending, and unsorted states are toggled with each click. Sort icons provide visual feedback. 0:30 The "Simple Sort System" script: A single script handles all sorting logic, leveraging FileMaker's ability to infer the sort field from the current object. The script uses Go to Object to focus on the clicked field, then Sort Records without explicitly specifying the field. A global variable tracks and toggles the sort state (ascending, descending, unsorted). The Scroll Window command ensures the top of the list is visible after sorting. 1:00 Layout setup: Header buttons call the sort script, passing the corresponding field's object name as a JSON parameter (e.g., {"objectName": "person::last_name"}). Sort icons (up/down arrows) have conditional visibility based on the sort state global variable. 1:30 Integrating into a fresh database: Copy and paste the script. No errors because it's context-independent. 1:45 Copy/paste the header buttons and sort icons. 1:50 Adjust JSON parameters in the header buttons to match the new field's object name. 2:00 Modify conditional visibility calculations for sort icons to reference the correct object names and table occurrences. 2:10 Demonstrates a FileMaker quirk about naming objects with open popovers. 2:15 Testing in Script Debugger: Shows step-by-step execution, highlighting the dynamic field selection and sort state management. The Scroll Window command behavior is also showcased. 2:45 Review of the entire process and its benefits. Emphasizes the simplicity and adaptability of this method. This dynamic sorting technique significantly simplifies FileMaker development. Download the demo file, explore the code, and elevate your solutions! Read the blog article and download the file at: https://navarre.training/blog #FileMaker #Sorting #ListViews #UIDesign #Development