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
Michael White
November 27, 2020
I can not seem to get step 2 to work and it doesnt want to communicate with google forms.
Is this review helpful?
Yes
No
Profile Picture
Dr. Vasi Shaikh
November 27, 2020
Good one
Is this review helpful?
Yes
No
Profile Picture
mubarak hamid
November 26, 2020
thank appreciated it really good work I like thanks again
Is this review helpful?
Yes
No
Profile Picture
Career Guidance
November 26, 2020
Great applicaion
Is this review helpful?
Yes
No
Profile Picture
Cristine El Jawhary
November 26, 2020
Get add on to use for the spreadsheet.
Is this review helpful?
Yes
No
Profile Picture
Alex Gabl
November 25, 2020
Don't understand step 2
Is this review helpful?
Yes
No
Profile Picture
Joshua MacFall
November 25, 2020
How am I supposed to review it before using it?? Strike one.
Is this review helpful?
Yes
No
Profile Picture
Seongahn Church
November 25, 2020
seems good. will see how it works really
Is this review helpful?
Yes
No
Profile Picture
Mahbub Khan
November 24, 2020
stuck at step 2. what is exactly "Complete additional setup"?
Is this review helpful?
Yes
No
Profile Picture
Drake Asberry
November 24, 2020
Requires review as step 2 of 2 before use.
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