Knowledgebase

Using The Find Feature

There were 11 articles found in this category:

1. Using the Find Feature
   Every file has a Find feature built into it. This allows you to search for records with a common element and can be broadly or narrowly defined as needed (e.g., find all wood moulding, or find all wood moulding that is two inches wide with the word oak in the Description field). 1. Click Find. ...
2. How to do a multiple find
   While in the find mode, you can narrow down your search criteria by selecting additional items. E.g., find all customers who are both photographers and want your newsletter. However, sometimes you want to find all customers who are photographers and all customers who prefer newsletters. Exampl ...
3. Performing Find By Date
   Entering dates or range of dates in a Find There are several ways of performing a find using a date field. You can find all records for a single day, or all records in a given period, or all records up to a certain date, or all records after a certain date. On a Single Date To find all records ...
4. Using the Omit Find Feature
   You can also do a find and then do a second request to omit certain records from your find. For example, in your Keywords you may have two items listed: Landscapes and Mail Not Active. You want to do a mailing to everyone who likes landscapes but you don’t want to mail to anyone who is mar ...
5. Entering Values in a Find
   When performing a find with number values, you can use the greater than sign (>) or the less than sign (<) (E.g. To find all values less than $500, enter: <500 or to find all values greater than $500, enter:>500). Numeric Tool Palette FileMaker Pro contains a symbol tool palette whic ...
6. Finding Duplicates
   It is important to not have duplicate moulding, product or client numbers. If you have two items with the same number, FrameReady will find and enter the first matching number. Do the following to find all duplicates. 1. Choose Price Codes file > Find. 2. Click in the field where you suspect ...
7. Using the find feature video
   See how to search for just about anything in FrameReady ( 6 min)
8. Finding Records
   When you Perform a Find, FrameReady searches through all the records, comparing the search criteria you specify with the data. Records with data matching the criteria become the Found Set which is the subset of records being browsed. Records that don’t match are omitted. The light green a ...
9. Performing an exact find
   If you want to do a search for one piece of matboard (e.g. B48), but you always get all the other matboard that starts with the same number (E.g. B4830, B4831, etc.) do the following: 1. Go to the Price Codes file > Find. 2. Type in a = (equal sign) and then the item you want to find B48. 3. ...
10. Finding records except those matching criteria
    You can omit records while performing a find. In other words, you can find information in your database that “does not equal” your specified criteria. For example, you can find all invoices except those created in the past 30 days. To find records that don’t match criteria: ...
11. Finding ranges of information
    You can find ranges of information, such as all records that contain a field value that is greater or less than a number, or between two particular dates. A range is different based on the data type: • Numbers: least to greatest • Dates, times, and timestamps: earliest ...