App Icon
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
SONG YU
January 27, 2021
good
Is this review helpful?
Yes
No
Profile Picture
AZIZAN BIN HAD -
January 26, 2021
Good one
Is this review helpful?
Yes
No
Profile Picture
Victoria Cano
January 26, 2021
The app just keeps loading and loading...
Is this review helpful?
Yes
No
Profile Picture
Charisse Nicole Aberin
January 25, 2021
Still not trying it. will get back after using and analyzing this app.
Is this review helpful?
Yes
No
Profile Picture
SUHAIMI BIN ISA Moe
January 22, 2021
good add on. but i have a problem. i use this add on for eliminate some dropdown list question. every question have unique (go to section based on answer) but when form ranger repopulate again that question, section based on answer go to default (mean next section). not section i have select before.
Is this review helpful?
Yes
No
Profile Picture
Justin Fox
January 22, 2021
Form Ranger is AWESOME! We use multiple forms with sections that populate from a class roster. Update one master roster and each form is updated as well. Saves me a ton of time. Much appreciated, New Visions Cloudlab!
Is this review helpful?
Yes
No
Profile Picture
Brian Ferguson
January 22, 2021
LOVE the add on. I was using choice eliminator and was constantly let down. However, one quirk I have found is that when I am pulling a time list from titles, my list all has AM and PM beside the time. For some reason 10:00:00 AM never pulls the AM to my form list.
Is this review helpful?
Yes
No
Profile Picture
Rolroorlo
January 20, 2021
With this, YOU CAN MAKE MAGIC (anything you can do in sheets but for forms) kind of
Is this review helpful?
Yes
No
Profile Picture
Admin Account
January 17, 2021
cool
Is this review helpful?
Yes
No
Profile Picture
muhammad hamdani
January 17, 2021
good
Is this review helpful?
Yes
No
1-10 of 102
Additional information
New Visions Cloudlab
Terms of Service
Search
Clear search
Close search
Google apps
Main menu