Limit of Form Ranger

629 views
Skip to first unread message

Minu Saree

unread,
Oct 12, 2023, 8:47:00 AM10/12/23
to NV Form Ranger Add-on
To the estimable effendi,

I'm suffering to populate more than 1000 options through "Form Ranger" from Google Sheet to a Drop Menu in a Google Forms. "Form Ranger" is smoothly populating more than 100 options while particular column contains more than 1000 of instances.

Is there any way out ? Or is there any highest limit of Form Ranger ?

Please help if it's anyway possible.

Thanks & Regards,
Roy

Joseph Schmidt

unread,
Oct 12, 2023, 9:08:34 AM10/12/23
to nv-form-ra...@googlegroups.com, NewVisions CloudLab (via Google Docs), Amanda Smith
The 1000 entries seems to be a limit of FormRanger and not the Google Form.

The only option I know is to break the question into two parts. A-K and L-Z or whatever break splits the entries into two groups.

It will require a branch question and three sections in the form.





--
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 on the web visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/59fd3dce-0464-423e-bc8d-9a30f9ec52c3n%40googlegroups.com.

Joe Schmidt

unread,
Oct 22, 2023, 10:22:44 PM10/22/23
to NV Form Ranger Add-on
See Script to update a form

Joseph Schmidt

unread,
Oct 23, 2023, 8:08:53 AM10/23/23
to nv-form-ra...@googlegroups.com, NewVisions CloudLab (via Google Docs)
I'm sorry but on further testing, I could not update more than 999 items with this script.  

That indicates that it is not something that NewVisions can fix but that Google has to change.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/63bf412a-c9d3-48f8-96d1-50e542db8006n%40googlegroups.com.

Joseph Schmidt

unread,
Oct 23, 2023, 8:09:16 AM10/23/23
to nv-form-ra...@googlegroups.com
I'm sorry but on further testing, I could not update more than 999 items with this script.  

That indicates that it is not something that NewVisions can fix but that Google has to change.



G PS

unread,
May 4, 2024, 1:03:23 PM5/4/24
to NV Form Ranger Add-on
Form Ranger does not accept any column that contains duplicate values or unique values more than 999 rows.
if there is any other add-on to allow duplicate and unlimited values in a column then pls inform.

Joseph Schmidt

unread,
May 5, 2024, 3:16:32 PM5/5/24
to nv-form-ra...@googlegroups.com
I don't understand the need to allow duplicates.  How do you know which one they chose.  It is not hard to remove duplicates.

You can set up multiple questions if you have more than 999 entries.

I don't know of any other add-on like Formranger,
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/99230e05-778c-4b6a-8fc0-b87871a446e2n%40googlegroups.com.
Reply all
Reply to author
Forward
Message has been deleted
Message has been deleted
0 new messages