Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Often when you're working with FileMaker, and you have a large sets of records, you may just want to look at them in a certain order. This, of course, is where Sorting comes in to play. Sometimes when you're sorting, you may have multiple, different criteria that you need to sort by. For example, you see here we've got 1,523 records, and if I sort them all by State - first clearing out any previous order I move state over and then hit Sort - you see that we've got a lot of duplicate matches within each state.
So what about if I want to see them by State, and then within State I want to see them sorted by City? That's pretty easy to do. Just go back into your Sort dialog as you saw moment ago, we can move another criterion. So now when I hit Sort, it's not only sorting within the State, as you see here, here's all that records for ME, and with each record for ME it's then sorting alphabetically by City, as well. You can continue to do this by layering multiple values on top of each other inside the sort order, but the order in which they appear is pretty critical to the way that it sorts.
So first it's going to sort by State, and then only if they find matches within records in the State field, it will then sort those matched records by City. You can add another level here if you want, but the only time it's going to sort is if the State values match in records, the City values match in records, and then it will kick into yet another sort value. So in this case, we don't have a lot of duplicate cities, so it won't make much more sense to sort beyond just two values, but you certainly can. So in cases where you need to sort within a sort group, just use multiple criterion in your Sort dialog box.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 64717 Viewers
80 Video lessons · 124327 Viewers
52 Video lessons · 60259 Viewers
59 Video lessons · 46095 Viewers