It is often useful to view only a
selection of records that have certain aspects in common. For example,
if you record all your online purchases in an iData Kwik datafile, you
might want to look at
only the records from one particular vendor. Or, you may wish to look
all the records that have been shipped, but not received. To do this,
the Records... item from the
Select menu (or type command-E).
Clicking the selected records numbers in the datafile window will also bring up the Select Records dialog:
Selecting records is most powerful when the datafile has fields, but can also be used with datafiles that have no fields. Here are some example selections in a datafile that has no fields.
The illustration above shows how you would select all records that contained "California".
If this were a simple freeform address file, the second selection example, above, would select all addresses in California outside of Los Angeles.
Every record in iData Kwik has a hidden
creation date and modification date. These dates can be used in the
selection process by selecting Created
Date or Modified Date
in the Select Records Based On:
popup menu, the selecting Dates
in the Treat Content As: popup
menu. The example above would select all
were created in 2004 or later, but not modified today.
Text in fields can also be treated as
dates, rather than as literal text. The example above will select not
only records in which the Completed On
field contains "07/01/06", but
also records in which it contains text such as "1 Jul 06" and "July 1,
2006". This also permits "Earlier Than" and "Later Than" comparisons,
as shown above for creation and modification dates.
In a similar way, text in fields can be treated as numbers, rather than as literal text. This permits "Greater Than" and "Less Than" comparisons based on numerical value, as in the example above.
If the datafile has
fields, you can limit the selection criteria to a specific field. In
this example from my online purchases datafile, the selection would
records for purchases where the item has shipped, but not yet been
received. I find this useful for tracking orders.
So, you want to do a mailing to the people who have purchased one of the two products, want to be notified, and are not in California. That is more than you can do in the Select Records window. Here is how you would make such a selection.
1. Select records that contain CA or MA in the State field. Now, only the records for customers from California and Massachusetts will be selected.
2. To add all Iowa customers to this selection we will use Select More from Omitted... from the Select menu. In this window, select records where State contains IA. Now all California, Massachusetts, and Iowa records will be selected.
3. From the Select menu, choose Switch to Omitted to change the selection to all customers not from California, Massachusetts, or Iowa. So, now you have all the customers in states where the new racing exhaust is street legal.
4. Now we want to limit the selection to owners of Acura and Honda cars. With Records... in the Select menu make a selection where the Car field contains Acura or Honda. This will result in a selection of all Acura and Honda owners in states where your product is street legal.
5. There is only one step left. That is to select only the customers who wish to be notified. Simply select records where the Notify field contains "y".
Now, only customers who want to learn about new products, have an Acura or Honda, and don't live in CA, MA, or IA are selected. You can go through the records and send email messages to all of them, or you can save the file with the Save Selected As... item in the File menu.
A selection will not be saved when you save a datafile and close it. When it opens again, all records will be selected.
If you get into trouble when making a selection and it doesn't come out the way you wanted, you can use All Records in the Select menu (or type command-option-A) to select all records and start over. Or, you can use the Revert to Previous Selection to just go back one step.
Occasionally, you may find the Deselect
Record command useful to remove
or two records from a selection. If you did a select for records where
begins with "ca" (to select California records), and one customer is
Caledonia, you can just deselect the one record. Use the command-option-control-D key
combination to perform this command from the keyboard.