User manual
Table Of Contents
- Contents
- Welcome to Bento
- Overview of Bento
- Using Libraries
- Using the Address Book and iCal Libraries
- Using Collections
- Using Form View
- About Forms
- Viewing a Form and a Table at the Same Time
- Creating Records in Form View
- Editing Records in Form View
- Duplicating Records in Form View
- Deleting Records in Form View
- Creating Forms
- Deleting Forms
- Duplicating Forms
- Renaming Forms
- Adding Fields to a Form
- Tabbing Between Fields
- Moving Fields and Objects on Forms
- Resizing Fields and Objects
- Removing Fields from a Form
- Customizing Form Layouts
- Using Table View
- Using Fields
- Importing, Exporting, and Printing
- Backing Up and Restoring Information
- Using Bento with Bento for iPhone and iPod touch
- Keyboard Shortcuts
- Index
68 Chapter 6 Using Table View
Depending on the field type, the following functions are available.
You can use the Count function on any type of field. You can use the Sum, Average,
Maximum, and Minimum functions on fields of the following types: Number,
Currency, Duration, Rating, Automatic Counter, and Calculation (when the result is
number, currency, or duration). You can also use the Minimum and Maximum
functions on Date and Time fields.
To calculate a summary for a column:
Click in the summary row of the selected column, then choose a function from the
pop-up menu. The name of the function and the results are displayed in the summary
row.
When you do a search or an Advanced Find, the summary is recalculated based on
the records that are found.
Name Purpose
Sum Calculates the total of the values in the selected field
Count Reports the number of items that have an entry in the selected field
Average Reports the average of the values in the selected field
Maximum Reports the highest value of the values in the selected field
Minimum Reports the lowest value of the values in the selected field
Choose Sum in the summary row to
calculate the total of the amounts
listed in the Budget column.