formie icon indicating copy to clipboard operation
formie copied to clipboard

Field limit checkbox fields

Open SarahOorts opened this issue 1 year ago • 2 comments

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

  1. Create a form and add a checklist
  2. 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

SarahOorts avatar Feb 12 '24 09:02 SarahOorts

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.

engram-design avatar Feb 15 '24 13:02 engram-design

Wonderful, thanks for the info!

SarahOorts avatar Feb 19 '24 08:02 SarahOorts