Developer’s Guide

Publishing your database on the Web 6-11
9. Click Done to close the Define Fields dialog box.
For more information, see chapter 11, “Using formulas and
functions,” in the FileMaker Pro 5 User’s Guide or see
FileMaker Pro Help.
Exporting data to a static HTML page
To quickly display the existing data in your FileMaker Pro database
on the Web, you can export it into an HTML table and publish your
database as a static web page. To automate the exporting process on
a regular basis, use a FileMaker Pro script and control the timing for
when the exported table is uploaded to the web site.
Note Images in container fields cannot be exported. To display them
on your web site, place the image files in the Web folder and insert
reference links to them in a text field in the database (or insert image
links in the exported HTML table).
To export the data into an HTML table:
1. Open the FileMaker Pro database and create a sorted found set
with the records you want to export.
If you are going to export subsummary data, include the break field
in the sort order.
2. In Browse mode, choose File menu > Export Records. Type a name
and select a location for the exported file. Then, choose HTML Table
Files (Windows) or HTML Table (Mac OS) for the file type, and click
Save.
External function’s
name and parameter Description of external function
Web-Version, 0 Returns the version of FileMaker Pro Web
Companion that loads when you open
FileMaker Pro
Web-ClientAddress, 0 Returns the domain name (for example,
www.filemaker.com) of a web user whose HTTP
request is currently being processed by the Web
Companion. Returns the web user’s IP address if the
domain name is not available.
Web-ClientIP, 0 Returns the IP (Internet protocol) address of the
web user whose HTTP request is currently being
processed by the Web Companion
Web-ClientName, 0 Returns the value that the web user types for a
user name in the web browser password dialog
box
Web-ClientType, 0 Returns the name and version of the web
browser being used by the web user
Web-ToHTML, field name
Web-ToHTML, text value
Returns the contents of the specified field or text
value encoded in HTML. This is useful, for
example, when you want to modify a data field
with a calculation and then use it as an error
page.
Web-ToHTTP, field name
Web-ToHTTP, text value
Returns the contents of the specified field or text
value encoded in HTTP. This is useful for fields
containing data that should be handled as URLs
in HREF links by the browser. For example,
“Display Art” becomes “Display%20Art.”