Multiple Search Terms for Companies, Suppliers, and Items – List & Pipeline Screens

Search across more than one column with multiple search terms. Search for more than one term in the same field.

Search Companies

For example, if you want to search for customers based the town of Bath that came through the website (a custom field) you can enter the search term

Bath;Website

Use semi-colons to separate out the search terms.

NewSearch2

Search Suppliers

For example, if you want to search for a plumber based in Hull from your supplier you can enter the search term

Hull;Plumber

Use semi-colons to separate out the search terms.

NewSearch1

Search Products

For example, to search for part of an item code (e.g. 145) and ‘Green’  in the description enter

145; Green

Use semi-colons to separate out the search terms.

Search

Search Multiple Times in the Same Column

For example, if you have a product code CHAIR_FG_145 you can now search for this by putting in:

CHAIR; 145

This will find any product code with both CHAIR and 145. This multiple search in the same column applies Customers and suppliers as well.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s