FieldValue

The field value. Its JSON type follows the field's inputType: number returns an integer; float, money and percent return a number; checkbox returns a boolean; file and image return the integer id of the uploaded file; date, datetime, gdpr_accept, newsletter_accept and cookies_accept return a formatted date string; rating returns the picked number as a string; select and radio return the option value, never its label (the label is exposed in selected); multiselect and checkbox_group return the picked option values joined by a pipe, e.g. new|qualified; related_entity returns the id of the linked record as a string, its module being reported in valueModule; related_entities returns the ids of the linked records joined by a pipe, e.g. 1|2|3; users returns a JSON-encoded string — not an object — whose decoded shape carries the keys users, teams and categories, each an array of integer ids; calculation returns whatever the formula evaluates to, i.e. a string, a number or a boolean; rollup returns an array of the collected values for SHOW_ORIGINAL and SHOW_UNIQUE, a number or a date string for scalar aggregations, or an object carrying a single _error key when the aggregation fails; every other inputType returns a string. Writes accept the same shapes, but only as JSON scalars: an array or an object in value is rejected with code 4006, so users and related_entities have to be sent in the string forms above (a related_entities value that is neither pipe-separated nor a single numeric id is rejected with code 4017). Custom field values nested in a Space are serialised through a separate string-cast path, so there every inputType — number and checkbox included — comes back as a string. The storage column used internally (valueInt, valueFloat, valueDatetime, valueWysiwyg) is determined by the same inputType. For inputType calculation and rollup this value is computed by the system and read-only — see the schema description.

Creation datetime

Field id. If this field is not specified, ID is loaded using customFieldInputName and module

Name of field which gets filled. Applied only when customFieldInputId is not set

ID of the record (within the given module) that this value is attached to.

ID of the uploaded file; used when the field inputType is 'file'.

Unique identifier of this field value record.

IP address from which this value was submitted; used for GDPR, newsletter, and cookie acceptance inputs.

Module this field value belongs to

Label of the option picked for this value, resolved by matching the whole stored value against the option values of the field. Filled for the option-based inputTypes — select, multiselect and radio — and null for every other inputType, including checkbox, whose state is carried by value as a boolean, and checkbox_group. Because the match runs against the whole stored value, a multiselect holding several pipe-joined options resolves to null; only a single picked option yields a label. This property therefore never carries a list of labels — to get the labels of several picked options, split value on the pipe and map the option values against the field options.

Module table (if module has more tables). If not filled, is loaded automatically

Is field translatable

Input value, stored as Datetime (inner db representation of DATETIME value

Input value, stored as Float (inner db representation of DOUBLE value

Input value, stored as Integer (inner db representation of INT value

Module of connected entity. It's only for values from connected-value fields.

Input value, stored as Wysiwig (inner db representation of TEXT value)