Tables are a little more complex than other PerfectForms™ objects because a Table object itself can contain other form objects. For most table calculations, you work in the same way as you would for ordinary form fields. However, sometimes you need to operate across all rows of the table, for example when summing rows to a total field.

Current Row and All Rows

When you are getting data from or writing results to fields that involve table fields, you will be presented with a dialog like the one below. You will notice that for each table column, there are two options - Current Row and All Rows.

Example: Calculate the total of a table column whenever data in the table is changed.

Use the Sum function to accomplish this. Let's assume you have a number field underneath a table column (numeric) of a table object. Drag in a Set Field command and then in the Properties bar set the Field to be the number field. In the Value field, select Formula and then click Compose.

1. With a form loaded in the Form Designer, click to enter the Behavior view. 2. Drag in a Set Field command and then in the Properties bar set the Field to be the number field. In the Value field, select Formula and then click Compose. 3. Click Add Function and select Sum in the Function list. 4. Click in the <empty> field within the Sum function and then locate the table object. Within that object, all table columns are listed. For each column there are two entries: Current Row and All Rows. Select All Rows to sum all rows in the table. When completed, it will look like this:

Updated: 06/12/2011  Page url: http://www.perfectforms.com/Documentation/manual/html/?working_with_tables.htm
PerfectForms™ -- forms software, workflow software, and business process management