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
M Ward
November 23, 2020
Will Update on use of system
Is this review helpful?
Yes
No
Profile Picture
Kevin Allen
November 22, 2020
do not know. have not used yet.
Is this review helpful?
Yes
No
Profile Picture
JSG LLC
November 22, 2020
Very good
Is this review helpful?
Yes
No
Profile Picture
TAI KIAT YING Moe
November 22, 2020
haven try it, review later.
Is this review helpful?
Yes
No
Profile Picture
Tara Penney
November 21, 2020
looks promising!
Is this review helpful?
Yes
No
Profile Picture
My Electrical World
November 21, 2020
GOOD
Is this review helpful?
Yes
No
Profile Picture
Lynne Maccaulay
November 20, 2020
I'd prefer to use it a little before I rate it... But I'll update my response as needed.
Is this review helpful?
Yes
No
Profile Picture
Jenifer Shipley
November 20, 2020
Just installed it. We will see how well it works for what I need.
Is this review helpful?
Yes
No
Profile Picture
Thomas Kadelbach
November 20, 2020
Wow!! We set up a complex implementation using FormRanger and it worked wonderfully. Thank you so much for making this extension!!! Saved our secretary a week of answering parent phone calls to set up Student Led Conferences.
Is this review helpful?
Yes
No
Profile Picture
Wen Sun
November 20, 2020
Ok. I haven't tried yet.
Is this review helpful?
Yes
No
1-10 of 110
Additional information
New Visions Cloudlab
Terms of Service
Search
Clear search
Close search
Google apps
Main menu