Tutorial Your first week in Laramin Step 7 of 11 · Stage 3: Work with lists. 0 of 9 steps done Exit tutorial

Filter a list

Narrow any list to the records you need with the filter bar, a column's own filter or the advanced "and / or" filter. See how many records match before you apply.

Why this step

Most lists have more rows than you need. A Filter: A rule that hides the rows you don't need, such as Status is Open. shows only yours, such as your open tasks.

Today you only need:

Applies to
Core 12.5 and later
Who can do this
Administrator, Team member

Before you start

  • Filters only appear on lists that offer them. A list with nothing to filter on has no Filters button.
  • The search box at the top left is separate from filters. Its placeholder says what it searches, for example "Search title, owner, phone…".

Add a filter from the filter bar

  1. Open the list. The filter bar sits above the table, with a chip for each filter the list uses most.

  2. Select a chip, for example Status. Its editor opens.

    The Requirements list with the Status chip's editor open, the is option chosen, On Hold ticked, and 2 of 14 would match shown beside Cancel and Apply.
  3. Choose a value. The editor fits the kind of filter: a checklist for a short set of choices, a search for a long one, From and To boxes for amounts, and presets such as Today, Last 7 days or This month for dates.

  4. Check the count under the editor, for example "3 of 14 would match".

  5. Select Apply.

To filter on something that has no chip, select Add filter, or press F. Type in Find a filter to narrow the list of fields, then choose one. Filters that are already running are listed under Already filtering.

The Requirements list with the Add filter menu open: a Find a filter box, fields such as Client From, Category and BHK, Status under Already filtering, and Advanced filter… at the bottom.

Tip: For an amount, leave one side empty to filter on "at least" or "at most". Where the list shows amounts in units such as Lakh or Crore, type the filter in the same unit. The full amount is spelled out under the box.

Use a column's own filter

  1. Find the funnel icon in a column heading.
  2. Select it, choose a value, and apply it.

If you prefer a row of filter boxes under the headings, open the gear (⚙) button in the toolbar and set Filters to Inline. Menu puts the funnels back.

Build an advanced "and / or" filter

  1. Select Filters in the toolbar, then Advanced filter… at the bottom of the list of fields.

  2. The Advanced filter panel opens beside the list. Choose whether to show records that match all or any of the conditions.

  3. Select Add a condition, then choose a Field, a comparison and a value.

  4. To nest an "or" inside an "and", select Add "one of these".

    The Advanced filter panel set to match all of its conditions: Category is Residential, Status is not Closed, and a nested group where Status is Active or On Hold, with Add a condition and Apply.
  5. Select Apply.

The advanced filter shows on the filter bar as one chip. Some lists can only match all conditions. They say so in the panel: This list can only match all of its conditions.

Remove filters

  • To remove one filter, select the × on its chip. A message offers Undo.
  • To remove them all, select Clear all on the filter bar, or the Clear filters button in the toolbar. Clear filters also clears the search box.

When nothing matches, the bar suggests which filter to drop, for example Removing "Status" would show 12. with a button to remove it.

Requirements list with Budget and Status filters leaving no matching rows; the filter bar says Removing "Status" would show 6, with a Remove Status button.

What happens next

The Filters button shows how many conditions are running, for example 2 filters, so you can't forget a filter is on. The filter is also kept in the page address, so you can bookmark the page or send the link to a colleague.

If the filter is too long for the address, the bar says This filter is too long to keep in the address. Save it as a view to keep it. See Save and share a view.

Some filters can't run on a particular list. Instead of showing an empty list, the bar says why, for example That filter is not available for this list. or That filter has too many conditions.

Check it worked

0 of 2 ticked

Tick each one you can see. Ticks stay on this device; they don't stop you moving on.

Check it worked

Something not right? A list is missing records

Back
Steps
Mark done