How do I create a Standard 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).

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

Click the Add New Table.

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

2. Add Fields.

3. Select more options (if wanted) by expanding the Field info.

4. Select a Field Type.

- Name of the Field (Max length is 63 characters and can not include a back tick [ ` ]).
- Select Text from the type drop-down.
- Select your Formatting Type: Non Formatted, URL,Short URL, Account #, Phone Number, International Phone Number, Zip, Postal Code, State, or Image.
- Set your Field Length.
- Select if this is a Custom SQL Field.
- Enter a Default Value, if there is a Value that would be entered the majority of the time (you can leave this blank).
- Select if this should be a Field that is Indexed, which allows quicker look up for reporting.
- Select if the Field is required.
- Select if the Field should be readonly.
- Select if the Field should be hidden from the Prep Tool.
- Select if this Field will be Disabled on Export.

- Select Number from the Type drop-down.
- The Long Text Field Type is used for "text only" applications (for up to 65,000 characters of storage).
- Select Number from the Type drop-down.
- Select your Formatting Type: Non Formatted, Formatted, Currency, Percent, or Scientific Notation.
- Select Date from the Type drop-down.
- Select a Formatting Type: Date, Date/Time, or Time.
- Select a Date Value from the drop-down. User Defined, Insert Date, or Update Date.
- Select List from the Type drop-down.
- Select your Formatting Type: Combo Box, Combo Box Auto Update, Drop Down, or Multiple Drop Down.
- Select if this Field will be linked to another List Field.
- Select how you would like the Values to be entered: User Entered or From Table.
- Place in the specific Values you wish to use in your drop-down (the Values need entered in with ONE per line).
Note:
- Combo Box - Allows you to pick from a predefined list. You can start to type in the box and it filters the values down.
- Combo Box Auto Update - Allows you to pick from a predefined list, or add a new value to that list.
- Drop Down - Allows you to pick from a predefined list. Can also be a linked drop-down.
- Multiple Drop Down - Allows you to select multiple options. Can also be a linked drop-down.
- Checkbox - Allows for simply On/Off checkbox function. Can NOT be a linked drop-down.
- Radio - Allows for a list of Radio Buttons assigned to values. Can also be linked to a drop-down.
Select File from the Type drop-down.
Select HTML from the Type drop-down.
- Select ID from the Type drop-down menu.
- Select a Format from the drop-down menu (Numeric ID, Alphanumeric, Custom).
NOTE: this Field is used to create Unique Identifiers (custom or auto-generated) for use in indexing, joining, or simply assuring unique records.
- Select Sparkline from the Type drop-down menu.
- Select your Formatting Type: Line, Spline, Area, Area Spline, Column.
5. Continue adding more Fields.
6. Once completed, click the Save icon.
