Creating a summary table from multiple tables means you're cross-referencing those tables and duplicating or using formulas to generate the results. It's simple and easy as long as your know which table you're referencing from.
To start, navigate your cursor to the left tab and use your desired tables. For items with fixed number of rows, use a Prefilled table. However, usually, for daily reports we use Default tables. And for our summary table, we'll be using a Prefilled table.
For example:
Table 1: Materials (Default table)
Supplier | Quantity | Unit Cost ($) | Total ($) |
(Drop down list) | (Number field) |
| ~cell D1+ |
Table 2: Labour (Default table)
Name | Start | Finish | Tota Hours |
|
|
| ~cell D1+ |
Table 3: Equipment (Default table)
Equipment # | Start | Finish | Total Equipment Hours |
|
|
| ~cell D1+ |
Table 4: Daily Totals (Prefilled table)
Material Cost ($) | Labour (hours) | Equipment (hours) |
(Formula field referencing Table 1) | (Formula field referencing Table 2) | (Formula field referencing Table 3) |
Material Cost ($):
=SUM(Table1!D:D)
Labour (hours):
=SUM(Table2!D:D)
Equipment (hours):
=SUM(Table3!D:D)