How are checkbox submission stored in AO_4025C4_SUBMISSSION_FIELD?
The values for submissions for checkbox (multi-valued) fields are stored in AO_4025C4_SUBMISSSION_FIELD with a separate row for each submitted (checked) value in a form submission.
In the coming release we are adding a SHORT_VALUE column that you should know about. It will be used for server-side pagination as described in EASY-70: Add report table pagination to load pages lazilyIN DEV.
The submitted value of a checkbox is stored in the VALUE and/or the SHORT_VALUE column. If the value is less than or equal to 255 characters then the value is only in the SHORT_VALUE column, which is a VARCHAR(255) and the VALUE column is null.
If the value is greater than 255 characters then the entire value is stored in the VALUE column as a CLOB (which can get very large) and the first 255 characters are stored in the SHORT_VALUE column to support search filtering.
The field definition, the thing that defines the label for the checkbox input and the individual labels/values for each checkbox, is in AO_4025C4_FORM_FIELD. The label for the input is in the LABEL column which is VARCHAR(255) and the individual labels/values are all in that same row as a JSON string in the FIELD_OPTIONS column which is a CLOB. The value of the CLOB looks like this:
{"options":[{"label":"checkbox option one","checked":false},{"label":"checkbox option two","checked":false},{"label":"checkbox option three","checked":false}],"include_other_option":true}
Manage space
Manage content
Integrations
App links