Create an InForm Table

The first step in using InForm. Learn how to create a new table in the database and make relations to existing LMS tables. You can create a table manually, or by importing from a file.

To create an InForm table manually:

Navigate to InForm in your IntelliBoard Pro account. It is the 1st option in the “Apps” tab drop down menu.
Click the “Add Table” button in the top right corner.
Fill out the form. (Details below)
Click “Save” button to save table.

Direct link to “Add InForm Table” here.

Add InForm Table Form

Table Title: Name the table you are creating.
Entries Managing Mode: Choose who will be able to edit table data
- Primary Account Holder and IB Users can edit table: Administrator and all IntelliBoard users will be able to edit any table record from their accounts.
- IB Users Can Manage Their Entries: Only the administrator or the IntelliBoard user who added a table record will be able to edit from their account.
- Nobody Can Manage an Entry: Nobody (administrator or any IntelliBoard user) will be able to edit any table record. This is useful for permanent logs that shouldn't be edited or deleted.
Name Column: Only relevant to those writing their own SQL. Leave this field empty.
Table Columns: Add columns by entering the column name and selecting the column types. Save after each column to add.
Column Name: Name the column for easy identification
Column Type: The type of date this column holds
- Text: Uses text to provide data. For example, an Instrument Column would have instrument name typed in the text field.
- Number: Display values as a number and can use decimals.
- Date: Allows for the input of a date in Day/Month/Year format
- Enum (enumerated): Will contain a drop-down list of options. After adding this column type, go to Setting Icon to add the options.
- Media Link: A link to a file that will be displayed as media. For example, an avatar or logo.
- Email: This field must contain correctly formatted email address.
- URL: This field must contain a correctly formatted URL.
- Location: This field is a pair of numbers indicating longitude and latitude. You may also click an aim icon to put your location.
- IP: Must be a correctly formatted IP address. It must be in the form of A.B.C.D, where A, B, C, and D are numbers from 0-255, e.g., 255.255.255.255
- Integer: Displays value as number. Must be an integer and cannot contain decimals. Use this type to hold ID values used to link records to another table.
- Boolean: True or False. This will become a checkbox on a form.
Save: Save after each column addition. They will appear above in the “No Columns” section. You can edit, adjust settings such as adding Enum options, or delete columns there.
Table Relations: Add relations between your table and your LMS. You can’t connect previously created InForm table(s) between each other.
Relation Connection Type: There are 2 types of relations that can be added. This connection matches data from this InForm Table to data in the LMS. Until you add data relations, the table is simply data and not integrated to connect with LMS data.
- Belongs To: This option is used for a Many-to-One relationship between some columns from your table and some columns from any LMS table. Each entry in your table can only be attached to one record in the LMS table. This will also allow you to add records to the table one-by-one. This relation connection is recommended for most uses.
- Many-to-Many: This option is used for a Many-to-Many relation between records from your table and records from any LMS or previously created InForm table. This will also allow you to add one record to the table assigned to multiple records in another table.
Foreign Key: A column in the table whose value corresponds to the value of the primary key (unique identifier) in another table. So, it’s a column in your table you’ve created that will contain values matched with values from “Column” setting below. The column selected here must have one of the following types: text, number, int. Only applies to “Belongs To” relation types.
Table: The Table you want to make a relation with.
Column: A special unique identifier (primary key) where IntelliBoard will search matches with your foreign key. Only applies to “Belongs To” relation types. This is the column in the table you made a relation to in the previous step that matches the information in the “Foreign Key” column. Most relations are made using User ID or Course ID.
Display Element: The column that will be displayed in a menu in InForm to pick the record associated with this InForm table entry.
Add: Click the “Add” button to add a relation. You may add additional relations if applicable. You must add the relation before saving. It will populate under “Table Relations.”
Save: Click the “Save” button to save your changes on this form. Click the “Cancel” button to abort the process. Your information will not be saved if you cancel.

Navigate to InForm in your IntelliBoard Pro account. It is the 1st option in the “Apps” tab drop down menu.
Click the “Import Form” button in the top right corner.
You will now see your Import History. Click the “Import Form” button in the top right corner.
Fill out form. (Details below.)
Click “Next” button to save table. If it is an XLXS file, you will be asked which sheet you wish to import. Select your sheet and “Save”
Select the data type for each column in your table. It automatically sets all columns to “Text.” Use the drop menu for each column to change. Available data types: Text, Number, Date, Enum, Media Link, Email, URL, Location, IP, Integer, Boolean.
Assign relations. Find your newly created table in InForm (you can go back to the “Apps” tab and select InForm to quickly find your form history.)
Click the three dots under the actions column next to your newly created table and select “Edit.”
Scroll down to the table relations block and assign relations as needed. (Details below.)

Direct Link to “Import to InForm” here.

Import to Inform Form

InForm Table: Leave at “New Table” for a new table import. From here you could also import the data to some already existing table by selecting one from the list. In this case, the number of columns in the file and their names must be the same as in the initial table. For example, you have a table with 2 columns– Student ID, and Pet - and you want to import new records to this table. In this case, you should prepare a file that will also contain 2 columns with the same names.
Table Title: Give your new table a title. If you are importing an existing table instead of a new table, this box will not appear.
Import Type: Select between “File” and “SFTP.” If you choose SFTP, you’ll be asked to choose the SFTP connected and path to the file.
File: Select the file you wish to upload.
Next: If it is an XLXS file, you will be asked which sheet you wish to import. You can only upload one sheet at a time. Select your sheet and “Save.”

Table Relations Form

Table Relations: Add relations between your table and your LMS. You can’t connect previously created InForm table(s) between each other.
Relation Connection Type: There are 2 types of relations that can be added. This connection matches data from this InForm Table to data in the LMS. Until you add data relations, the table is simply data and not integrated to connect with LMS data.
- Belongs To: This option is used for a Many-to-One relationship between some columns from your table and some columns from any LMS table. Each entry in your table can only be attached to one record in the LMS table. This will also allow you to add records to the table one-by-one. This relation connection is recommended for most uses.
- Many-to-Many: This option is used for a Many-to-Many relation between records from your table and records from any LMS or previously created InForm table. This will also allow you to add one record to the table assigned to multiple records in another table.
Foreign Key: A column in the table whose value corresponds to the value of the primary key (unique identifier) in another table. So, it’s a column in your table you’ve created that will contain values matched with values from “Column” setting below. The column selected here must have one of the following types: text, number, int. Only applies to “Belongs To” relation types.
Table: The Table you want to make a relation with.
Column: A special unique identifier (primary key) where IntelliBoard will search matches with your foreign key. Only applies to “Belongs To” relation types. This is the column in the table you made a relation to in the previous step that matches the information in the “Foreign Key” column. Most relations are made using User ID or Course ID.
Display Element: The column that will be displayed in a menu in InForm to pick the record associated with this InForm table entry.
Add: Click the “Add” button to add a relation. You may add additional relations if applicable. You must add the relation before saving. It will populate under “Table Relations.”
Save: Click the “Save” button to save your changes on this form. Click the “Cancel” button to abort the process. Your information will not be saved if you cancel.

Knowledge Base

Create an InForm Table

Add InForm Table Form

Import to Inform Form

Table Relations Form

Related Videos: