formie
formie copied to clipboard
Field limit checkbox fields
Describe the bug
When adding a checkbox list to a form, we noticed that if a user checks several items the limit is hit for the database column. They get the error that they have hit 255 characters.
Is it possible to add a lightswitch to change the database field type to Text instead of VARCHAR as on the plain text field?
Steps to reproduce
- Create a form and add a checklist
- Test the form by checking several items on the checklist
Form settings
- Multi-page form: No
- Submission Method: Page Reload
- Client-side Validation: No
- Custom Form Templates: No
Craft CMS version
4.5.11.1
Plugin version
2.0.43
Multi-site?
No
Additional context
No response
It's a known issue, and fixed for Craft 5 with some content table change overhauls.
For Craft 4 and Formie 2.x, please add the enableLargeFieldStorage = true
configuration setting, which will force Checkboxes (and many other fields) to use TEXT
columns.
Wonderful, thanks for the info!