All the information described already in this chapter has dealt with a single table however it is possible for the Extension to work with more than one table on the same workbook and this opens up lots of powerful options.
Before going into all the details of this feature it is important to note that a data table can contain data from any grid in OpenGround Cloud together with its parent information. So to include SPT data and Location data on the same sheet only requires one table in the Extension.
Adding Tables
To add an additional table to the template worksheet select the cell you wish to add the table to and click the Add icon on the Tables section of the Ribbon. Fields can then be added to this table in the same way as described in Selecting Data.
It is important to note the following:
When adding headers to this new table you must have the table selected in the drop-down list as shown below.
Tables do not need to start on the same row but it is advised that you do start them on the same row.
Tables cannot overlap. So the left hand column of one table will become the boundary for the end of the table to the left of it.
Removing Tables
To remove a table from the template worksheet select the table from the table's drop-down and click the Delete button on the Tables section of the Ribbon.
Locating Tables
When you are working with many tables within a worksheet it can get confusing as to where each table starts. To locate the top left cell of any table select the table from the table's drop-down list and click the Locate Icon on the Tables section of the Ribbon.
Grouping and Filtering Multiple Tables
Care must be taken when defining filter conditions and grouping for worksheets with multiple tables on them as grouping and filtering work mainly independently on each table.
When you have filter conditions set for more than one table you will see on the left hand side of the filter for the table that you are currently filtering for is highlighted in bold. In the example below we are currently selecting the locations for the Moisture Content table and the next filter step (listed below) will be to select locations for the SPT test.
There is no current way to take the filter condition defined in one table and automatically apply it to the other tables, so if you want a filter defined for the same parameter on each table you will need to set up multiple filters, one for each table.
If you group from multiple tables using the same field then the data will appear on the same worksheet as shown below. If there are groups that do not have data for some tables it will simply leave that table blank on the worksheet.