Data types in HTML Form
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: | |
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) | { | New in 7.1 Four values with fixed position, customized label and customized visibility. |