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:
A User of Form Ranger
April 2, 2020
Very Useful.
Is this review helpful?
Yes
No
A User of Form Ranger
April 2, 2020
FIRST I USE AND THEN I WILL SUBMIT MY REVIEW
Is this review helpful?
Yes
No
A User of Form Ranger
April 1, 2020
thank you for the apps
Is this review helpful?
Yes
No
A User of Form Ranger
April 1, 2020
Useful apps
Is this review helpful?
Yes
No
A User of Form Ranger
March 30, 2020
Sometimes, the list won't auto update. I must re-open Form Ranger when updating list
Is this review helpful?
Yes
No
A User of Form Ranger
March 30, 2020
i will try it
Is this review helpful?
Yes
No
A User of Form Ranger
March 30, 2020
I'm gonna try this add-on for the first time. hope succeed.
Is this review helpful?
Yes
No
A User of Form Ranger
March 29, 2020
Excellent
Is this review helpful?
Yes
No
A User of Form Ranger
March 27, 2020
Works incredibly well and saves me hours of tedious work.
Is this review helpful?
Yes
No
A User of Form Ranger
March 26, 2020
This hung for 5 minutes to import a 45-row, 3-column spreadsheet from drive. Gave up. Doesn't work for me!
Is this review helpful?
Yes
No
1-10 of 101
Additional information
New Visions Cloudlab
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu