Foundation Documentation and SupportV6 User Manual TablesHow do I create a Vertical Mashup Table? (Version 1.1)

How do I create a Vertical Mashup Table? (Version 1.1)

1. Click on the Add Table from the home dashboard...

Navigate to the Table(s) Tools.

2. Open the Navigation menu...

TMMData - - Google Chrome

Locate and select the "Tables" option from the menu...

TMMData - - Google Chrome

Click on the "Add New Table" option in the menu...

TMMData - - Google Chrome

3. Enter Table Information.

  1. Name - What the Table is named.
  2. Description - What the description of the Table will be.
  3. Folder - What folder the Table will be located in.
  4. Status - What is the status of the Table? (Development or Production)
  5. Backup - Do you want the Table to be backed up?
  6. Order By - What Field the Table is ordered by.
  7. Order Direction - Choose if the order is Ascending or Descending.
  8. Primary Date Field - What Field is the primary date Field in relation to the sorting on Dashboards.
  9. System Index Fields - This allows you to index one of the system Fields for quicker loads.
  10. Table Onload Javascript - Allows Javascript or HTML code to be loaded once when the Table is opened.
TMMData - - Google Chrome

4. Click Mashup from the datasets.

5. Select the Type of Join.

For this example we will select 'All Records' under the Vertical options...

All Records
TMMData - - Google Chrome

7. Select which Field(s) you wish to include.

7.1. Click the "Add Field" button...

TMMData - - Google Chrome

If you have a Field that is not in one of the Tables just leave that drop down as Empty


1. the "New Field" under the Link Type

2. the "Empty" Field under the Primary Table

3. and the "Empty" Field under the Linked Table...

TMMData - - Google Chrome

Once we choose a specific Field for the Primary Table...

notice that the Link Type automatically changed to that Field name...

TMMData - - Google Chrome

We will also need to assign the "Empty" Field under the Linked Table...

TMMData - - Google Chrome

Notice that we can (1.) "Add Field(s)" and also (2.) Remove the Field(s)...

Add Link

9. Hit Save.


10. Congratulations, the Table has been saved!