Find the optimal method to put data from GoogleSheet into dropdown box in GoogleForm via FormRanger

[Trọng Nghĩa Lưu]

Hello everyone! I have a work problem that needs to be optimized, specifically as follows: My school has a total of 64 classes, 2876 students. I want to collect student information through GoogleForm. Students access GoogleForm, select the student's class in the list of 64 classes from a drop-down box, based on the results of the selection, GoogleForm brings to the next section the correct class of the student, the student continues to select the full name + student code in the class list from a drop-down box. The problem I am having is connecting data from GoogleSheet to GoogleForm via FormRanger to put data into the drop-down box. If I create a GoogleSheet file of 65 sheets, it cannot be connected, maybe because the data is large, I create 65 separate GoogleSheet files, there are too many files and the system continuously reports an unusual access error, after working on a few files, I have to take a break to avoid this error. Can you guys help me with a better method to do this? Thank you!

[Joseph Schmidt]

So you have 64 dropdown questions in the Google form.  If you are trying to populate a single dropdown, the limit is 999 items.

See scrpt to update a Google form.  Formranger has a problem with too many questions to be updated.

If the data doesn't change that often, just copy and paste the list.  

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

On Fri, Mar 7, 2025 at 2:27 AM Trọng Nghĩa Lưu <trongn...@gmail.com> wrote:

Hello everyone! I have a work problem that needs to be optimized, specifically as follows: My school has a total of 64 classes, 2876 students. I want to collect student information through GoogleForm. Students access GoogleForm, select the student's class in the list of 64 classes from a drop-down box, based on the results of the selection, GoogleForm brings to the next section the correct class of the student, the student continues to select the full name + student code in the class list from a drop-down box. The problem I am having is connecting data from GoogleSheet to GoogleForm via FormRanger to put data into the drop-down box. If I create a GoogleSheet file of 65 sheets, it cannot be connected, maybe because the data is large, I create 65 separate GoogleSheet files, there are too many files and the system continuously reports an unusual access error, after working on a few files, I have to take a break to avoid this error. Can you guys help me with a better method to do this? Thank you!

--
You received this message because you are subscribed to the Google Groups "NV Form Ranger Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-form-ranger-a...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/e1c4d6a0-e3a2-4e60-9c0b-761ce44c4614n%40googlegroups.com.

[Trọng Nghĩa Lưu]

Hello! I am very happy to receive your support, thank you very much, I have done part of my work. Your video tutorial is 1 sheet with more than 999 rows of data and my problem is 1 file with 64 separate sheets, each sheet has 45 rows of data. I look forward to receiving your feedback. Thank you!

Vào Th 6, 7 thg 3, 2025 vào lúc 21:27 Joseph Schmidt <glua...@gmail.com> đã viết:

To view this discussion visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/CAPWPTOS4g4pbfUaXKGaVWM1wH%3DFG4-TfH2jY0fMpJw6fdJLgCA%40mail.gmail.com.

[Joseph Schmidt]

64 questions are beyond the ability of formranger.

I shared a link with you.to build your own script.

You could also change your design. A form for each school would lower the number of classes and formranger would likely work.

You can create a document with links to each form. One link would take them to the document where they click on the correct form.

If you have nothing better to do, keep trying to get formranger to work with 64 dropdown questions.  A better use of your time would be to change your design to what you know works.

You can create your own script.

Joe Schmidt

To view this discussion visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/CAGFWW41ZEuZgT5FSLQ%3D8_EU2Pmf24MYKa9n9e1yg91epHWSptg%40mail.gmail.com.