Documentation and SupportV6 User Manual TablesHow do I create a Standard table?

How do I create a Standard table?

Navigate to the Table(s) Tools.

2. Or click on the Add New Table in the navigation.

Click the 'Add New' bubble.

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 - Wether 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 Field - This allows you to index one of the system fields for quicker loads.
  10. Onload JS/HTML - Allows Javascript or HTML code to be loaded once when the table is opened.
Table Info

4. Click Standard from the datasets.

Select Standard from the type drop down.

5. Click the 'Click to add a field' to start adding fields.

Click the 'Add New' bubble to add a field.

6. Click the arrow to expand the field info.

Expand

7. Select your field type.

Select your field type.

7.1. Selecting the Text Field type.

  1. Name of the Field (Max length is 63 characters and can not include a back tick [ ` ])
  2. Select Text from the type drop down.
  3. Select your formatting type: Non Formatted, URL,Short URL, Account #, Phone Number, International Phone Number, Zip, Postal Code, State, or Image.
  4. Set your field length.
  5. Select if this is a custom SQL field
  6. Enter a default value if there is a value that would be entered the majority of the time, you can leave this blank
  7. Select if this should be a field that is indexed, which allows quicker look up for reporting
  8. Select if this field will be disabled on export
Selecting the Text Field type.

7.2. Selecting the Long Text Field type.

  1. Name of the Field (Max length is 63 characters and can not include a back tick [ ` ])
  2. Select Long Text from the type drop down.
  3. Select if this is a custom SQL field
  4. Enter a default value if there is a value that would be entered the majority of the time, you can leave this blank
  5. Select if this field will be disabled on export
Selecting the Long Text Field type.

7.3. Selecting the Number Field type.

  1. Name of the Field (Max length is 63 characters and can not include a back tick [ ` ])
  2. Select Number from the type drop down.
  3. Select your formatting type: Non Formatted, Formatted, Currency, Percent, or Scientific Notation.
  4. Set your field length, setting how many digits after the decimal place.
  5. Select if this is a custom SQL field
  6. Enter a default value if there is a value that would be entered the majority of the time, you can leave this blank
  7. Select if this should be a field that is indexed, which allows quicker look up for reporting.
  8. Select if this field will be disabled on export
Selecting the Number Field type.

7.4. Selecting the Date Field type.

  1. Name of the Field (Max length is 63 characters and can not include a back tick [ ` ]).
  2. Select Date from the type drop down.
  3. Select your formatting type: Date, Date/Time, or Time.
  4. Select your date value from the drop down. User Defined, Insert Date, or Update Date.
  5. Select if this is a custom SQL field.
  6. Enter a default value if there is a value that would be entered the majority of the time, you can leave this blank.
  7. Select if this should be a field that is indexed, which allows quicker look up for reporting.
  8. Select if this field will be disabled on export.
Selecting the Date Field type.

7.5. Selecting the List Field type.

  1. Name of the Field (Max length is 63 characters and can not include a back tick [ ` ]).
  2. Select List from the type drop down.
  3. Select your formatting type: Combo Box, Combo Box Auto Update, Drop Down, or Multiple Drop Down.
  4. Set your field length.
  5. Select if this filed will be linked to another List field.
  6. Select how you would like the Values to be entered: User Entered or From Table.
  7. Place in your values you wish to use in your drop down.
  8. Enter a default value if there is a value that would be entered the majority of the time, you can leave this blank.
  9. Select if this should be a field that is indexed, which allows quicker look up for reporting.
  10. Select if this field will be disabled on export.

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.
Selecting the Drop Down Field type.

7.6. Selecting the File Field type.

  1. Name of the Field (Max length is 63 characters and can not include a back tick [ ` ]).
  2. Select File from the type drop down.
  3. Select if this field will be disabled on export.
Selecting the File Field type.

7.7. Selecting the HTML Field type.

  1. Name of the Field (Max length is 63 characters and can not include a back tick [ ` ]).
  2. Select HTML from the type drop down.
  3. Select if this is a custom SQL field.
  4. Enter a default value if there is a value that would be entered the majority of the time, you can leave this blank.
  5. Select if this field will be disabled on export.
Selecting the HTML Field type.

8. Continue adding your fields, once complete Click Save.

Continue adding your fields, once complete select Next.

9. Congratulations, your table is created and you are now ready to enter data.