Name | Data type | Data column index | Example Data | Description |
---|---|---|---|---|
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) | {"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, } | Four values with fixed position, customized label and customized visibility. |