Creating summary fields

Quick Base automatically totals data in your table when you use a summary or chart report. But if you want Quick Base to total orders based on specific criteria within a table, or you want to do any math on these totals (such as, you want to calculate what percent each sales representative has brought in over the last 30 days), you'll need the assistance of another table and summary fields. Any time you want to collect data from multiple records and perform calculations on those values, you'll need to use this kind of field.

A summary field is part of a table-to-table relationship. Summary fields are stored in the parent table of a relationship, and summarize fields from related records in the child table. For example, you may have a Sales Orders table that is related to another table called Sales Team listing your sales people. In this relationship, the Sales Team table is the parent table, meaning one salesperson can have many orders. If you wanted to determine how many sales each salesperson closed or the total revenue each sales rep brought in, you add a summary field to the Sales Team table. Within each salesperson's record, the summary field then calculates the total number of orders (from the Sales Orders table) related to the record.

Summary fields do more than just add. You can also use a summary field to calculate other amounts. For example, a summary field could contain an average value. Or, you can use a summary field to calculate a minimum or maximum number, or even calculate dates.

Another benefit of summary fields is that the data from these fields can be exported and used in formulas. You also can pass the value of summary fields down to the child table using a lookup field if you want to use summaries in child table formulas or reports, or export data from the child table.

To create a summary field, you must have an existing relationship, or create a relationship between two tables.

To create a summary field:
  1. Open the app that contains the relationship you want to enhance with a summary field.

    If you created a relationship between tables in two different apps (a cross-app relationship), open the application that contains the child table.

  2. Open the table.

  3. Select the relationship that you want to edit. The relationship properties appear:

  4. Under the Parent Table settings on the left side of the screen, click Add Summary Field. A New Summary Field page appears.

  5. Select one of the following types of summary fields:

  6. Under Matching Criteria, select and add fields to set matching criteria. You may want to summarize only specific records in your table.

    Use the Matching Criteria to select the records that you want the summary field to calculate. For example, you may choose to only summarize the tasks that are overdue or only sales figures above a certain amount.

  7. Select Create in the upper right of the page. A Choose name dialog appears.

  8. Type a name for the summary field, then click OK.

Note: When you add a summary field, it doesn't automatically appear on reports or forms. You need to add it yourself by editing reports or customizing forms.

Related Topics:


Go back      |       

© 1999-2018  QuickBase, Inc.  All rights reserved.  Legal Notices.