Column Data Types of InForm

Every data type in InForm has own format of text entered there and the end result. This article contains a list of all possible formats, their descriptions, and examples.

1. Text

Description: The column accepts any free text entry.

Example of a text format in a form: 

mceclip0.png

Example of a result in a report:

mceclip12.png

2. Number

Description: Column accepts a value that will be displayed as a number (with a dot if you need to define a decimal part, e.g., 123.5).

Example of a text format in a form: 

mceclip1.png

Example of a result in a report:

mceclip13.png

3. Date

Description: Column contains the value as a date (accepts only 1 date, not the date range).

Example of a text format in a form: 

mceclip2.png

Example of a result in a report:

mceclip14.png

4. Enum (enumerated)

Description: The column will contain a drop-down list with values. The list is controlled on the editing action after you add such field to the table (see Table Columns section HERE).

Enter the option name and click the “+” icon to add options to the enumerated list. Clicking the “X” icon for the already added option will remove that from the list. All entered options will be shown in the drop-down list in the form.
NOTE: If the field is NOT required on the form, the drop-down will contain “None” as the first option.

NOTE: These values are stored in the database as numbers.

Example of a text format in a form: 

mceclip3.png

Example of a result in a report:

mceclip15.png

5. Media Link

Description: The column will be a link to a file that will be displayed as media, e.g. an avatar picture or logo.

Example of a text format in a form: 

mceclip4.png

Example of a result in a report:

mceclip16.png

6. Email

Description: The column must contain a correctly formatted email address.

Example of a text format in a form: 

mceclip5.png

Example of a result in a report:

mceclip17.png

7. Url

Description: Column must contain a correctly formatted URL.

Example of a text format in a form: 

mceclip6.png

Example of a result in a report:

mceclip18.png

8. Location

Description: The value is a pair of numbers indicating longitude and latitude. You may also click an aim icon to put your location.

Example of a text format in a form: 

mceclip7.png

Example of a result in a report:

mceclip19.png

9. Ip

Description: The value is 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.

Example of a text format in a form: 

mceclip8.png

Example of a result in a report:

mceclip20.png

10. Integer

Description: The value must be an integer (not a decimal number).

! Important ! - Use this type to hold ID values used to link records to another table.

Example of a text format in a form: 

mceclip10.png

Example of a result in a report:

mceclip21.png

11. Boolean

Description: The value must be TRUE or FALSE. This will become a checkbox on a form.

Example of a text format in a form: 

mceclip11.png

Example of a result in a report:

mceclip23.png

 

For additional assistance, please email helpdesk@IntelliBoard.net

Was this article helpful?
0 out of 0 found this helpful