FileMaker Pro Web Companion Help

 

Table of Contents

Click an underlined title to display the topic you want to read.

© 1998 FileMaker, Inc. All Rights Reserved. FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries.

 

About FileMaker Pro Web Companion

Welcome to FileMaker Pro Web Companion help. The FileMaker Pro Web Companion instantly publishes FileMaker Pro databases on the World Wide Web.

In the FileMaker Pro Web Companion home page, click the name of a database to view, find, sort, and update information.

Some databases require passwords. If the Password dialog box opens after you click a database name, type your name and password in the Name and Password fields.

Note Your access to certain actions, such as sorting, editing, creating, and deleting records, might vary.

[ Table of Contents ]

 

About Table View

Click the Table View tab to view multiple records at one time. For the best performance, display a small range of records.

Move the slider on the Record Range icon to view a different range of records. Or, click the Next or Previous button below the record data to view a different set of records. Click the Top button to go to the top of the page.

Specify the range of records you want to view in the Record range box and press Enter or Return.

The status area on the left provides useful information about the records you are browsing, such as the total number of records in the database, the number of records that have met your search criteria, and the sort status. The database name and record range information appear above the record data.

 

Options in Table View

Click

To

Sort

Rearrange the records

New record

Add a record to the database

Find all

Display the record range after a search, not just the search results

Click the number in the leftmost column to view a particular record in Form View.

Click Home to choose another database.

Note Your access to certain actions, such as sorting, editing, creating, and deleting records, might vary.

[ Table of Contents ]

 

About Form View

Click the Form View tab to view one record at a time.

Click the top half of the book icon to view the previous record.

Click the bottom half of the book icon to view the next record.

You can also type a record number in the Record box and press Enter or Return. You can also move the slider in the book icon.

The status area on the left provides useful information about the records you are browsing, such as the total number of records in the database, the number of records that have met your search criteria, and the sort status. The database name and record range information appear above the record data.

 

Options in Form View

Click

To

Sort

Rearrange the records

Edit record

Modify the current record

New record

Add a record to the database

Delete record

Delete the current record from the database

Find all

Display all the records in the database, not just the search results

To view the current search results in a list, click the Table View tab.

Click Home to choose another database.

Note Your access to certain actions, such as sorting, editing, creating, and deleting records, might vary.

[ Table of Contents ]
 

Searching for Records

Click the Search tab to look for a particular record or a group of records. To find records, you specify search criteria (the values you want to find) in the Search page. A search examines all the records in the database and returns the search results, the set of records that matches the search criteria. The search results are displayed in Table View.

To find a record or group of records:

  1. Click the Search tab.
  2. Choose Match all words on page (AND) to find values that match all the search criteria in the same field or across fields. Choose Match any words on page (OR) to find values that match one or more search criteria in the same field or across fields. See Search tips for more information.
  3. On the Search page, choose the type of search next to the field you want to search on.
  4. For the field you want to search on, enter the search criteria.

    To refine your search, you can type additional operators for the field you want to search. For example, to find all the records that are between five and ten, type 5...10 directly into the Criteria field. See the table of operators below.

  5. Repeat steps 3 and 4 for as many fields as you want to search (for example, a specific last name and first name).

    To reset the search criteria, click Clear fields.

  6. Click Start search to search the database.
  7. The record or records are displayed in Table View.

Search Tips

The Match all words on page (AND) and Match any words on page (OR) options search both inside and across fields.

To search for

Select

And type

All records in the city of San Francisco (but not other cities whose names contain either "San" or "Francisco")

Match all words on page (AND)

"San Francisco" in the City field

All records in the cities of San Francisco or Paris (as well as all cities whose names contain either "San", "Francisco", or "Paris")

Match any words on page (OR)

"San Francisco Paris" in the City field

All records in the city of Paris and the country of France

Match all words on page (AND)

"Paris" in the City field and "France" in the Country field

All records in any city named Paris, as well as all cities in the country of France

Match any words on page (OR)

"Paris" in the City field and "France" in the Country field

Note You cannot combine AND/OR searches on a page.

You can further refine your search by using the following operators inside the field. For example:

To find values that are

Use this operator

Example

Less than what you type next

<

<40 finds all the records less than 40

Less than or equal to what you type next

<=

<=05:00:00 finds all the records less than or equal to five o'clock

Greater than what you type next

>

>05:00:00 finds all the records after 5:00

Greater than or equal to what you type next

>=

>=Smith finds all the records whose last name is alphabetically after "Smith"

An exact match

= (before criteria)

=Smith finds all the records where the last name is "Smith," but not Smithson

Within the range you specify

... (3 periods)

12:30...17:30 finds all the records between 12:30 and 17:30

Duplicate values

!

! finds all the records that have duplicate values in a field

Today's date

//

// finds all the records that have today's date

Invalid dates or times

?

? finds all the records that have invalid dates or times

One unknown or variable text character

@

@on finds all the records that have 3 characters and end in "on," such as "Don"

Zero or more unknown or variable text characters

*

*smith* finds all the records that have "smith" in the name, such as "Smithson," "Blacksmith"

Literal text in a field (to find characters that aren't automatically searched, such as ",")

" "

", Ltd." finds all the records that have ", Ltd."

Empty fields (for example, records of unfilled orders)

=

= finds all the records that have no values

Click Home to choose another database.

In Table View or Form View, click Find all to display all the records in the database, not just the search results.

Note Your access to certain actions, such as sorting, editing, creating, and deleting records, might vary.

[ Table of Contents ]

 

Sorting Records

You can rearrange the order of the records in a database. Records can be sorted in ascending order, descending order, or a custom order based on a field's list of choices. You can sort on up to four fields.

To sort records:

  1. In Table View or Form View, click Sort.
  2. On the Sort page, choose the first field (for example, Last Name) and the sort order.
  3. To sort on additional fields (for example, Last Name and then First Name), choose the additional fields.

    To reset the sort order or choose different fields to sort by, click Clear fields.

    Click Back to view to return to Table View or Form View without sorting the records.

  4. Click Start sort.

Click Home to choose another database.

Note Your access to certain actions, such as sorting, editing, creating, and deleting records, might vary.

[ Table of Contents ]
 

Adding Records

Use the New Record page to add information to the database.

To add a record:

  1. In Table View or Form View, click New record.
  2. On the New Record page, click in a field to type the new information. Press Tab to move between fields.

    To clear the new information you've typed, click Revert.

    To return to Table View or Form View without saving a record in the database, click Back to view.

  3. When you finish typing the information into the fields, click Save record.

    The record is added to the database. You see a page confirming that you have created a new record.

  4. Click OK to return to Table View or Form View.

Click Home to choose another database.

Note Your access to certain actions, such as sorting, editing, creating, and deleting records, might vary.

[ Table of Contents ]

 

Editing Records

Use the Edit Record page to permanently modify a record in the database.

To edit a record:

  1. In Form View, click Edit record. In Table View, select the record you want to edit by clicking the hypertext number on the left of the record. Then click Edit record in Form View.
  2. On the Edit Record page, click in a field to modify the information.

    To undo changes and return to the original field values, click Revert. You cannot revert to the original values after you click Save record.

    To return to Form View without saving your changes, click Back to view.

  3. When you finish modifying the information in the fields, click Save record.
  4. Click OK to return to Form View.

Click Home to choose another database.

Note Your access to certain actions, such as sorting, editing, creating, and deleting records, might vary.

[ Table of Contents ]

 

Deleting Records

In Form View, you can delete a record from the database. When you delete a record, you are permanently discarding the data that is entered in all the fields in that record.

To delete a record:

  1. In Form View, click Delete record. In Table View, select the record you want to delete by clicking the hypertext number on the left of the record. Then click Delete record in Form View.

    You see a message confirming your request to delete the current record.

  2. Click Delete to delete the record. Or, click Cancel to return to Form View without deleting the record.

Click Home to choose another database.

Note Your access to certain actions, such as sorting, editing, creating, and deleting records, might vary.

[ Table of Contents ]