Name

Data type

Data column index

Example Data

Description

String

String

6 (Value String)



Integer

("Zahl" before 7.1)

Integer

5 (Value Float)


New from 7.1: Renamed to "Integer", "Zahl" continues to work

PositiveInteger

Integer

5 (Value Float)


New from 7.1:
value >= 0

Double

Float

5 (Value Float)



PositiveDouble

Float

5 (Value Float)


New from 7.1:

value >= 0

Bool

Boolean

3 (Value Bool)



NullableBool

Boolean or Null

3 (Value Bool)



DateTime

Datetime

4 (Value Datetime)



SingleDuration

String

6 (Value String)



Selection

JSON (String)

6 (Value String)

[{"val_text":"Eins", "val_id": 1}, {"val_text": "Zwei", "val_id": 2}]

ID-based selection list

IDs are integers

The selected item is identified with its ID in the "Zahl" column

Selection2

JSON (String)

6 (Value String)

[{"Name":"Item 1", "Selected": true}, {"Name": "Item 2", "Selected": false}]


OpeningHours

JSON (String)

6 (Value String)

{"from1":"06:00","to1":"12:00","from2":"13:00","to2":"18:00"}


DoubleSlider

JSON (String)

6 (Value String)

{"disable_min":false,"slider_min":0,"target_min":5,"target_max":20,"slider_max":25,"disable_max":false, "slider_color": "#ff0000"}


DayOfWeek

JSON (String)

6 (Value String)

{"Mon":true,"Tue":true,"Wed":true,"Thu":true,"Fri":true,"Sat":false,"Sun":false}

Day of the week

TimestampConstraint

JSON (String)

6 (Value String)

{"Min hc":"09:00","Min sc":"09:00","Max sc":"10:00","Max hc":"10:00"}

each value is a time (limited to 0-24)

DurationConstraint

JSON (String)

6 (Value String)

{"Min hc":"8:00","Min sc":"8:00","Max sc":"8:00","Max hc":"8:00"}

each value is a duration

FloatConstraint

JSON (String)

6 (Value String)

{"Min hc":"3","Min sc":"4","Max sc":"5","Max hc":"6"}


HalfDurationConstraint

JSON (String)

6 (Value String)

{"sc":"8:00","hc":"9:00"}


HalfFloatConstraint

JSON (String)

6 (Value String)

{"sc":"0.7","hc":"0.6"}


ShiftGroupSelection

JSON (String)

6 (Value String)

[{"Name":"SG1","Selected":false},{"Name":"SG2","Selected":false}]


Time

String

6 (Value String)

23:15

New in 7.0

FromToTime

JSON (String)

6 (Value String)

{"from": "08:00", "to": "12:00"}

New in 7.0

FromToTimeBreakMin

JSON (String)

6 (Value String)

{"from": "08:00", "to": "12:00", "break_min": 30}

New in 7.1

QuadDuration

JSON (String)

6 (Value String)

{
"duration1":"",
"duration2":"",
"duration3":"",
"duration4":"",
"duration1 Label":"Duration 1",
"duration2 Label":"Duration 2",
"duration3 Label":"Duration 3",
"duration4 Label":"Duration 4",
"duration1 Visible":true,
"duration2 Visible":true,
"duration3 Visible":true,
"duration4 Visible":false
}

New in 7.1

Four values with fixed position, customized label and customized visibility.

ValueWithSelection

JSON (String)

6 (Value String)

{"Value": "3", "Selection": [{"Name":"Month(s)", "Selected": true}, {"Name": "Week(s)", "Selected": false}] }

New in 7.1