How to secure your data in FileMaker Pro web publishing    25

3. 

Create a field to hold passwords for each record in the database.

For example, create a text field named PasswordRecord. Different values (passwords) can be 

placed into this field for different records. A user will need to know the password for a record to 

have access to that record.

4. 

In Browse mode, enter values that determine access in the PasswordRecord field as appropriate 

for your needs.

For example, entering the phrase 

MyPassword

 in this field for a given record will require the user 

to enter 

MyPassword

 into that same field on a web form prior to submitting a search, edit, or delete 

request for the record.

5. 

In the Web Security Database, locate or create a record for MyDatabase.fp5.

6. 

In the record for MyDatabase.fp5, enter 

PasswordRecord

 in the 

Field Name

 column.

7. 

In the 

Field Restrictions

 column, select the security options for this field as described in the 

following sections.

For more information on the Web Security Database, see  Using the Web Security Database  on 

page 29.

Protecting records from being viewed

Use the following code to prevent restricted records from being displayed as the result of a web 

based search. Customize the 

VALUE

 tags for your databases, layouts, fields, and HTML pages. 

To protect specific records from being viewed:

1. 

In the Web Security Database, select 

Exact Search

 for the password field.

2. 

In an HTML search page, enter commands similar to:

...

...

   
Password :