Jump to content
Dave Ramsey

Default sort order override

Recommended Posts

Hello, my ad-hoc steering committee...

I'm shortly going to be tackling allowing an override of the default sort order.  Once implemented, there would be a preference to override the default sort order for all(-ish) queries to sort alphabetically, rather than by export / creation order.  I would love to get some feedback on this idea, in particular that I'm not either targeting too narrowly or too broadly.

My thought is that this could be best implemented using 3 checkboxes.

  1. Sort almost everything alphabetically by default
  2. Sort Layouts alphabetically by default
  3. Sort Scripts alphabetically by default

I think that for most users, sorting fields, TOs, references, etc by name by default will not cause a problem.  Most of them won't even need a preference for that.  They'd like it always on.  I have, however, identified users that would like to retain general access to the imported sort order.

I've identified Scripts and Layouts as two elements that very commonly are manually ordered.  Most developers will group similar layouts and scripts, even assuming that they have a naming convention that would allow for meaningful interaction with these elements (say, Scripts) alphabetically.

I also don't think there's any value to sorting Layout Objects in anything other than import order (by default), as the import order is a parent-child aware z-order.

I'm also thinking that this will necessitate the addition of a column in the Results pane that stores the creation / import ordinal so that you have the ability to restore that order (or reverse that order) if necessary for a single query.

Questions:

  1. Can you think of any other elements within FileMaker whose creation / manual order is far more important than their alphabetical order?
  2. This is oft requested enough that I'm considering changing the first checkbox (sort most items alphabetically) to ON by default.  I think I will have fewer users asking how to change it back than I currently have users asking how to turn it on.  Thoughts?
  3. While neither the Hierarchy Browser nor the Columnar Browser have a base implementation for overriding the sort order on an area by area basis, I might try to invent one if there's huge desire for it.  I still that most users will never tweak the default, but I'm willing to be proven wrong.

In a fever-dream, I thought that instead of adding checkboxes to the preferences, I would add menu items that could be toggled on and off.  This only becomes of use if somebody sees being able to override this on a document-by-document basis, and really regularly, as a critical requirement.  If this is you, I'd like to hear from you.  I'm pretty sure that the overwhelming majority of users will turn it on, and never mess with it.  Most will never even override that default sort to use the new import ordinal column.

Any other thoughts or ideas related to this topic would be most appreciated.

 

Thank you very much,

Dave Ramsey

Share this post


Link to post
Share on other sites

For those who were interested, version 1.2.3 has been released with support for this feature.  Thanks!

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By Ponderosa
      Totally not sure if I've put this thread in the right topic category, as I'm not even sure how to go about this. First, I'd like to be very clear on the fact that, if possible, this will be done without scripting. I'm hoping for some kind of calculation. IDK. Anyway, I'm trying to copy or Calc one field from an older record to its newest match (using BatchNum field to match). The two fields are different fields (FormNum is the ID number field) (RefID is the the reference field for FormNum ). RefID would allow the user to find the last time the same arrangement of data (FormNum being its ID number) was used. It's meant as sort of a skipping stone effect, if that makes sense.
      My thought was to create a filtered value list of some kind and just set RefID with the highest ID number from FormNum, prior to the newest entry. Or organize by newest Date Created, prior to the newest entry. Again, IDK.
      I'm quite stumped and hope this rambling makes sense to you very helpful people. Thanking you in advance....
    • By Richard Carlton
      FileMaker Coaches' Corner - Tip 5 - Portal Record Moving via Sort
      https://youtu.be/pVt432ZlTVs
      For this Coaches’ Corner tip, Kristian Olsen explores using sorts to move a portal record up or down.  The key is Sorts!
      Grab the sample file here: http://bit.ly/2FTJn3k
      http://www.fmcoachescorner.com
      Most Recent Upload https://goo.gl/Dbn9fm
      Get up to speed with the FileMaker Pro 16 Video Training Course! 
      Top Rated Course by FileMaker Expert, Richard Carlton. 
      http://learningfilemaker.com/fmpro16.php
      Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 26 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference, Richard will teach you all the ins and outs of building FileMaker Solutions. 
      The course is 50 hours of video content!
      Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide. 
      Richard works closely with RCC's staff: a team of 28 FileMaker developers and supporting web designers. 
      He has offices in California, Nevada, and Texas.
      Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client-server integration.
      Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution.
      Looking for FM Starting Point free software download: http://www.fmstartingpoint.com
      Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development.
      RCC, Filemaker Videos, and LearningFileMaker.com are headquartered in Santa Clara, CA.
      http://www.rcconsulting.com/
      Please feel free to contact us at support@rcconsulting.com
      FileMaker Pro is simply a powerful software used to create custom apps that work seamlessly across iPad, iPhone, Windows, Mac, and the web
      Transform your business with the FileMaker Platform
      Free FileMaker Training Videos Channel https://www.youtube.com/user/FileMakerVideos
      50 Hour FileMaker Pro 16 Video Training Course-FileMaker 16 News-Online FileMaker 16 Training Videos
      https://www.youtube.com/watch?v=KpQqLLDcZ8I
      Playlist https://www.youtube.com/watch?v=KpQqLLDcZ8I&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_&index=13
      Top 10 New Features in FileMaker 16-FileMaker 16 News-FileMaker 16 Instructional Videos-FileMaker 16
      https://www.youtube.com/watch?v=urh8iHOCxkg
      Playlist https://www.youtube.com/watch?v=urh8iHOCxkg&t=130s&index=1&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_
      Sharing your Database with Other Devices and Users-FileMaker 16 News-FileMaker 16 Database Sharing
      https://www.youtube.com/watch?v=GF82vkYtCtA
      Playlist https://www.youtube.com/watch?v=GF82vkYtCtA&index=8&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_
      Introduction to FileMaker WebDirect 16-FileMaker 16 News-Online FileMaker 16 Training Videos
      https://www.youtube.com/watch?v=uaZKIpBjMAM
      Playlist https://www.youtube.com/watch?v=uaZKIpBjMAM&list=PLjTvUZtwtgBSVV1-4pFG4SHAhCIP3Yy-I&index=17&t=10s
      A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data
       
      Official site provides the SDK, Developer's Guide, Reference, and Android Market for the open source project
      http://learningfilemaker.com/FIAS.html
      https://sites.google.com/site/filemakerprotrainingd2n/home/filemaker-training
      https://drive.google.com/file/d/0ByHcthu5EL9NSmowQm9OUDdZZ1k/view?usp=sharing
      Free FileMaker videos check out ...http://www.filemakervideos.com
      Download the FileMaker Pro 16 & FileMaker GO 16 for mobile devices training videos at http://www.learningfilemaker.com
      Download FileMaker Go 16 video training at http://learningfilemaker.com/FMGO-16/fmgo16.php
      Download FileMaker 16 Full Video Training Bundle at http://learningfilemaker.com/subscription.php
      FileMaker Video Training Review-FileMaker 16 Video Course Review-FileMaker Pro 16 101 Course Review
      https://www.youtube.com/watch?v=mF6Uor0KmKo
      Playlist https://www.youtube.com/watch?v=mF6Uor0KmKo&list=PLjTvUZtwtgBT8tNHuzF6cOKC_37zCTQl6&index=18
      Use FileMaker to create an app with the FileMaker Training Series
      FileMaker Pro is a cross-platform relational database application from FileMaker Inc.
      Comment, Like & Share Our Videos.
      Feel Free to Embed any of Our Videos on Your Blog or Website.
      Follow Us on Your Favorite Social Media
      https://www.facebook.com/FileMakerVideos
      https://twitter.com/filemakervideos
      https://plus.google.com/+FileMakerVideos/videos
      #FileMakerCoachesCorner
      #FileMakerPro16Training
      #FileMakerPro16Videos
      Playlist: https://goo.gl/ycpCqW
      Google RSS Feed : https://goo.gl/hxtYvW
    • By Siva D
      Is there any way to get the list of scripts that having webdirect incompatible script steps in FMPerception? It will be helpful when converting the existing FMP layout/scripts to webdirect.
    • By William Slim
      Hi all,
      Figures for broken references differ completely on the Report Card vs the 'Broken References' node if FMPerception. Some figures, such as 'Impacted Layouts' are empty in the report card '--' yet may have '24' in the Broken Refs node.
      What is the difference between them/how should they be interpreted? 
      I'm guessing the node should be relied upon but I'm having difficulty tying up figures between the two even at a headline level. In this particular instance: 'Fields Impacted' on the report card states '15' yet <Field Missing> and 'Empty Field Reference' are both in the 60's.
      Thanks in advance,
      Lee
       
    • By Hoytopher
      Apologies if this is in the wrong forum, new to FileMaker and unsure of how to articulate what I'm trying to achieve.
      I am trying to reorganize a database using FileMaker. My client's work is literary, and wants to be able to sort agents/editors by their publishing house/imprint. I am using the Personnel Files starter solution, as it comes with some of the features I'm looking for, particularly the "Personnel List". A quick summary of relationships:
      Publishing Houses [House] are parent companies. Sometimes they do their own publishing, but it's often left to children companies, or Imprints. There are House-specific publishers, editors, etc [People].
      Imprints [Imprint] are composed the exact same way, with Imprint-specific People. They are owned by parent companies. For simplicity, lets assume that every House has 5 Imprints.
      Editors/Publishers/etc [People] have their own specific pages. House/Imprint use duplicate layouts (companies), same with different categories of People.
      I want to achieve the following:
      The ability to use the Personnel list to sort either alphabetically by name (as is done currently). I also want to be able to sort by Publishing House -> Imprint -> [People]. What do I need to know to do this? I envision a list of all Houses. Then, clicking on one, the imprints show up in an adjacent list. Clicking on the Imprint, People working for that Imprint pop up, and then clicking on one of them leads to their Details page (currently set up). In order to view details on the House itself, the House's own page would be set up as an Imprint.
      What are the gaps in my knowledge here? Where should I start? I am trying to create a system of increasing specification for finding data quickly.
       
  • Who Viewed the Topic

    11 members have viewed this topic:
    Robert Mota Hawks  V!ncent  gczychi  arni  Lee Smith  fillmore  Ron Cates  Fitch  Lola  OlgerDiekstra  rwoods 
×

Important Information

By using this site, you agree to our Terms of Use.