From the course: FileMaker Pro Essential Training (2019)

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Sorting using custom values

Sorting using custom values - FileMaker Pro Tutorial

From the course: FileMaker Pro Essential Training (2019)

Start my 1-month free trial

Sorting using custom values

- [Instructor] Many times when you're looking at records in a list view, you may want to sort them so that you can see them in a certain order. And as we've looked at in previous movies, you can see that you can add a single criteria, for example sort by state, and you could add multiple criteria, which means within each sort group, you can then sort again. And you keep doing that over and over again. One of the things is that you can sort by either ascending or descending order, which means depending on the field type, for example let's say if it's a text, you can sort A to Z, or descending would be Z to A. Number field types can sort in different orders, starting with zero going all the way up to whatever it is the ending number is, and you get the general idea. But what happens sometimes if we want to sort by for example, a text field but we don't want to sort alphabetically? Specifically in this case, if I click into the field and I do Command I or CTRL I, it shows me all the…

Contents