Control Types / Data Types

If you want to save data from input elements, you must link the respective element to a data field. Intrexx handles this automatically when creating elements, with just a few exceptions. It is also possible to link an element to a data field at a later time. You can find all the information here.

In the figure above, you can see the data fields of the database (e.g., PostgreSQL) in a query. You can specify the database type when creating a portal. You can learn more about this here.

Data Types

The Intrexx data types correspond to the database data types. Intrexx supports a wide variety of databases and, when linking application elements to data fields, automatically determines which Intrexx data type corresponds to which database data type. You don't need to deal with the data fields in the portal database, since all management tasks—creating, modifying, or deleting data fields—can be performed directly from within Intrexx.

For example, if Intrexx automatically creates a "Title" data field when you create an input field and links it to that input field, you will see in the input field's properties dialog that the "string" data type is used for it. Here is a list of the data types used in Intrexx:

  • String (Short Text)

  • Text (Long Text)

  • Integers (Whole Numbers)

  • Double (Decimal Numbers)

  • Datetime (Date and Time)

  • Boolean (Boolean Values)

  • File (References to Files)

Types of Controls

Depending on the data type, different control types can be selected for displaying the data in the linked element.

Control Types for String Data Fields

  • Text

    Formats the content according to the settings you specify in the options.

  • Email

    Can be used with data fields that contain email addresses. The content is formatted as a link. Clicking the link opens your default email client and automatically enters the email address as the recipient.

  • URL

    Can be used with data fields that contain URLs. The content is formatted as a link. Clicking the link will open your default browser and automatically load the corresponding page.

  • Phone

    The content is formatted as a link that can be used to send a text message or initiate a phone call with automatic dialing. The relevant settings can be configured in the options.

  • Web Application

    The content is implemented as a link in web applications. In the options for this type, parameters such as the departure point and destination can be specified.

  • Image URL

    Displays the image linked to by the URL according to the settings in the options.

  • Color

    The area of the viewport is filled with the color stored in the linked data field.

  • Video

    This control type allows you to embed videos from YouTube, Vimeo, and myVideo using their URLs, as well as any video file formats, images, and standard URLs. Supported video formats: swf, mp4, ogg, ogv, oga, ogx, webm, mkv, mov. For images: jpg, jpeg, png, gif, bmp.

Validation Types for Integer Data Fields

  • Integer

    The number will be formatted according to the settings you specify in the options.

  • User Information

    Can be used with data fields that contain user IDs. The view pane displays additional information about the user based on the settings in the Options.

  • Tree Trail

    Resolves the integer stored in the data field and displays the corresponding path—known as the breadcrumb trail—in the linked tree element, pointing to the folder with the stored ID.

Control Types for Double Data Fields

  • floating-point number

    The number will be formatted according to the settings you specify in the options.

  • Currency

    The number will be formatted according to the settings you specify in the options.

Control Types for Datetime Data Fields

  • Date

    The date will be formatted according to the settings you specify in the options.

  • Time

    The time is formatted according to the settings you specify in the options.

  • Date & Time

    The date and time are formatted according to the settings you specify in the options.

For information on control types that can only be used in view tables, click here.

Validation Types for Text Data Fields

In view tables, you can select the "Content View" control type. This ensures that content entered as Markdown is interpreted correctly.

Starting with Intrexx version 12.1.0:

"Checkbox" control type

Starting with Intrexx version 12.1.0, string and integer data fields can also be used for the "Checkbox" control type. You can find all the information here.