grumbachr Posted October 26, 2009 Share Posted October 26, 2009 Can anyone point me towards a more clean solution for sorting and show sort order in a list view? I've been using the technique that is included with many of the older FileMaker free templates. This requires a global field 2 values to hold the icon. A calc field for each column you want to sort like, hilite_Status, hilite_City, hilite_State etc... It also requires 3 scripts for each hilite indicator. (So for the 3 columns hilties i mentioned I'd need 9 separate scripts). Can anyone point me towards a more clean solution for sorting and show sort order in a list view? If I could get this down to maybe on script per column it wouldn't be so bad. This one is just so cumbersome to keep implementing. Link to comment Share on other sites More sharing options...
Ocean West Posted October 29, 2009 Share Posted October 29, 2009 (edited) the better way would be to use fonts and conditional formatting to make them appear invisible for the unselected column and for the selected column and the current sort order use a font that is cross platform like: ▲ and ▼ For the column header you could even use a calculated repeating field that sets the the column label and includes or excludes the sort direction font dingbat depending on column selection. Edited October 29, 2009 by Guest Link to comment Share on other sites More sharing options...
Ocean West Posted October 29, 2009 Share Posted October 29, 2009 here is a sample file. sort.fp7.zip Link to comment Share on other sites More sharing options...
Raybaudi Posted October 29, 2009 Share Posted October 29, 2009 A note for windows users: in layout mode select the four labels ( four reps of the same field ) of the List layout and apply the ARIAL font, so that the arrows can be seen. Link to comment Share on other sites More sharing options...
grumbachr Posted October 29, 2009 Author Share Posted October 29, 2009 Thanks so much. Will take a little setup but will keep my solution much cleaner in the end. Link to comment Share on other sites More sharing options...
Witz Posted June 17, 2014 Share Posted June 17, 2014 Ocean West, thanks so much. I had this working in a few minutes. very nice. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3624 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now