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 - my.tmmlog.in - Google Chrome

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

TMMData - my.tmmlog.in - Google Chrome

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

TMMData - my.tmmlog.in - 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 - my.tmmlog.in - 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 - my.tmmlog.in - Google Chrome

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

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

TMMData - my.tmmlog.in - Google Chrome

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

Notice:

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 - my.tmmlog.in - Google Chrome

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

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

TMMData - my.tmmlog.in - Google Chrome

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

TMMData - my.tmmlog.in - Google Chrome

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

Add Link

9. Hit Save.

Save

10. Congratulations, the Table has been saved!