Table Schema

One of the more important components you will encounter while adding a datatable or calendar is the notion of its table schema. The table schema allows you to specify what sort of data will be entered in your various input fields and how it will be stored. Below is an example of the table schema for a contact form:

This creates a data table schema that can now store data. In the example above, we created a table schema for a contact form. Once added to a web page, it will appear as it does below.

Creating a Form Using Table Schema

Although you can create datatable schemas in calendars and datatables, the process is the same within both module types. In the case of this example, we will stick with our contact form from above and re-create it using the Table Schema in a datatable.

Step 1 - Click Add->Datatable

Step 2 - Name your datatable, choose "web" as datatable type

Step 3 - Click on the Table Schema panel

Step 4 - Click the green + button to being adding form fields to your datatable schema

As you can see, we added all of the same fields from the contact form shown at the top of the article. Now, it's time to add your datatable to a web page so you can start collecting data.

For each field, you can specify its type, length, whether it's null, and any default values. A description for each value is below:

Table Schema Field Description
Name The unique ID for a given field
Type The type of data that will be entered in the field
Length Amount of characters allowed in the database field
Null Allows empty values if checked
Default Default value entered with the field.

Data Types

A description of each "type" is below:

Type Description
Character Brief textual data
Large Text Multi-line or extended textual data
Blob A binary large object 
File A file which will be uploaded
Date Field A specific date value
TimeStamp A value for a specific time
Integer A whole number
Numeric Allows any type of number 
Serial Field mySQL data type

Step 1 - Navigate to the page where you'd like to add your datatable form

Step 2 - Click on the drop zone where you'd like to place your datatable form until it turns blue

Step 3 - Select the datatable you created and your form will populate on the page as shown below

Publish your page and it will appear as it does in the screenshot below! Now your datatable form is ready to start collecting data.

As site visitors fill out your form on your website their data will populate inside of the datatable you created as shown below.


Please sign in to leave a comment.
Have more questions? Submit a request