How to add Filters to your List

Published: Sep 01, 2023

How to add Filters to your List

Published: Sep 01, 2023

In this example, you will learn how to filter your list so you can see the data you prefer to see. For this example, you have a payment list and want to see the donations for in the month of February.

Statements that use ‘and’ & ‘or’ behave very differently. When combining two pieces of logic, ‘and’ signifies that both conditions are required for the data to show while ‘or’ signifies that only one condition must be met. These statements can also be used in conjunction.

How to add filters to a list

1. Select the list you want to add filters to.

image 288

2. Select Filter above your list.

image 289

3. The Filters window will open. Select Add a filter.

image 290

4. For this example, you will add a filter that shows the data the month of February.  First, you want to filter by Document date to show only dates for the month of February.  To do this select Document date, Greater than or equal to, and 02/01/2025.  This means the Document date will be on 02/01/2025 or after.

image 291

5. Select Add another filter to add another filter and you will see it creates it with an and.  You want to make sure that you don’t get any dates that are after February, so leave it with the and. Then select Document date, Less than or equal to, and 02/28/2025.  This means the Document date will be on or before 02/28/2025.

image 292

6. Since you could have other documents during this time frame, you will want to make sure you filter on only those documents that have a Status of Open.  Select Add another filter again to add another filter. Select Status, Equals, and select Open.  This will also be an and for the filter because it has to meet all the criteria for the data you want to see.

image 293

‍‍

7. Select Save to see the results.

‍8. The results now show you the data from the month of February, that have a status of Open. 

 

image 294

 

Questions on adding filters? Email support at support@eonesolutions.com

Content
How to add filters to a list

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

Filter Results
Content Type
Reset Filters