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
December 6, 2019
its not auto repopulate immediately if i delete all the old responses from my sheets.
Submit reply
Cancel
A User of Form Ranger
December 4, 2019
Is there a bug? When I clicked on the icon after installing it, it just kept loading. even after 15 min. It used to work ok in the beginning of the year, but I can't get it to work now.
Submit reply
Cancel
A User of Form Ranger
November 15, 2019
I haven't used it yet but it if it does what it says, it looks good!
Submit reply
Cancel
A User of Form Ranger
November 11, 2019
Very useful app. One thing the devs might consider is adding an expiration date to the refresh settings. If you use this broadly enough, keep making new forms, and never go back to turn them off, it eats up your account’s data usage.
Submit reply
Cancel
A User of Form Ranger
November 11, 2019
Good for form that has selection like class day, workshop day. Really help in collecting data.
Submit reply
Cancel
A User of Form Ranger
November 7, 2019
nice
Submit reply
Cancel
Kanfo Technology Jayul Bhagat
October 9, 2019
I USED IT BUT ITS TOO SLOW TO REFLECT DATA OF ONE SHEET TO GOOGLE FORM
Submit reply
Cancel
A User of Form Ranger
October 9, 2019
Works great, until you share the sheet it is attached too. Any changes to who can view the associated sheet will cause the program to stop updating with submissions.
Submit reply
Cancel
A User of Form Ranger
October 7, 2019
this app is a rip off of google forms and I haaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaate it
Submit reply
Cancel
A user of Form Ranger
November 16, 2019
Bruh... This is not a rip off, it is free, and It is just an add on to google forms.
A User of Form Ranger
October 6, 2019
haven't used it yet...
Submit reply
Cancel
A user of Form Ranger
October 20, 2019
if you haven't used the app how can you rate it?
1-10 of 65
Additional information
Search
Clear search
Close search
Google apps
Main menu