Would also suggest changing the multiplier in the two sort field calculations from 100 to 1000 or even 10000 otherwise it won’t sort correctly if your number has more than 2 decimal places, i.e., change “100 * GetAsNumber” to “10000 * GetAsNumber”. Reply
This is great! Thank you for sharing. I had a few issues you may wish to address… 1) For some reason FieldType ( Get ( FileName ) ; $$SORT.TOSORT ) does not work properly in the two sort fields … it appears the Get (Filename) is the culprit. (Using FMP 19.6.1.45 on MacOS). Changing this to FieldType ( “” ; $$SORT.TOSORT ) appears to have fixed the issue. 2) There’s a typo in the Script Parameter calculation in Segment 1 of Button Bar 10… the Sort should be 2, not 1. Currently Reads: [ “Sort” ; 1 ; JSONString ] Should be: [ “Sort” ; 2 ; JSONString ] Reply