Description
Properties describe the specifications of one object within a data model. For example, if a data model contains information about users of a website, they will probably have such properties as: ‘First name’, ‘Last name’, ‘Email address’, ‘Date of birth’, ‘Profile picture’, etc.
These properties can be stored in a database as different types. These types align with the kind of information properties carry. For example:
‘First name’ = Text (single line) property
‘Date of birth’ = Number property
‘Profile picture’ = Image property
The above-mentioned types of properties have to be filled by the users of your application or be assigned with values in your actions. Depending on your validations, you will be able to save values in the database. Later they can be altered or removed.
To start with, it’s worth mentioning that all of these properties have their default values that are applied to most of them. Let’s quickly go through them in order to avoid repetition further in our text:
Index values: With this setting enabled, the property's value will be indexed in a separate table. This table will be used when the property is included in search operations. Indexing speeds up the search operations but slows down the creation of records.
Database name: The database name determines how the property is called in the Data API.
Name: Choose a name for the property which is used in expressions, endpoints, and Liquid syntax. Must be unique within the model.
Type: Determines what kind of data can be stored in a certain property.
Validations
Is required: Determines if a value is required for a certain property.
Has to be unique: Determines if the value needs to be unique within a particular model.
Auto increment
This property generates automatically incremented values. It could be useful for invoicing or tax returns. The values can be automatically generated when creating a record or by action. Once generated, the value can't be altered/removed.
Format: Set a format used for generated values. Use expression syntax to create complex constructions or easy, straightforward formats. The variable 'var:counter' contains the automatic incrementing value, be sure to use this variable. By default, the format is set to
Sequence identifier: Set the sequence identifier to determine which sequence needs to be used when generating the property's value. If the sequence is based on
Start value: Set a starting value for the auto increment property.
Counter fill character: Set a fill character for the counter value. This setting completes the current counter value's width if it does not yet match the value entered in the Counter width setting. When the sequence starts with the value 1, the Counter width is set to 5 and the fill character is 0, the counter value is 00001. Set the fill character to A and the counter variable will be AAAA1. Should the current counter value be at 935, the counter variable will be AA935.
Counter width: Set the width for the counter variable. | |
In the Advanced section, you will find the ‘Set automatically’ option. With this setting enabled, the auto-incremented value is generated when creating the record. |
Checkbox
This property generates a clickable checkbox, which gives text output true or false.
Default value: With Default checked enabled, the checkbox is checked by default when creating a new record, except when manually unchecked. For more possibilities and versatility, click the Dynamic value button and use expressions instead. |
Date
This property is used to save a date. It has been set to a standard of Day-Month-Year. It contains validators so that you can set date field filling as required or the value to be unique.
Default value: Set to None so that no specific date will be shown by default, it should be typed in manually. By filling in the Static value you will set the initial value, while the Dynamic value uses expression to set the value automatically.
Format: Set a format for the date property's component. All date values will be saved in | |
 | In the Advanced section, you can set the database name and enable an index value that speeds up search operations but slows down the creation of records.
Note: Advanced options above are exactly the same for Date expression, Date time, and Date time expression. |
Date time
This property is used to save a date with a timestamp. It has been set to a standard of Day-Month-Year and Hour-Minute-Second. The property contains validators so that you can set the date and time field filling as required or the value to be unique.
Default value: Set to None so that no specific date will be shown by default, it should be typed in manually. Within a Static value, select a date and time with the date time picker or select one of the presets from the Relative date list (Today, Yesterday, etc.). For more possibilities and versatility, choose Dynamic value and use expressions instead.
Format: Set a format for the date and time property's component. All date values will be saved in |
Email address
This property contains validators that make sure the data in this field has the same properties as a general email address.
Default value: Set to None so that no specific email will be shown by default, it should be typed in manually. Within a Static value, select an email address to be shown as the initial. For more possibilities and versatility, choose Dynamic value and use expressions instead. | |
In the Advanced section, you can set the database name to determine how this property will be called in the Data API and enable index value that speeds up search operations but slows down the creation of records. |
File
This property provides storage for files of various extensions. With this property, for each record one file can be stored. It is stored in our asset store and will be served as a URL.
Public: With this setting enabled, the file will be made available for public use. This means the file/URL from the asset store can be opened without authentication. Mostly used for public web page files. If this setting is disabled, the property is set to private, which means it takes an authenticated user to open the file/URL.
Validations: The property contains validations so that you can set its value as required. Also, you can manage all file extensions allowed for upload in this property. Add other extensions or remove them to suit your needs | |
In the Advanced section, you can fill the database name to determine how this property will be called in the Data API and set the limit of the file size. |
Iban
This property contains validators that make sure the data in this field has the same properties as a normal IBAN number. The IBAN consists of up to 34 alphanumeric characters comprising: a country code; two check digits; and a number that includes the domestic bank account number, branch identifier, and potential routing information.
The property contains validators so that you can set its field as required and value to be unique.
Default value: Set to None so that no specific Iban value will be shown by default, it should be typed in manually. Within a Static value, fill in a value to be shown as initial. For more possibilities and versatility, choose Dynamic value and use expressions instead. |
Image
This property provides storage for files of all various extensions. With this property, for each record one file can be stored. The file is stored in our asset store and will be served as a URL.
Public: With this setting enabled, the image will be made available for public use. This means the image/URL from the asset store can be opened without authentication. Mainly used for images used for public web pages. If this setting is disabled, the property is set to private, which means it takes an authenticated user to open the image/URL.
Validations: The property contains validations so that you can set its value as required. Also, you can manage all image file extensions allowed for upload in this property. Add other extensions or remove them to suit your needs. | |
In the Advanced section, you can set the database name, add a set of custom sizes for the image, choose optimization of image for the web and choose the maximum file size. |
List
This property can contain a predefined set of data that can be used as a radio button group or as a list selection on forms. You can enter text in the values of the list. The presented value of this property is always one of the existing values in this list.
Value: Add values to the List property. Choose one of the colors to distinguish each option when viewing the list in a record.
Default value: Set to None so that no specific list value will be shown by default, it should be typed in manually. Within a Static value, fill in a value to be shown as an initial. For more possibilities and versatility, choose Dynamic value and use expressions instead. |
Minutes
This property can be used to store time in minutes. While entered as a number value, the property shows its value in hours and minutes format. For example, the value 28 is shown as 28 minutes and the value 157 is shown as 2 hours and 37 minutes.
Default value: Set to None so that no specific time value will be shown by default, it should be typed in manually. Within a Static value, fill in a value to be shown as an initial. For more possibilities and versatility, choose Dynamic value and use expressions instead.
Format: This value determines how the data is displayed on a page. See this article to understand how formatting works. | |
The property contains validations in the Advanced section so that you can set this property’s value as required. With the ‘Greater than’ and ‘Less than’ options you can determine if the value has to be greater or less than the given number (minutes) accordingly. |
Multi file
This property provides storage for files of all extensions. With this property, each record there can contain multiple files. The files are stored in our asset store and will be served as an array of URLs.
Public: With this setting enabled, the files will be made available for public use. This means the files/URLs from the asset store can be opened without authentication. Mostly used for files used for public web pages. If this setting is disabled, the property is set to private, which means it takes an authenticated user to open the files/URLs.
Validations: The property contains validations so that you can set its value as required. Also, you can manage all file extensions allowed for upload in this property. Add other extensions or remove them to suit your needs. | |
In the Advanced section, you can set the database name, and choose the maximum file size (max 24MB) and the maximum number of files (maximum allowed by the platform by default is 15 files). |
Multi image
This property provides storage for files of all image extensions. With this property, each record there can contain multiple images. The images are stored in our asset store and will be served as an array of URLs.
Public: With this setting enabled, the files will be made available for public use. This means the files/URLs from the asset store can be opened without authentication. Mainly used for files used for public web pages. If this setting is disabled, the property is set to private, which means it takes an authenticated user to open the files/URLs.
Validations: The property contains validations so that you can set its value as required. Also, you can manage image file extensions allowed for upload in this property. Add other extensions or remove them to suit your needs. | |
In the Advanced section, you can set the database name, add a set of custom sizes for the image, choose optimization of image for web, choose the maximum file size (max 10MB) and the maximum number of files (maximum allowed by the platform by default is 15 files). |
Number
This property is used for saving whole numbers (that are written without fractional/decimal components), both positive and negative. Only accepts the characters 0 to 9 and "-" (minus).
Default value: Set to None so that no specific number value will be shown by default, it should be typed in manually. Within a Static value, fill in a value to be shown as an initial. For more possibilities and versatility, choose Dynamic value and use expressions instead.
Format: This value determines how the data is displayed on a page. See this article to understand how formatting works.
Validations: Besides setting values to be required and unique, there are ‘Greater than’ and ‘Less than’ options that determine if the value has to be greater or less than the given number. |
Number with decimal
This property is used for saving numbers that may contain fractional/decimal components, both positive and negative. Only accepts the characters 0 to 9, “-” (minus), “.” (period) and “,” (comma).
Dynamic value and format are explained in the Number property type. |
Password
This property is used for saving passwords. The property accepts all values, but the characters are replaced with asterisks (*) and saved as encrypted values in the database for privacy purposes.
This property can exclusively generate and store Pdf files according to a predefined template. The generated files can be downloaded, removed, and regenerated.
Template: Select one of the existing PDF templates or create a new one. For more possibilities and versatility, click the Dynamic template button and use expressions instead. By including the template's UUID in an expression, you can determine dynamically which template to use for the generated PDF. You can find the template's UUID in the URL when opening the PDF template as the value behind the last / (slash).
Filename: Set the filename for the generated file. It's not required to include the file extension.
Allow regenerate: With this setting enabled, the PDF file can be regenerated after it has been generated for the first time. The regenerated file will replace the previous file. It can be regenerated through the Pdf generate action event. If this setting is disabled, the file will not be available for regeneration.
Removable by user: With this setting enabled, the file can be removed by the user. |
Phone number
This property is used to save phone numbers. The value is saved as a text value and the URL is generated to start a call using the current system's native calling application.
Default value: Set to None so that no specific phone number value will be shown by default, it should be typed in manually. Within a Static value, fill in a value to be shown as an initial. For more possibilities and versatility, choose Dynamic value and use expressions instead.
Validations: Besides setting values to be required and unique, there are ‘Maximum length’ and ‘Minimum length’ options that determine the maximum and minimum required length for the given value accordingly. |
Price
This property holds numbers that are validated as a price in different currencies.
Default value: Set to None so that no specific price value will be shown by default, it should be typed in manually. Within a Static value, fill in a value to be shown as an initial. For more possibilities and versatility, choose Dynamic value and use expressions instead.
Format: This value determines how the price is displayed on a page. By default, it will show the tenth after the decimal comma (€ 0,00). See this article to understand how formatting works. | |
| In the Advanced section, you can set the database name and scale, that is the number of digits after a decimal point that will be shown in the database. Index the properties value to speed up the search operations. |
Rich text
This property is used to save text with HTML tags. For example, a text like Italic will be parsed as <i>Italic<i>. It supports text formatting, such as bold, italics, and underlining, as well as images, tables, and lists.
Default value: Set to None so that no specific text value will be shown by default, it should be typed in manually. Within a Static value, fill in a value to be shown as an initial. For more possibilities and versatility, choose Dynamic value and use expressions instead. |
Text (multi line)
This property is used for saving large text values. All characters are accepted and saved as plain text.
The default value is explained in the Rich text property type.
Validations: Besides setting values to be required, there are ‘Maximum length’ and ‘Minimum length’ options that determine the maximum and minimum required length for the given value accordingly. |
Text (single line)
This property is used for saving texts up to 255 characters. If this field needs to hold more than 255 characters, use the Text (multi line) property.
The default value is explained in the Rich text property type.
Validations: Besides setting values to be required and unique, there are ‘Maximum length’ (set to 255 characters by default) and ‘Minimum length’ options that determine the maximum and minimum required length for the given value accordingly. | |
‘Must be one of’ determines the input the user submits must be exactly one of the values defined here otherwise, a validation error will be returned. Click on the ‘Add’ button to type in the value or click on the bucket button to delete one. |
Time
This property is used to save a timestamp. It has been set to a standard of Hour-Minute.
Default value: Set to None so that no specific time value will be shown by default, it should be typed in manually. Within a Static value, fill in a value to be shown as initial. For more possibilities and versatility, choose Dynamic value and use expressions instead.
Format: This value determines how the price is displayed on a page. By default, it will show hours and minutes. See this article to understand how formatting works. | |
| In the Advanced section, you can set the database name and enable an index value that speeds up search operations but slows down the creation of records. |
Url
This property is used to save a web link. The value is preceded by HTTP://.
Default value: Set to None so that no specific URL value will be shown by default, it should be typed in manually. Within a Static value, fill in a value to be shown as an initial. For more possibilities and versatility, choose Dynamic value and use expressions instead. |