Developer’s Guide

6-16 Developer’s Guide
For more information, see chapter 11, “Using formulas and
functions,” in the FileMaker Pro 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.
3. In the Specify Field Order for Export dialog box, indicate how you
want FileMaker Pro to export the data by selecting fields in the left
box and moving them to the Field Order box on the right — in the
order that you want them to appear.
4. To export a related field, choose the relationship from the pop-up menu.
The related fields for the relationship you chose are then listed in the
Specify Field Order for Export dialog box.
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.”
External function’s name
and parameter Description of external function