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
Matra MS3
April 16, 2021
It's very great.
Is this review helpful?
Yes
No
Profile Picture
loke meng ong
April 4, 2021
Form Ranger worked well in the beginning and eliminating the choice once the registered has reached the capacity. However this has stopped working and the choices are not eliminated even though reference column in Google sheet showed that the choice has been eliminated. Is there are way to fix this? Thanks.
Is this review helpful?
Yes
No
Profile Picture
Ramlal Durgadutt & Co.
April 4, 2021
it is great
Is this review helpful?
Yes
No
Profile Picture
Liton Roy
April 4, 2021
It is great
Is this review helpful?
Yes
No
Profile Picture
Jim Homme
March 31, 2021
Huge time-saver. Great if you want to avoid scripting.
Is this review helpful?
Yes
No
Profile Picture
Hemant Bapurao Babar
March 29, 2021
i cant find ranger name
Is this review helpful?
Yes
No
Profile Picture
Evan La Zarr
March 24, 2021
horibiltactic
Is this review helpful?
Yes
No
Profile Picture
Bill Fleming
March 24, 2021
Can't figure out how to use it yet.
Is this review helpful?
Yes
No
Profile Picture
Zeqry Danial Muzamil Zuraidy
March 22, 2021
I can't find the start button in my google forms. I suspect it to be due to not doing the additional setup, but I can't even connect to the URL for the additional setup :(
Is this review helpful?
Yes
No
Profile Picture
Franz Widjojo
March 19, 2021
just the app that i'm looking for, now i can make a ticket box with ease, you just need to know some excel function and you are good to go. suggestion: please add auto populate in notes, so we can just display the latest information taken from the spreadsheet. Thank you New Visions Cloudlab!
Is this review helpful?
Yes
No
1-10 of 103
Additional information
New Visions Cloudlab
Terms of Service
Search
Clear search
Close search
Google apps
Main menu