Field types
JSON schema
A field with its own structure, described by the administration. From this description, the JSON schema, the input form in the field is created: tables, lists, number and text boxes.
Input
The input follows the schema. Usually it is a table with rows you can add and remove, or a group of labelled inputs. The editor marks whatever the schema does not allow.
Older fields of this kind are often plain tables. For new fields the administration usually sets up a JSON field ; it can do more in import, export and formatting.
Searching and exporting
| Action | Behaviour |
|---|---|
| Full-text search, filter | On the stored JSON text |
| Sorting, grouping | Not useful |
| Excel import | Only a complete JSON document in the cell, otherwise the value is parked. See Resolve references |
| Excel export, templates | The JSON text. There is no formatting for this field type |
Setup
See Configuring JSON schema .