DocumentationUser Use & Create TablesHow do I create a Vertical Mashup Table?

How do I create a Vertical Mashup Table?

Add a Table:

There are a couple ways to Add a Table:

Option 1: From the Home dashboard, click the Add button (below the Tables summary).

Navigate to the Table(s) Tools.

Option 2: From the Navigation menu, click the Tables option.

TMMData - my.tmmlog.in - Google Chrome

Click the Add New Table.

TMMData - my.tmmlog.in - Google Chrome

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

1. Click Mashup from the datasets.

- patch.tmmlog.in - Google Chrome

2. Select the Type of Join.

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

- patch.tmmlog.in - Google Chrome
TMMData - my.tmmlog.in - Google Chrome

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

1. Click the Add Field button.

TMMData - my.tmmlog.in - Google Chrome

2. Select a Field that will be on both Tables.  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

Under the Link Type, notice our options:

      1. We can Add Field(s). Repeat until you have included all the Fields you wish to include.

      2. We can also Remove the Field(s).

TMMData - my.tmmlog.in - Google Chrome

Click the large "+" button to add more Tables.

Add Link

6. Click the Save icon.

- patch.tmmlog.in - Google Chrome

Congratulations, the Table has been saved!