Foundation Documentation and Support

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

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.

1. Text 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.

2. Long Text Field Type.

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).

3. Number Field Type.

Select Number from the Type drop-down.
Select your Formatting Type: Non Formatted, Formatted, Currency, Percent, or Scientific Notation.

4. Date Field Type.

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.

5. List Field Type.

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.

6. File Field Type.

Select File from the Type drop-down.

7. HTML Field Type.

Select HTML from the Type drop-down.

8. ID Field Type.

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.

9. Sparkline Field Type.