New Visions Cloudlab
•  10,000,000+
Overview
Form Ranger allows you to populate multiple choice, list, checkbox, and grid options from columns in any Sheet or Doctopus roster.
Form Ranger allows you to auto-populate the choices in list, multiple choice, checkbox or grid question options from columns of data in any Google Sheet or Doctopus roster.

Great for ensuring form choices match values in an existing database of records, such as students, inventory items, expected attendees, workshop or session titles, etc. -- useful for then applying matching formulas such as COUNTIF, VLOOKUP, MATCH, and others.

Can be set to repopulate options on form submit -- opening the possibility of (somewhat) dynamic form options provided you are willing to explore spreadsheet formulas.  For example, use spreadsheet formulas like IF and COUNTIF in the form spreadsheet to produce a "shrinking" list of options with availability.  Likewise, produce a "growing" list of checkbox options by applying the UNIQUE formula to a list of open-ended submissions, leaving the "other" checkbox option turned on.

For users of the popular Doctopus Add-on for sheets, Form Ranger includes rosters (student name lists) automatically.
Reviews
Language:
Sort by:
Profile Picture
A User of Form Ranger
July 10, 2020
There's only the two options to update hourly or after each response. Why not before the form is actually loaded? My form will be used once in a month or so - hourly updates are way too often, but _after_ someone actually posts something doesn't make any sense. Also, FormRanger defines named ranges, but these are only known to itself, the sheet does not seem to know it as a named range. I created a named range in the sheet and used that in Form Ranger, and that seems to work. So - great idea and many thanks for doing it. Please add update on form load, if you can make it.
Is this review helpful?
Yes
No
Profile Picture
Camilo Reyes
July 10, 2020
It was working fine and suddenly stop working as usual. sometimes upgrade the answers sometimes not. Brokes link with the spreadsheet. etc, etc. Put a price on it and make it works.
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
July 9, 2020
ok
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
July 8, 2020
Useful add-on
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
July 8, 2020
I am signing in to all of the add-ons to see which one was mistakenly deleted so I can continue working in Google Docs!!!
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
July 8, 2020
Isn't working
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
July 6, 2020
Very helpful usually, however lately, I can't find the sheets in my drive from which to select the range (I get an incomplete list of sheets from my drive)
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
July 6, 2020
Sir its not updating automatically. Please help how is to be managed . Thanks
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
July 2, 2020
good
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
July 2, 2020
When it works, it works. When it doesn't it doesn't. Currently the option to use it has disappeared, but before that the survey form I had set up yesterday - which worked perfectly - doesn't display any of the names today. I can just see the *help* option in my plugins. I'm testing it out now to see if it can work on several surveys at the same time.
Is this review helpful?
Yes
No
1-10 of 103
Additional information
New Visions Cloudlab
Terms of Service
Search
Clear search
Close search
Google apps
Main menu