Previous Topic

Next Topic

Book Contents

Book Index

Filter any column to show only what you want

Every column in List Fields has the ability to filter information. This means that you can select a subset of the complete list to narrow down the list. For example, you have a field list with many field types, as seen below:

Instead of working with the complete list, you can click on the "fat little arrow" on the Type column.

You will see a list of available values, starting with (All) and (Custom). The rest of the values in this list is automatically created by List Fields and contains all unique values for this column.

If you want to see only the Text fields, click on the "Text"-filter as shown above. The result is that the list instantly shows only Text fields:

Note that the "fat little arrow" turned blue, to indicate that a filter is active.

Help, get all my rows back please!

To revert back to all rows, click the little arrow again and select (All). The blue arrow will revert back to black, to indicate that no filter is activated.

Set filter on multiple columns if you like!

Activate filters on any visible row to create just the selection you want!

And finally, set a custom filer ...

If the filter list, you will always see (All) and (Custom). Pressing (Custom), brings up this dialog box:

You can set any combination of two filters, and as you see from the screenshot above, you can create fairly advanced filters to extract exactly what you want!

When you combine column filtering with column sorting, column grouping and column reordering, you can create almost anything

See Also

The Field List Area

Select Visible Columns

Sort any column in any direction - even multiple columns at the same time

Reorder columns in any order

Group on any column

Show this document in Notes

Add- or delete fields