Displays data in the specified format.
Viewing records as a form, list, or table
•View as Form displays records page by page in the format determined by the database designer.
•View as List displays records as records in a list, so they can be browsed without clicking the backward and forward buttons in the status toolbar.
•View as Table displays the records on screen in a grid, so that many fields and records may be viewed at one time in a format similar to a spreadsheet.
•Cycle switches from the current view to the next view.
Product | Supported |
FileMaker Pro Advanced | Yes |
FileMaker Go | Yes |
FileMaker WebDirect | Partial |
FileMaker Server | Yes |
FileMaker Cloud | Yes |
FileMaker Data API | Yes |
Custom Web Publishing | Yes |
Runtime solution | Yes |
FileMaker Pro 6.0 or earlier
•FileMaker WebDirect does not support the View as Table option.
Imports records, sorts, and switches to Table View.
Import Records [With dialog: On]
Sort Records [Restore; With dialog: Off]
View As [View as Table]Performs a find, then changes view depending on the number of records in the found set.
Enter Find Mode [Pause: On]
If [Get (FoundCount) = 1]
View As [View as Form]
Else If [Get ( FoundCount ) > 1]
View As [View as List]
End If