Field types
Switch
A yes/no decision, shown as a slider or as a switch with text in it. For courier accompaniment, loan eligibility, inclusion in the catalogue.
Input
A click toggles the switch and saves. The label on the switch (ja, nein or whatever the administration has entered) shows its state.
A switch has no “unknown”. An object on which the switch was never touched reads like an explicit no. If you need three states, for example checked, not checked, unknown, ask the administration for a select list .
What is stored
Usually 1 for on and 0 for off. The labels are display only: if the switch says erledigt (done)
instead of ja, the stored value is still 1. Some fields store a text instead, such as Ausgestellt (exhibited); that is set by the administration.
| Action | Behaviour |
|---|---|
| Filter | Equals with 1 or 0. Equals with an empty search term finds objects on which the switch was never set |
| Sorting | 0 before 1 |
| Grouping | Two groups |
| Kanban | Two columns, moving a card toggles the switch |
| Bulk edit | Set to true, set to false, toggle, replace, clear |
Excel import
The import translates whatever is unambiguous. ja, j, yes, true, wahr, x, 1, ein, an, checked, ✓ and the switch’s label become on, the corresponding negations become off. Upper and lower case do not matter. Everything else is parked and marked “to resolve”, including a dash -: in spreadsheets it usually means “not applicable”. See Resolve references .
Display and export
| Formatting | Result |
|---|---|
| Raw value | 1 or 0 |
| Label | The field’s labels, for example ja or nein |
The formatting is not preset anywhere; the views show the switch according to your setting anyway. You choose it in the view settings or in the Excel export .
In Word templates, fcheck() helps, as it can handle both forms of storage. See Template functions and Switch fields in templates .
Setup
Display, labels and stored values are set by the administration. See Configuring the switch .