Filter records in a table

Use field-specific conditions to focus a Table view on relevant records.

Filters limit a Table view to records that match the conditions you set.

A filter has three parts:

• Where selects the field to check.
• Operator defines how Ninox compares that field.
• Value supplies the value to match when required.

The available operators and value control depend on the selected field type. For example, text fields accept typed values. Choice fields offer configured options. File fields only check whether a file exists.

A filter only changes which records appear in the current table view. It does not change or delete records.

Add a filter

1

Open the filter options

Open the table you want to filter.

Click Filter in the view toolbar.

2

Choose a field

Under Where, select the field that contains the data you want to filter.

3

Set the operator and value

Under Operator, choose the comparison that fits the field.

Enter or select a value when the operator requires one.

4

Add or remove conditions

Select another field in Where to add a condition and narrow the records further.

After you add a filter condition, the number in parentheses shows how many conditions are active.

Click Remove filter to delete the condition.

Filter by what you want to match

Choose the field you want to filter. Then select an operator and enter the required value.

Match an exact value

Use is or is not when the field must equal a complete value.

• Text, Multi-line text, Email, Phone, URL, Location, Appointment, and Rich text: enter the complete value.
• Choice fields: select the choice or choices to match.
• Number: enter the exact number.
• Date: enter a date or select it from the calendar.
• Date and time: enter the complete date and time.
• Time: enter the time in hh:mm format, such as 10:00.
• Duration: enter the duration in hh:mm format, such as 01:00.
• Yes/No: select Yes or No.
• User: enter the exact user.
• Color: enter a color name, hex code, or RGB value.
• Icon: enter the icon name.

For a Color field, hover over a color in the table to see its name. For an Icon field, click the icon and check its name in the icon picker.

Match part of a value

Use contains or does not contain when any part of the value can match. Enter only the part you want to find. These operators are available for Text, Multi-line text, Email, Phone, URL, Location, Appointment, and Rich text.

Match values from a list

Use in list or not in list when any of several values can match. These operators are available for Text, Multi-line text, Email, Phone, URL, Location, Appointment, and Choice fields.

For text-based fields, enter complete values separated by commas. Matching is case-sensitive. For Choice fields, select the choices to match.

Compare values or date ranges

Use greater than, greater than or equal, less than, or less than or equal to compare values. These operators are available for Number, Date, Date and time, Time, and Duration.

Use in range for Date and Date and time. Select a predefined period such as Today or This week. Enter times and durations in hh:mm format.

Find empty or filled fields

Use is empty to find records without a value. Use is not empty to find records with a value. These operators are available for all fields in this reference. File, Signature, and Logic fields only support these operators.