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

How do I create a Custom SQL Table? (Version 1.1)

Navigate to the Table(s) Tools.

2. Or 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...

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 Custom SQL from the datasets.

5. Add Your SQL...

Notice the options:

1. The SQL entry box...

2. Show Table List...

3. Run SQL...

4. Preview

6. Then click Save.

TMMData - - Google Chrome

7. Congratulations, your Table is created.