WAI
Status Update
Comments
cu...@gmail.com <cu...@gmail.com> #2
I agree that this bug popped randomly last week. We have always created form drop down fields that have this many values and all of the sudden it started failing. Is there a limit now?
jo...@gmail.com <jo...@gmail.com> #3
Yes same issue. Is there an official limit of how many items can be assigned to drop down / mulitple-choice / checkbox item?
mc...@google.com <mc...@google.com> #4
Since June, we've imposed a limit on the number of options that can be added to a Forms dropdown in Apps Script. The limit is currently 1,000 but is subject to change. If you need to provide more options, consider a free-form text field, multiple dropdowns, or a custom web form.
ma...@nexteer.com <ma...@nexteer.com> #5
Please remove the limit or set a workable limit. 1000 is simply not enough in a globalized company. This new imposed limit has broke several of my companies processes. This is very frustrating to have working processes for over 3 years suddenly break without warning.
he...@pwc.com <he...@pwc.com> #6
What is the rationale for an arbitrary limit like 1000? We also use Google at an enterprise scale and the need to include 3000 choices in a dropdown is unavoidable for capturing validated data. We'd rather have a script run long - and work - than not have a function at all.
bc...@gmail.com <bc...@gmail.com> #7
Agree with the other commenters. Free-text fields are inherently poor for data integrity and 1000 is a tiny number when G Suite is intended to be an enterprise-level platform.
One alternative to eliminate enormous lists would be to implement dependent drop downs. So instead of a drop down list of 2000 employees, let me choose a department first so that I only view the 140 employees in Department X.
One alternative to eliminate enormous lists would be to implement dependent drop downs. So instead of a drop down list of 2000 employees, let me choose a department first so that I only view the 140 employees in Department X.
cl...@netflix.com <cl...@netflix.com> #8
Is there any option to allow G Suite organization that want to change the limit? In agreement with all previous commenters, it's a mistake and truly inefficient to limit the number of choices to 1000. It's not scalable for us and really discourages the usage of Google Form unless that is the intent of Google.
[Deleted User] <[Deleted User]> #9
Add my voice to this list. An arbitrary limitation of 1000 does not work for our needs. It makes the form unusable for a multi-site company.
dh...@mynycschool.org <dh...@mynycschool.org> #10
Hello, I've had a similar problem. I only need to create 227 options on a drop-down list for a question on a google form. Whenever I copy and past all the options onto the question, I get a message at the top "Can't save your changes. Copy any recent changes, then revert to an earlier version"
gm...@ccsd.edu <gm...@ccsd.edu> #11
We are having the same problem. We have a form with the senior class listed in a drop-down menu which worked perfectly last year. We attempted to update the names to the current senior class and it will not work. We get the message "Can't save your changes. Copy and recent changes, then revert to an earlier version."
ja...@trimble.com <ja...@trimble.com> #12
25,000 would be a reasonable limit if you have to impose one.
[Deleted User] <[Deleted User]> #13
I assume that by now, this issue has been shelved? And the 1,000 limit is to stay for the foreseeable future?
pe...@gmail.com <pe...@gmail.com> #14
Yes, the issue is still on. No progress, and a big frustration.
[Deleted User] <[Deleted User]> #15
I have the same problem! Why they put this limit? There is no sense!
p0...@brookes.ac.uk <p0...@brookes.ac.uk> #16
Just want to register my own annoyance at this seemingly arbitrary limit. Most frustrating and the suggested workarounds are not at all practical for validating data.
[Deleted User] <[Deleted User]> #17
Tengo el mismo problema en mi compañía, es absurdo imponer un limite y además de que me cobren una licencia plus no solucionen el problema ahora el desarrollo de meses se encuentra estancado
ni...@nk-data-analytics.com <ni...@nk-data-analytics.com> #18
Same here. One of our forms is generated by an app script and after adding new values to the array of options, everything broke. Extremely annoying and we now have to search for another option.
he...@pwc.com <he...@pwc.com> #19
We had to give up on google & move many of our enterprise forms over to power platform. Google made a play for business clients but it's increasingly clear that they can't be bothered to develop really robust enterprise capabilities across their suite. Gmail is great, as are GSheets & appscript. The rest...not so much.
di...@gmail.com <di...@gmail.com> #20
I wanted to voice my frustration as well. It seems that the limit is arbitrary and is affecting our ability to use G Suite as a school.
re...@gmail.com <re...@gmail.com> #21
There should be no cap on the drop down list. I need a drop down list of 45,000 to hold all city names. I pay for Google Workspace, I should not be limited to anything.
ro...@gmail.com <ro...@gmail.com> #22
Still no update from Google on the cap limit of 1000 for drop down list??
pu...@gmail.com <pu...@gmail.com> #23
Waiting for a solution.
la...@gmail.com <la...@gmail.com> #24
I also need Google to either raise the drop down option limit to 5,000 or more or create an either or option (for requiring answers). True that it is not "hard" to add another question, but it is not practical for our purposes. I work for a school district and there are more than 1000 students in most schools in our county.
mn...@schools.nyc.gov <mn...@schools.nyc.gov> #25
Adding my voice to this complaint as well. Would prefer to have the cap raised.
That said, I'm hoping to work around it by dividing the 1800 list items into categories, and navigating users to dropdowns with a subset of the list based on their initial responses.
That said, I'm hoping to work around it by dividing the 1800 list items into categories, and navigating users to dropdowns with a subset of the list based on their initial responses.
da...@closetandglass.com <da...@closetandglass.com> #26
bump
sl...@dupage88.net <sl...@dupage88.net> #27
Bump as well.
au...@gmail.com <au...@gmail.com> #28
While I can see it's not likely to change at all, is very annoying to deal with when building a very simple number list from 1-999 + variations on 1-99 that have a 0 or 00 as the first digit/s, and therefore having to split it into 2 separate dropdowns (since the total number of possible options is just over 1100)
lo...@gmail.com <lo...@gmail.com> #29
I hope this message finds you well. I wanted to take a moment to express my frustration regarding the limited number of options available in [mention the specific context, e.g., the recent survey/questionnaire].
It's quite disappointing to encounter such a restriction, especially when dealing with a topic that demands a comprehensive range of choices. In today's diverse world, where nuances and variations matter, limiting us to just [mention the current number of options] options feels incredibly constraining.
I strongly urge that we reconsider this limitation. To accurately capture the diversity of responses and opinions, I propose that we should have a minimum of 10,000 options available. This may seem like a large number, but it's essential for providing respondents with the flexibility they need to express themselves accurately.
By increasing the number of options, we can ensure that our data is more precise and meaningful. It will also demonstrate our commitment to inclusivity and a thorough understanding of the subject matter.
I kindly request that this matter be discussed further and that we work towards a solution that allows for a more comprehensive and nuanced response collection process.
Thank you for your attention to this matter.
It's quite disappointing to encounter such a restriction, especially when dealing with a topic that demands a comprehensive range of choices. In today's diverse world, where nuances and variations matter, limiting us to just [mention the current number of options] options feels incredibly constraining.
I strongly urge that we reconsider this limitation. To accurately capture the diversity of responses and opinions, I propose that we should have a minimum of 10,000 options available. This may seem like a large number, but it's essential for providing respondents with the flexibility they need to express themselves accurately.
By increasing the number of options, we can ensure that our data is more precise and meaningful. It will also demonstrate our commitment to inclusivity and a thorough understanding of the subject matter.
I kindly request that this matter be discussed further and that we work towards a solution that allows for a more comprehensive and nuanced response collection process.
Thank you for your attention to this matter.
su...@pracbiz.com <su...@pracbiz.com> #30
As of 9/1/2024 this issue has not been fix yet.
Description
First, please search through existing issues to ensure that the bug has not already been reported. You can start the search here:
If the issue has already been reported, you can click the star next to the issue number to subscribe and receive updates. We prioritize responding to the issues with the most stars. You can also comment on the issue to provide any details of your experience with it.
If your issue has not been reported, please provide all of the following:
-----------------------------------------------------------------------------------------------------------------------------
A short description of the issue:
Previously, I was using Google Apps Script to populate the choices for a dropdown list on a weekly basis. One question had as many as 3600 choices. This week, when running the same script with a reduced number of choices (approx. 2000), I receive the following error: "Failed to set choices. You exceeded the maximum number of choices." Is there a new limit? I cannot find one listed.
A small code sample that reliably reproduces the issue. The sample should run as-is or with minimal setup, without external dependencies.
var sheetUrl = '
var sheet = SpreadsheetApp.openByUrl(sheetUrl).getSheetByName("Form Responses 1");
var data = sheet.getDataRange().getValues();
var formExample = FormApp.openById('xxxxxxxxxxxxxxxxxxxxxxxxxx');
var listOfCustomers= formExample.getItemById(1234567890);
var customerChoices = [];
for (var i = 0; i < data.length; i+=1){
customerChoices.push(listOfCustomers.asListItem().createChoice(data[i][0]));
}
listOfCustomers.asListItem().setChoices(customerChoices);
What is the project key (found under "File > Project properties")? The project key does not give the Apps Script team access to your source code or data. We use it to look up debug information about your script.
MScNSGOUaQTSDnyXZC5B_d5YVeaX0aH1T
What steps will reproduce the problem?
1. Create a Google Form.
2. Create dropdown list question.
3. Get ID for that question.
4. Try to programatically add 2000-3000 choices for this question.
What is the expected output? What do you see instead? If you see error messages, please provide them.
Expected output is a dropdown list with options. Instead, I receive an error message when running the script from
Please provide any additional information below.