DocumentationUser Use & Create TablesHow do I create a Custom SQL Table?

How do I create a Custom SQL 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 Custom SQL from the datasets.

- patch.tmmlog.in - Google Chrome

2. Add Your SQL.

Notice the options:

1. The SQL entry box.

2. Show Table List.

3. Run SQL.

4. Preview.

TMMData - my.tmmlog.in - Google Chrome

3. Click the Save icon.

- patch.tmmlog.in - Google Chrome

Congratulations, your Table is created.