CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • What is the maximum number of items I can have in a drop-down list
Pages: [1]

Author Topic: What is the maximum number of items I can have in a drop-down list  (Read 535 times)

cfusch

  • I post occasionally
  • **
  • Posts: 44
  • Karma: 1
  • CiviCRM version: 4.6.6
  • CMS version: Drupal 7.39
  • MySQL version: 5.6.23
  • PHP version: 5.4.38
What is the maximum number of items I can have in a drop-down list
March 12, 2015, 07:05:16 pm
In creating a custom field set for alphanumeric and 'select' is there a limitation on the number of drop-down (select) items a field can have?  AND is there some way to import the list of items rather than using the administrative entry of one at a time? - Carl

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: What is the maximum number of items I can have in a drop-down list
March 12, 2015, 07:07:38 pm
Civi does not impose a limit afaik but there is a practical limit to how many options a web browser can load before page requests become unreasonably slow. I'd say it's somewhere between 100 and 1000 depending on your use. Beyond that I would switch the widget to autocomplete.

You could use the api to bulk-import options.
Try asking your question on the new CiviCRM help site.

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: What is the maximum number of items I can have in a drop-down list
March 12, 2015, 07:40:24 pm
when i have a civi field in webform with over 500 it throws up a message

Quote
Maximum contacts exceeded, list truncated.
The field "xxx " cannot show more than 500 contacts because it is a select list. Recommend switching to autocomplete widget in component settings.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: What is the maximum number of items I can have in a drop-down list
March 13, 2015, 06:11:09 am
Oh yea, I do remember adding that warning for drupal webforms. It was to protect you from creating a list so large that it crashed Drupal or your webbrowser.
Try asking your question on the new CiviCRM help site.

cfusch

  • I post occasionally
  • **
  • Posts: 44
  • Karma: 1
  • CiviCRM version: 4.6.6
  • CMS version: Drupal 7.39
  • MySQL version: 5.6.23
  • PHP version: 5.4.38
Re: What is the maximum number of items I can have in a drop-down list
March 23, 2015, 09:37:26 am
Pete and Coleman, thanks for you response!  Okay, 500 is far beyond what I'll need, but its good to know that I'm covered with a smaller number of select items.  Pete, its on the margin where I still have some diligence with deciding on select vs autocomplete.  I think the client will make the decision.

Never used CiviCRMs API, but I guess its time to give it a whirl and as is with most API's it'll become valuable in the future, too.  Thanks!

Carl
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • What is the maximum number of items I can have in a drop-down list

This forum was archived on 2017-11-26.