From the course: FileMaker Pro Essential Training

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Sorting using custom values

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 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 can add multiple criteria, which means within each sort group you can then sort again. And you can 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…

Contents