My preference would be a "Sort Records by JSON" script step, or a "specify JSON calc" checkbox in the existing "Sort Records" script step. It would make sense to be able to specify the sort fields combination "by calculation", so only one script step would be necessary for unlimited sort fields criteria combinations. This has to be "hardcoded" using the traditional "Sort Records" script step, that means having to create a script step for every single combination of multiple fields sort options. Still, this is not flexible enough when requiring sorting by more than one criteria (example, a report with more than one subsummary part, and need to hide or show parts depending on sorting fields). Go To Object (calc = $sortFieldObjectName).Set Variable $sortFieldObjectName with the name of the layout object name set to the field.There is a nice thing about "Sort Records by Field" : the field used to sort the found set can be "dynamically" defined using a variable, as long as the field has an object name specified in layout mode. I also think this change was present in FileMaker 10, but do not know if it was in the product prior to that. I believe the change to the sort behavior was initially called "persistent sorting" or "automatic sorting". Prior to all this, if you were to edit a record's data that was involved in the sort order, the record would not budge and the sort order would become "semi-sorted" (what you get today if you uncheck that checkbox). That feature, made it so FileMaker's default sort behavior would be to keep records sorted even if you alter a record's data that is targeted by the sort order (if a first name "Sam" is renamed "ZZZSam" and your records are sorted by first name, FileMaker will push the record where it belongs in the sort order.) That said, it is unclear if the feature was introduced in FMP12 or started to be documented at that specific location from FileMaker 12.īasically, this was introduced on or after sub-summary parts would display in browse mode (prior to that, they displayed only in preview more). This is very similar to the Replace command discussed above.The FileMaker 12 help makes a reference to this (see here). When you are totally confident that you want to make this change throughout your Found Set, go for the ‘Replace All’ button.
Once you are confident that you are doing the right thing, you can use the ‘Replace & Find’ button, which makes the change and immediately moves to the next record that has the ‘Find what’ information.Click and hold down your mouse button on the top bar and drag the dialog box off to the left or right to see the layout below.) (You may need to reposition the Find/Replace dialog box so you can see the effect the changes on a specific field. If you start with just the ‘Replace’ button, you will see the change in the record you are on.Remember to go back to the First Record when you are ready to make the change. Find Next will move you through the records revealing what you are searching for (the ‘Find what ’ item) It doesn’t make any changes.If you use these buttons in this order, you will be able to see the effects of what the changes you are asking FileMaker to conduct on your records.