Help

Adding and viewing data
F
ILEMAKER PRO HELP 63
Working with records
While viewing data in Table View in Browse mode, you can add, duplicate, sort, or delete records.
Display more fields
or hide fields
• Click Modify in the layout bar and use the options in the Modify Table View
dialog box. See
Displaying and hiding fields in Table View.
• Or, right-click a column heading, then choose Field > Hide Field to hide the
selected field. To display a hidden field in Table View, right-click the + column
heading, then choose a field from the list of existing fields.
Delete a field Right-click the column heading, then choose Field > Delete Field. See Deleting
table definitions, field definitions, and data.
Important Before you delete a field, confirm that you don’t need any of the data it
contains.
To Do this
To Do this
Add a new record
In the blank record at the bottom of the table, enter the data. Click in the left
margin at the bottom of the table. A new row is added to the end of the table:
• if the records have not been sorted
or
• if Keep records in sorted order is cleared in the Sort Records dialog box
For sorted data, a new row is added to the last row of the sorted category for the
currently selected row.
When you add a new record, the new record becomes the current row.
Duplicate a record Right-click the left or right margin of the record that you want to duplicate, then
choose Duplicate Record.
Copy the data in a
record
Right-click the left or right margin of the record that you want to copy, then choose
Copy Record. You can paste the copied, tab-separated data into a field or into
Microsoft Excel.
Sort records Right-click the left or right margin, then choose Sort Records. Use the Sort
Records dialog box to specify how to sort records. See
Options for sorting records.
Save data as a
Microsoft Excel file
or Adobe PDF file,
or save the current
found set of
records as a
snapshot link
Right-click the left or right margin, then choose one of the options from the Save/
Send Records As shortcut menu.
See Saving and sending records in other formats.
Send email
messages based
on record data
Right-click the left or right margin of the record, then choose Send Mail. See
Sending email messages based on record data.