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. Examples of characters include:
- a
- ^
- !
Example of a text format in a form:
Example of a result in a report:
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:
Example of a result in a report:
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:
Example of a result in a report:
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:
Example of a result in a report:
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:
Example of a result in a report:
6. Email
Description: The column must contain a correctly formatted email address.
Example of a text format in a form:
Example of a result in a report:
7. Url
Description: Column must contain a correctly formatted URL.
Example of a text format in a form:
Example of a result in a report:
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:
Example of a result in a report:
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:
Example of a result in a report:
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:
Example of a result in a report:
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:
Example of a result in a report:
For additional assistance, please email helpdesk@IntelliBoard.net