Help & Support
Send Feedback
Form Ranger
Form Ranger allows you to populate multiple choice, list, checkbox, and grid options from columns in any Sheet or Doctopus roster.
10,000,000+ users
Works with
Install
Overview
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
A User of Form Ranger
February 16, 2020
no clue
Submit reply
Cancel
A User of Form Ranger
February 16, 2020
So far so good
Submit reply
Cancel
A User of Form Ranger
February 15, 2020
don't make someone review something before even being allowed to use it
Submit reply
Cancel
A User of Form Ranger
February 15, 2020
Like it just because i have been forced to like
Submit reply
Cancel
A User of Form Ranger
February 14, 2020
Writing a review before I can get it to respond! Seem like it doesn't work
Submit reply
Cancel
A User of Form Ranger
February 13, 2020
Excellent. I've been using it so far and it's great!
Submit reply
Cancel
A User of Form Ranger
February 13, 2020
Testing
Submit reply
Cancel
A User of Form Ranger
February 13, 2020
abruh
Submit reply
Cancel
A User of Form Ranger
February 12, 2020
Why am i being asked to rate this before using it??
Submit reply
Cancel
A User of Form Ranger
February 12, 2020
not a big fan of having to rate something before you use it!
Submit reply
Cancel
1-10 of 116
Additional information
Search
Clear search
Close search
Google apps
Main menu