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
Rusty Nevins
October 30, 2020
Says additional step is needed to finish setup but takes me back to the marketplace page and no further instruction. Hoiping that posting a review is the key and if this works will update my star rating accordingly.
Is this review helpful?
Yes
No
Profile Picture
Emad Bajrai
October 30, 2020
Great and Useful add on
Is this review helpful?
Yes
No
Profile Picture
Daniele Maddaluno
October 29, 2020
Super
Is this review helpful?
Yes
No
Profile Picture
Leah Taylor
October 29, 2020
Can't get it started - additional setup required but no idea what! Adding a review (suggested by others having the same problem) didn't work for me.
Is this review helpful?
Yes
No
Profile Picture
Aaron Lester Yabut
October 28, 2020
Prompts additional setup needed but the link only redirects me to google marketplace page
Is this review helpful?
Yes
No
Profile Picture
Dan Firmalino
October 28, 2020
trying to learn it
Is this review helpful?
Yes
No
Profile Picture
GANGA UMA A/P V.NADARAJAN Moe
October 28, 2020
installing again as previously hang
Is this review helpful?
Yes
No
Profile Picture
corpsec corp
October 28, 2020
Not working at all..useless
Is this review helpful?
Yes
No
Profile Picture
Haydi Baswedan
October 28, 2020
you amazing
Is this review helpful?
Yes
No
Profile Picture
Navrachana University Vadodara
October 27, 2020
Not able to locate.
Is this review helpful?
Yes
No
1-10 of 101
Additional information
New Visions Cloudlab
Terms of Service
Search
Clear search
Close search
Google apps
Main menu