10.9. Sheets

A sheet is a table in which some or all of the data can be edited, similar to a spreadsheet. A panel with a sheet in it allows you to edit the information about multiple records on one page, to simplify entering or editing a group of records.

To edit a set of records, press the "Search" button. A list of all matching records will appear just below the button.

As with any table, you can sort the sheet by any column by clicking on the header label for that column. See the section on tables above for more information on sorting and rearranging columns.

You can directly edit the value of the fields in any column with a header label in a bold font. To edit a value, click on the field, type in the new value (or select it from the drop-down list of choices), and press Enter or Tab. The new value is stored in the database when you press Enter. You can re-sort the table after making changes by clicking on the column header again.

To abort editing a field, press Escape.

To add a new record, push the Add button. This will add a new row to the end of the editing sheet and scroll the sheet to the end. If you have sorted on a column, the new row may be added at the beginning of the sheet rather than the end. In most cases, all fields in the new row will be blank. If there are Search fields in the tab above the Sheet, the selected values in the Search fields will often be set into the newly added row. After you have filled in values for all required fields an ID will be generated and the values in that row will be stored in the database.

Until you fill in all required fields in a new row, the record is not permanent; if you push the Search button again, the unstored row will be lost. Clicking on any column header will sort all rows, including the new rows, even when they are not yet stored. You can easily find new rows by looking for rows with no ID value.

Not all data for a record is necessarily displayed in the Sheet. To edit the remaining fields in the record, you must use the Edit tab for that record. To edit a record, click on that row in the Sheet, the push the Edit button. This will switch to the Edit tabe for the selected row. In that tab, you can edit any field for that record, or delete the record. To get back to the editing Sheet, select the Sheet tab again.

10.9.1. Function Keys

You can use some of the function keys on your keyboard to help fill in data values in the sheet more quickly. To use one of these function keys, select the cell to be filled, but do not edit it. If clicking on the cell puts it into edit mode, press Escape to exit edit mode.

  • F3 - copy the data from the cell above into this cell and move to the next cell to the right. By pressing F3 repeatedly, you can easily copy all fields of the row above into the current row.

  • F4 - copy the data from the cell above into this cell and move to the next cell below. By pressing F4 repeatedly, you can easily fill a column with one value.

  • F6 - take the data from the cell above into this cell, increment it, enter the incremented value into this cell, and move to the next cell below. The increment value is normally 1. An editing sheet tab may include a box allowing you to specify the increment amount, such as the Schedule tab. By pressing F6 repeatedly, you can easily fill a column with a set of unique numbers. If the cell above contains a string value, this function key behaves identically to F4.