Control types / Data types

If the data of input elements is to be saved, the respective element must be linked to a data field. Intrexx does this automatically, except for a few details, when creating elements. An element can also be connected to a data field retroactively. You can find all the information here.

At the top of the figure, you can see the data fields of the database (e.g. PostgreSQL) in a query. You can specify the database type when you create a portal. You can find out more here.

Data types

The Intrexx data types correspond to the data types in the database. Intrexx supports a variety of databases and, when connecting application elements with data fields, automatically recognizes which Intrexx data type corresponds to which data type in the database. You do not have to deal with the data fields of the portal database, since the entire administration - creating, changing, or deleting data fields - can be done directly in Intrexx.

If, for example, a data field "Title" is automatically created by Intrexx when an input field is created and linked to the input field, you will see in the properties dialog of the input field that the data type "string" is used for this. Here is a list of the data types used in Intrexx:

  • String (short text)

  • Text (Long text)

  • Integer (integers)

  • Double (decimal numbers)

  • Datetime (date and time)

  • Boolean (boolean values)

  • File (referral to files)

Control types

Different control types can be selected for the representation of the data in the linked element, depending on the data type.

Control types for string data fields

  • Text

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

  • Email

    Can be used for data fields that contain email addresses. The content is formatted as a link. Clicking on the link opens the standard mail client and automatically adds the email address as the recipient's address.

  • URL

    Can be used for data fields that contain a URL. The content is formatted as a link. Clicking on the link opens the default browser and automatically loads the corresponding page.

  • Phone

    The content is formatted as a link that can be used to send an SMS or set up a telephone connection with automatic number dialling. The corresponding settings can be made in the options.

  • Web application

    The content is transformed into a link to web applications. Parameters such as departure and destination can be transferred in the options for this type.

  • Image URL

    Displays the image to which the URL points according to the settings in the options.

  • Color

    The area of the view field is filled with the color that is saved in the linked data field.

  • Video

    This control types enables you to embed videos from the portals YouTube, ""Vimeo"" and ""myVideo"" based on the URL, as well as a range of video file formats, images and typical URLs. Supported formats for videos: swf, mp4, ogg, ogv, oga, ogx, webm, mkv, mov. For images: jpg, jpeg, png, gif, bmp.

Control types for integer data fields

  • Integer

    The number is formatted according to the settings you make in the options.

  • User information

    Can be used with data fields that contain the user ID. The view field displays further information about the user according to the settings in the options.

  • Tree path

    Resolves the integer stored in the data field and instead shows the corresponding path - the so-called breadcrumb trail - in the connected tree element to the folder with the stored ID.

Control types for double data fields

  • Floating point number

    The number is formatted according to the settings you make in the options.

  • Currency

    The number is formatted according to the settings you make in the options.

Control types for datetime data fields

  • Date

    The date is formatted according to the settings you make in the options.

  • Time

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

  • Date & time

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

Information on control types that can only be used in view tables can be found here.