From the course: FileMaker Pro 12 Essential Training

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 12 Essential Training

Start my 1-month free trial

Sorting using custom values

Many times when you're looking at records in List View you want to sort them so that you can see them in a specific order. As we've looked at in previous movies in this chapter you can see that you can add single criteria or multiple criteria to your sorts, much like I'm doing here, State and then City, and those can also be modified to sort either ascending or descending. Now of course ascending and descending which are set here after you selected one of the values in the sort order, will sort differently depending on the field type. So for example it's a text, it's going to sort A to Z, if it's numbered, it's going to sort one through whatever number, and so on. However, that might not always work for certain types of sorts that you're doing in the database. Let's say for example we are going to do a sort by Status, clear out everything but Status, and so what it's going to do is sort alphabetically. So that's fine, we've got active here and then we've got inactive, pending…

Contents