Tablefield label
Free text

A friendly name/label for the tablefield

Field name
Alfanumeric + underscore + dash

This attribute represents the name of the form field.

In-field help value
Free text

Some form fields allow an in-field hint value.

Tablefield type (= text)

Default value

The type of the value depends on the field type.
Can be string,boolean, number, array or object. When using an enum field, you can use the following special values : * __auto__ : select the first * __none__ : select none * __all__ : select all (if multiple is true)

A list validation (must be in list)

Enforces a validation where the current field must be one of the values in a list (referencing another field). This field requires an object with 2 attributes: * field : The name of the field that holds the list * description : A validation message to show when the validation is not met. (new in v5.0.1 : can have placeholder)

Examples:

in:
  field: range_of_ips   # range_of_ips is an other expression array field
  description: This ip must be in the specified range              

Field maximum length
Integer > 0

Forces a string-field to be maximum x long.

Field minimum length
Integer > 0

Forces a string-field to be at least x long.

A list validation (can not be in list)

Enforces a validation where the current field can not be one of the values in a list (referencing another field). This field requires an object with 2 attributes: * field : The name of the field that holds the list * description : A validation message to show when the validation is not met. (new in v5.0.1 : can have placeholder)

Examples:

notIn:
  field: list_of_ips  # list_of_ips is an other expression array field
  description: This ip already exists            

A regular expression validation

Enforces a validation where the current field must match a regular expression. This field requires an object with 2 attributes: * expression : The regular expression * description : A validation message to show when the regex is not matched.

Examples:

regex:
  expression: "[a-z0-9]+@[a-z]+\.[a-z]{2,3}"
  description: Please type a valid email address

regex:
  expression: "(?=^.{8,}$)(?=.*\d)(?=.*[!@#$%^&*]+)(?![.\n])(?=.*[A-Z])(?=.*[a-z]).*$"
  description: Must be complex (8 or longer ; uppercase ; lowercase ; numeric ; specials)              

Required field

Makes the field required.

Field icon
Free fontawesome 6 icon

Some tablefields can hold a nice looking icon. The icon name is a free fontawesome 6 icon. You can find more information at www.fontawesome.com

Tablefield label
Free text

A friendly name/label for the tablefield

Field name
Alfanumeric + underscore + dash

This attribute represents the name of the form field.

In-field help value
Free text

Some form fields allow an in-field hint value.

Tablefield type (= textarea)

Default value

The type of the value depends on the field type.
Can be string,boolean, number, array or object. When using an enum field, you can use the following special values : * __auto__ : select the first * __none__ : select none * __all__ : select all (if multiple is true)

Required field

Makes the field required.

Tablefield label
Free text

A friendly name/label for the tablefield

Field name
Alfanumeric + underscore + dash

This attribute represents the name of the form field.

In-field help value
Free text

Some form fields allow an in-field hint value.

Tablefield type (= number)

Default value

The type of the value depends on the field type.
Can be string,boolean, number, array or object. When using an enum field, you can use the following special values : * __auto__ : select the first * __none__ : select none * __all__ : select all (if multiple is true)

Field maximum value
Integer

Forces a number-field to not be higher than…

Field minimum value
Integer

Forces a number-field to not be lower than…

Required field

Makes the field required.

Field icon
Free fontawesome 6 icon

Some tablefields can hold a nice looking icon. The icon name is a free fontawesome 6 icon. You can find more information at www.fontawesome.com

Tablefield label
Free text

A friendly name/label for the tablefield

Field name
Alfanumeric + underscore + dash

This attribute represents the name of the form field.

In-field help value
Free text

Some form fields allow an in-field hint value.

Tablefield type (= password)

Default value

The type of the value depends on the field type.
Can be string,boolean, number, array or object. When using an enum field, you can use the following special values : * __auto__ : select the first * __none__ : select none * __all__ : select all (if multiple is true)

A list validation (must be in list)

Enforces a validation where the current field must be one of the values in a list (referencing another field). This field requires an object with 2 attributes: * field : The name of the field that holds the list * description : A validation message to show when the validation is not met. (new in v5.0.1 : can have placeholder)

Examples:

in:
  field: range_of_ips   # range_of_ips is an other expression array field
  description: This ip must be in the specified range              

Field maximum length
Integer > 0

Forces a string-field to be maximum x long.

Field minimum length
Integer > 0

Forces a string-field to be at least x long.

A list validation (can not be in list)

Enforces a validation where the current field can not be one of the values in a list (referencing another field). This field requires an object with 2 attributes: * field : The name of the field that holds the list * description : A validation message to show when the validation is not met. (new in v5.0.1 : can have placeholder)

Examples:

notIn:
  field: list_of_ips  # list_of_ips is an other expression array field
  description: This ip already exists            

A regular expression validation

Enforces a validation where the current field must match a regular expression. This field requires an object with 2 attributes: * expression : The regular expression * description : A validation message to show when the regex is not matched.

Examples:

regex:
  expression: "[a-z0-9]+@[a-z]+\.[a-z]{2,3}"
  description: Please type a valid email address

regex:
  expression: "(?=^.{8,}$)(?=.*\d)(?=.*[!@#$%^&*]+)(?![.\n])(?=.*[A-Z])(?=.*[a-z]).*$"
  description: Must be complex (8 or longer ; uppercase ; lowercase ; numeric ; specials)              

Required field

Makes the field required.

Field icon
Free fontawesome 6 icon

Some tablefields can hold a nice looking icon. The icon name is a free fontawesome 6 icon. You can find more information at www.fontawesome.com

Tablefield label
Free text

A friendly name/label for the tablefield

Field name
Alfanumeric + underscore + dash

This attribute represents the name of the form field.

In-field help value
Free text

Some form fields allow an in-field hint value.

Tablefield type (= checkbox)

Default value

The type of the value depends on the field type.
Can be string,boolean, number, array or object. When using an enum field, you can use the following special values : * __auto__ : select the first * __none__ : select none * __all__ : select all (if multiple is true)

Required field

Makes the field required.

Tablefield label
Free text

A friendly name/label for the tablefield

Field name
Alfanumeric + underscore + dash

This attribute represents the name of the form field.

In-field help value
Free text

Some form fields allow an in-field hint value.

Tablefield type (= datetime)

Default value

The type of the value depends on the field type.
Can be string,boolean, number, array or object. When using an enum field, you can use the following special values : * __auto__ : select the first * __none__ : select none * __all__ : select all (if multiple is true)

DateType of the datetime picker

The datetime picker can pick several types

A list validation (must be in list)

Enforces a validation where the current field must be one of the values in a list (referencing another field). This field requires an object with 2 attributes: * field : The name of the field that holds the list * description : A validation message to show when the validation is not met. (new in v5.0.1 : can have placeholder)

Examples:

in:
  field: range_of_ips   # range_of_ips is an other expression array field
  description: This ip must be in the specified range              

A list validation (can not be in list)

Enforces a validation where the current field can not be one of the values in a list (referencing another field). This field requires an object with 2 attributes: * field : The name of the field that holds the list * description : A validation message to show when the validation is not met. (new in v5.0.1 : can have placeholder)

Examples:

notIn:
  field: list_of_ips  # list_of_ips is an other expression array field
  description: This ip already exists            

A regular expression validation

Enforces a validation where the current field must match a regular expression. This field requires an object with 2 attributes: * expression : The regular expression * description : A validation message to show when the regex is not matched.

Examples:

regex:
  expression: "[a-z0-9]+@[a-z]+\.[a-z]{2,3}"
  description: Please type a valid email address

regex:
  expression: "(?=^.{8,}$)(?=.*\d)(?=.*[!@#$%^&*]+)(?![.\n])(?=.*[A-Z])(?=.*[a-z]).*$"
  description: Must be complex (8 or longer ; uppercase ; lowercase ; numeric ; specials)              

Required field

Makes the field required.

Field icon
Free fontawesome 6 icon

Some tablefields can hold a nice looking icon. The icon name is a free fontawesome 6 icon. You can find more information at www.fontawesome.com

Tablefield label
Free text

A friendly name/label for the tablefield

Field name
Alfanumeric + underscore + dash

This attribute represents the name of the form field.

In-field help value
Free text

Some form fields allow an in-field hint value.

Tablefield type (= enum)

Default value

The type of the value depends on the field type.
Can be string,boolean, number, array or object. When using an enum field, you can use the following special values : * __auto__ : select the first * __none__ : select none * __all__ : select all (if multiple is true)

Datasource
expression reference

In a table we can have an enum field. The source of the data for this enum field must come from the main form.
So this from field points to the expression field that holds the query data.

Output the selection of an enum field as a full object.

When selecting from an enum field (dropdown), either the first column or
the column defined in valueColumn is sent as an extravar.
If you want the full selected record, use the property.

new in v4.0.20 : you can also use valueColumn: “*” to export all columns

The column of a selected item that needs to exported as extravar

When you select an item in an enum field, by default the first column is used to send as extravar.
By setting this property, you can change it to another field.
This setting is ignored when outputObject is true.

new in v4.0.20 : setting value “*” will export all columns.

Examples:

- name: users
  type: enum
  dbConfig:
    name: CMDB
    type: mysql
  query: SELECT name, username FROM users
  columns:
  - name
  valueColumn: username

The list of columns that you can filter on

By default the previewColumn or first visible column is used to filter on.
With this property you can filter on the columns you want.

Examples:

- name: volumes
  type: enum
  dbConfig:
    name: CMDB
    type: mysql
  query: SELECT id, name, title FROM volumes
  columns:
  - name
  - title
  filterColumns:
  - name
  - title  

Required field

Makes the field required.

The list of columns visible in the dropdown box

By default all properties are show in an enum field. With this property you can choose which are visible.

Examples:

- name: users
  type: enum
  dbConfig:
    name: CMDB
    type: mysql
  query: SELECT id, name, username, zip, city FROM users
  columns:
  - name
  - username

Converts a dropdown box to a horizontal selector

A enum field is by default a dropdown box. However, you can change that behavior by setting this property.
The unselected values are on the left and the selected values on the right. This works in combiniation with sticky.
PctColumns are disabled, due to the space it consumes horizontally.

Field icon
Free fontawesome 6 icon

Some tablefields can hold a nice looking icon. The icon name is a free fontawesome 6 icon. You can find more information at www.fontawesome.com

The list of columns that should visualized as a percentage-bar

By default all properties are show with its regular value.
With a percentage it can be nice to visualize it as a graphical bar.
The assumption is that the value is an integer between 0 and 100.

Examples:

- name: volumes
  type: enum
  dbConfig:
    name: CMDB
    type: mysql
  query: SELECT id, name, used, total, (used/total*100) as used_pct FROM volumes
  columns:
  - name
  - used_pct
  pctColumns:
  - used_pct

The column of the selected item(s) that is shown in the dropdown-preview

When you select an item in an enum field, by default the first column is used as a preview.
By setting this property you change the column to be used.

Examples:

- name: user
  type: enum
  dbConfig:
    name: CMDB
    type: mysql
  query: SELECT id,name FROM users
  previewColumn: name

Make a dropdown box permanently visible

A enum field is by default a dropdown box. However, you can change that behavior by setting this property.
The dropbox looses it reactivity and becomes a fixed table.