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
Dominique Geocaris
December 2, 2020
Haven't used it yet...still trying to configure but forced to review prior to use.
Is this review helpful?
Yes
No
Profile Pciture
Dominique Geocaris
December 2, 2020
Sadly I cannot get the extension to work. Uninstalling and done wasting time.
Profile Picture
Academia MoRENet
December 1, 2020
Looks great. Not used but hope will do best.
Is this review helpful?
Yes
No
Profile Picture
Marketing Training
December 1, 2020
Hoping this works! I will do my best to update my review once I try the add-on
Is this review helpful?
Yes
No
Profile Picture
Stephani deRouen
December 1, 2020
Hoping this works! I will do my best to update my review once I try the add-on.
Is this review helpful?
Yes
No
Profile Picture
Carla Marchione
December 1, 2020
haven't used yet but excited to try.
Is this review helpful?
Yes
No
Profile Picture
Avishay Friedler
December 1, 2020
great!!!
Is this review helpful?
Yes
No
Profile Picture
Justin Throned
December 1, 2020
I am excited to try this!
Is this review helpful?
Yes
No
Profile Picture
Nikhil Agrawal
December 1, 2020
Not willing to give review
Is this review helpful?
Yes
No
Profile Picture
Darryl Oliver
December 1, 2020
Seriously?
Is this review helpful?
Yes
No
Profile Picture
joxrono joxrono
December 1, 2020
Useful app
Is this review helpful?
Yes
No
1-10 of 112
Additional information
New Visions Cloudlab
Terms of Service
Search
Clear search
Close search
Google apps
Main menu