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
A User of Form Ranger
October 19, 2020
very useful App! Thank you.
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
October 19, 2020
Nice add-on, it really helps. Thanks
Is this review helpful?
Yes
No
Profile Picture
Adam Haining
October 19, 2020
I've been using it for over a year and it works ok. I have it set to pull in changes hourly, but it doesn't seem to work. I would expect it to update it automatically, but it only updates it when I open the form and start Form Ranger. Better than doing it manually, but still I expected more.
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
October 18, 2020
Have yet to try
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
October 18, 2020
Try
Is this review helpful?
Yes
No
Profile Picture
Carin Rook
October 18, 2020
tbd
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
October 16, 2020
tbd
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
October 16, 2020
Why won't this work?
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
October 15, 2020
Will find out.
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
October 15, 2020
WCGW?
Is this review helpful?
Yes
No
1-10 of 108
Additional information
New Visions Cloudlab
Terms of Service
Search
Clear search
Close search
Google apps
Main menu