String

String

6 (Value String)

Zahl

Integer

5 (Value Float)

Double

Float

5 (Value Float)

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)

DoubleSlider

JSON (String)

6 (Value String)

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"}

DurationConstraint

JSON (String)

6 (Value String)

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

FloatConstraint

JSON (String)

6 (Value String)

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)

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

QuadDuration

JSON (String)

6 (Value String)

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