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.
9,261,850 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
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
October 6, 2019
haven't used it yet...
Submit reply
Cancel
A User of Form Ranger
October 6, 2019
strange requirement but looks good
Submit reply
Cancel
A User of Form Ranger
October 3, 2019
Looks like the functionality is excellent, but I am having a difficult time starting the add on.
Submit reply
Cancel
A User of Form Ranger
September 27, 2019
LET ME USE IT FIRST THEN I WILL GIVE FEEDBACK
Submit reply
Cancel
A User of Form Ranger
September 16, 2019
This is a really great tool, however the "Auto-repopulate questions" function stopped working recently. One has to automatically click "Update Question List". Please fix this bug!
Submit reply
Cancel
A User of Form Ranger
September 10, 2019
This works well, I am using it to populate an inventory list as well as a shopping list from Google Sheets. It would be cool if we could also do short answers or paragraph with this option. Maybe something to look into??
Submit reply
Cancel
A User of Form Ranger
February 5, 2019
Extremely useful in principle. Unfortunately the "Auto-repopulate questions" function does not work. Also, when clicking on "Update question list", the lists are not re-populated with the new version. Temporary Active User Key: AIJTlf82cTppmVcz9XbuTAI+da49XWqIouxW84QPBTYlCGKYQnF1A+JIBXnlildsiidPlyghB99f
Submit reply
Cancel
1-10 of 28
Additional information
Search
Clear search
Close search
Google apps
Main menu