The Find Panel will find all occurrences of a word in the current list
Type in the box the text to search
Click Find or Enter
Click clear to the clear the search and start a new one
The query builder allows you to design a single or a multi condition (advanced)
query. A query is a method of filtering the list. Once you have designed a
query, the list will be filtered on those conditions.
To create a new
1) Select the desired field to query
2) Select the comparison e.g.
3) Enter a value e.g. "Chevy" then click "ENTER" on your
The query builder contains some more advanced query
Select Fields - Use this drop-down to select the ACT! field to filter
2. Comparison Selector - Use this
drop-down to select the comparison operator e.g. "Contains" or "Starts
3. Enter Filter Text - Use this drop-down to enter
the filter text e.g. "Chevy"
4. Show Fields - This
option uses values in a second field to be compared to the
Rather than using the value from 3. Enter Filter
Text, this 0ption will use the value from a second field. "Does
FieldA contain value from FieldB?"
5. Invert Criteria -
Use this option to invert the filter criteria e.g. "Show me all cars that do not
6. Add Criteria - Use this option to add
additional criteria line(s). "Show me all cars where the Make contains
'Chevy' and the Make contains 'Ford'.
7. Remove Criteria
- Use this option to remove additional criteria.
Here is a
1. Click on the QUERIES button on the toolbar.
Click on the CLICK HERE TO ADD FILTER CRITERIA button
3. Select Make
from the fields drop-down.
4. Select Contains from the
5. Enter the value of 'Chevy' in the text box then
If you would like to add additional conditions:
on the ADD CRITERIA button
7. Select Price from the fields
8. Select Greater Than from the comparison
9. Enter the value of '50000' in the text box then click
This query will return all rows where the make is Chevy and the
price is greater than $50,000.
Filter row allows you to quickly filter the list at the top of any column.
If you do place two values at the top of two columns the filter row will always
use an "And" comparison condition. Filter row is different to the query builder
in the fact that the filter row can not do advanced or multi-conditional
1) To access the filter row, click on the FILTER button on the
You will now see a empty filter row at the top of the list, displayed in yellow.
3) Enter a filter in any column, e.g. "United States" in the country column.
4) Click "Enter' on the keyboard. You now have this filter in place.
add additional conditions to the current filter, just enter the text in the
column header and click "ENTER" again.
Greater Than Or Equal To
Less Than Or Equal To
Is Not Null
Is Not Empty
Between Value A and B
Not Between Value A and B
Here are some examples of filter conditions you can try:
To find all contacts whose Country is empty just type "EMPTY" in the filter
row and click "ENTER"
To find all contacts whose Country is not empty
just type "!EMPTY" in the filter row and click "ENTER" ( Notice the explanation
mark before the word )
To find all contacts whose Country is either
Germany or France or the USA just type "Germany, France, United States" in the
filter row and click "ENTER" ( Notice each condition is separated by a comma )
To find all contacts that were edited this month just type
"(8/1/2005-8/30/2005)" in the filter row and click "ENTER"
To find all
contacts where a yes/no field is checked just select "TRUE" in the filter row
and click "ENTER"