Database

Column name

Sets the name that will be used for the database column storing the values of the field. It also serves as an identifier for the field.

Attribute type

Type of value that the field should contain.

Attribute size

Sets the maximum amount of characters that can be entered into the field. Only available if the Attribute type is set to Text.

Allow empty value

If enabled, the field allows empty values. If disabled, the field is required and an asterisk (*) is displayed next to it.

Default value

Default value of the field that will be pre-filled when objects based on the table are created.

Translate field

Indicates if the field should be included when using translation services for objects defined by the given system table.

Only available if the selected Attribute type is Text, Long text or File.

Display attribute in the editing form

If you uncheck this property, then the given field will not be available in editing forms for the objects based on this table.

Field appearance

Field caption

Text displayed in editing forms next to the field.

Form control

Selects the form control that should be used to interact with the given field in editing forms.

If the form control that you need is not available in the drop-down list, you should be able to assign it through the dialog opened via the (more items ...) option.

Field description

Tooltip which will be displayed if a user hovers over the field.

Editing control settings

The settings in this section are used to perform additional configuration of the selected Form control, which affects the behavior or appearance of the field. The available options depend on the parameters defined for the given form control. Please see the tooltips of individual settings for more information.

This section also has two available modes. You can switch between Advanced and Simplified mode using the link on the side of the section. In simplified mode, only a limited set of parameters is offered (typically the most important ones).

Validation

Regular expression

This regular expression will be used by the validator of the field. Only available if the selected Attribute type is Text or Long text.

Min/Max length

Sets the minimum/maximum length for entered values. Only available if the selected Attribute type is Text or Long text.

Min/Max value

Sets the minimum/maximum value that can be entered. Only available if the selected Attribute type is numerical.

From/To

Can be used to specify a time interval into which the entered value must belong. Only available if the selected Attribute type is Date and time.

Error message

Error message displayed if a user enters invalid input into the field and attempts to save the form.

CSS styles

Caption style

Used to set CSS styles for the caption of the given field.

Input style

Used to set CSS styles for the input entered into the field.

Control CSS class

Name of the CSS class used to style the field.

Field advanced settings

Visible condition

May be used to enter a macro condition that must be fulfilled in order for the specific field to be visible in editing forms.

You can write any condition according to your specific requirements. For details about available macro options and syntax, please refer to the Development -> Macro expressions chapter of the Developer's Guide.

If you wish to create a condition that depends on the state of the system table's other fields, you can access them in the macro expression using the corresponding Column name. The data of the fields may then be retrieved through the following properties:

•Value - returns the current value of the field. For example, Email.Value is resolved into the value entered into the Email field.

•Visible - returns a true value if the given field is currently visible in the editing form.

•Enabled - true if the field is currently enabled, i.e. its value can be edited.

•Info.<field setting> - may be used to access various settings configured for the field, for example: Email.Info.AllowEmpty

Enabled condition

Allows you to enter a macro condition that determines when the field should be enabled. If this condition is resolved as false, the field will be visible, but it will not be possible to edit its value.

You can use the same macro options as described above for the Visible condition property.

Has depending fields

If enabled, the editing form will be refreshed via autopostback whenever the value of the given field is changed. This means that other fields can be dynamically updated according to the current value of the field.

Please note that the actual logic of the dependencies needs to be implemented in the code of the used form controls.

Depends on another field

This option must be enabled if you wish to have the behavior of the field dynamically changed according to the value of some other field.

Category

Category name

Sets the name of the category.

Collapsible

If enabled, users will be able to collapse and expand the content of the category.

Collapsed by default

If enabled, the category will initially be collapsed when the editing form is loaded.

Visible

Indicates if the category and all of the fields under it should be visible.

Visible condition

May be used to enter a macro condition that must be fulfilled in order for the category to be visible. You can use the same macro options as described above for the Visible condition property of fields.