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
Emmanuel Baptist Church
May 6, 2021
Great app! Saved so much time!
Is this review helpful?
Yes
No
Profile Picture
Hendrik van der Bijl Primary School
May 5, 2021
I install it but when I go to continue install I get '404. That’s an error. The requested URL was not found on this server. That’s all we know.'
Is this review helpful?
Yes
No
Profile Picture
John Zadrozny
May 4, 2021
Not sure just got it
Is this review helpful?
Yes
No
Profile Picture
Shelley V
May 3, 2021
For some reason, after I select the sheet it's not allowing me to select a range. This is very frustrating. I cleared my caches and I'm still not able to move forward.
Is this review helpful?
Yes
No
Profile Picture
Mr. McClellan
May 3, 2021
Looks like it will save me a lot of time
Is this review helpful?
Yes
No
Profile Picture
Natasha Njenga
May 3, 2021
Cant seem to open the app
Is this review helpful?
Yes
No
Profile Picture
Kelvin富源承忠
May 2, 2021
This had been an automation tools I've been utilizing for years. TO DEVELOPER: May I ask if there is an option to call images from either image source URL or in cell images?
Is this review helpful?
Yes
No
Profile Picture
Nikhil
May 1, 2021
hi lets sww it id works ok why
Is this review helpful?
Yes
No
Profile Picture
Abisola Megbope
April 30, 2021
it better work so i can use it
Is this review helpful?
Yes
No
Profile Picture
Emergency Medicine KMC, Manipal
April 30, 2021
Just Installed. yet to try out. sounds good though
Is this review helpful?
Yes
No
1-10 of 104
Additional information
New Visions Cloudlab
Terms of Service
Search
Clear search
Close search
Google apps
Main menu