Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount on memberships! Get 20% off now with code SPOOKY-2024!

Maximum Options allowed in Select Field

11 years 5 months ago #227480 by mccormackdave
Maximum Options allowed in Select Field was created by mccormackdave
Ok so i found out the hard way that there is a limit to the number of fields allowed.

But i am wondering is there a maximum number of options allowed in a single Dropdown select, Dropdown Multi-select or Multicheckbox field

Dave

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48460
  • Thanks: 8280
  • Karma: 1443
11 years 5 months ago #227482 by krileon
Replied by krileon on topic Maximum Options allowed in Select Field
You can have as many fields as you want. You just hit MYSQL column size limits. Changing your database engine to InnoDB using phpmyadmin > _comprofiler > Operations > Storage Engine should help with this. You can also try changing varchar columns to text to free up space for more fields. Please make a backup of your database before doing any of this though. Field values are just a database row per value so you have no limit with those.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
The following user(s) said Thank You: mccormackdave

Please Log in or Create an account to join the conversation.

11 years 5 months ago #227485 by mccormackdave
Replied by mccormackdave on topic Maximum Options allowed in Select Field
Im always very pleased with you Krileon
Thank you again for your speedy response

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum