Table of Contents
What should I do if Easy Forms for Confluence crashes when I try to enable the plugin?
...
- No. Forms on different pages can have the same name, but two forms on the same page currently causes the second form to just appear empty. This will be replaced with an error message in the future. Can
Can I move my form to another page?
- No. The form data is associated with that page's PageId. So you can rename or move the page but the form 'lives' on that page.
...
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}