Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Open a filter panel by clicking on a filter button.

  2. Click on the arrow to the right of the filter selection dropdown and select ‘New’.

  3. In the modal that opens up, give the filter a name and save it.

  4. Click the ‘Add Filter’ button.

  5. Click on the newly added filter item to set its properties.

    Field: the field this filter should look at.
    Operator: the operator to apply (equals, less than, greater than, etc.).
    Value: the comparison value. If the field is a lookup, you can search for a record by name.

  6. Click Done to save the filter item.

Using relative datetime/date values

...

colourYellow
titlesoon to be released

When filtering on datetime/date fields you have the option to use relative datetime/date values to do this click the Use relative date link.

...

  • Yesterday

  • Today

  • Tomorrow

  • This (week/month/quarter/fiscal quarter/year/fiscal year)

  • Last (week/month/quarter/fiscal quarter/year/fiscal year)

  • Next N (week/month/quarter/fiscal quarter/year/fiscal year)

  • Last N (week/month/quarter/fiscal quarter/year/fiscal year)

Multi-picklist considerations

Given the way multi-picklists are stored in Salesforce, this has implications when adding a multi-picklist filter. Assume a multi-picklist with the following options:

  • Option 1

  • Option 2

  • Option 3

When Option 1 and Option 2 are selected, Salesforce saves this as ‘Option 1; Option 2’. Hence this is also what you will need to provide to the filter in order for it to work.

Option 1 example

...

Option 1 & 2 example

...

Advanced Filter Options

You can create more complex filters by adding additional filter items. You can do this by clicking the ‘Add Filter’ button again.

...