Administrator’s Guide

Publishing your database on the Web 3-17
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.
5. To export one record that subtotals multiple records, click
Summarize by. Then, in the Summarize by dialog box, click to the left
of the field you want to use as the break field. A check mark appears
to the left of the field. (You must have set up one or more summary
fields and sorted by the break field in the database.) Click OK.
In the Export Field Order for Export dialog box, FileMaker Pro
creates italicized temporary export fields in the Field Order list based
on the break fields you specified. For example, if you have a
summary field named Count and you select the break fields Category
and Unit, the export field list contains Count, Count by Category,
and Count by Unit.
6. Select Don't format output if you want to ignore number, date, and
time field formatting (for example, to export a number as 3.7 instead
of as $3.70).
7. Select Format output using current layout if you want to use number,
date, and time field formatting as specified for the included fields on
the current layout (for example, to export a number as $3.70 instead
of as 3.7). Symbols and other non-numeric values are exported as
text.
8. Click Export.