App Icon
Form Ranger allows you to populate multiple choice, list, checkbox, and grid options from columns in any Sheet or Doctopus roster.
Works with:
10,000,000+
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.
Additional information
PricingNot available
SupportNot available
Privacy policy
Terms of service
Form Ranger will ask for the permissions shown below. Learn more
Form Ranger will need access to your Google account
This will allow Form Ranger to :
See, edit, create, and delete all of your Google Drive files
View your Google Drive apps
See, edit, create, and delete all your Google Sheets spreadsheets
Connect to an external service
Allow this application to run when you are not present
Send email as you
View and manage data associated with the application
View and manage your forms in Google Drive
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
Noel Erskine
March 4, 2020
This was a 5 star app for the old forms - works well. If you are using the new forms... it does not work as well! (You can get-- Unreliable results if it's populating too much into one question.) If you keep your form in the old format... I think you will be fine using this add-on. We are using it with the new forms and it works, but we have had to modify our form. Each question will only handle populating so many items, in our case... drop down names. So, you need to break up your questions more. For example, we have them pick a group of last names (like A-d) and then it jumps to another question/drop down that is only filled with those names via Form Ranger. (You will see how this works with the new forms. It actually pulls the data and puts it into the form as selections.) This is a must have add-on for really doing some neat things with forms and Google Sheets. (We cross reference a sheet with names that have been cleared for entrance and it populates the form so their name is in the drop down to select.) Ignore the reviews that say it does not work. It still works. This really needs to be updated, but unfortunately Andrew Stillman (The developer) has moved onto another company. PLEASE UPDATE THIS! Thanks!
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
February 14, 2018
Still one of my favorite and most used add-on! I do still wish there were alternative refresh options, or a way to trigger it with a macro in the sheet. I also wish when adding ranges, it auto-filled the name of the range from the top cell of the range, instead of having to retype that (and it'd be nice to have a spot to prepare a bunch of ranges you'll want to use, instead of only being able to do that in each question). And I also wish it wasn't such a cramped little box to work in. But still, overall, amazing and useful add-on!!
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
March 11, 2019
I love the potential for this. It works great as long as you don't have a bunch of people trying to fill the form out at the exact same time. Here's my issue... I've created a form for our students to enroll in weekly enrichment classes but we're having a problem with it creating blank fields in the spreadsheet. I think it's because multiple kids have the form open at the exact same time so they see the full list to pick from but by the time they actually click Submit, the option they've picked has filled and has been removed from the list. So it just enters a blank in the spreadsheet cell. Wondering if there's any workaround or field validation that could be added. Any ideas???
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
September 26, 2015
Not for me. I have a response where the potential responses is infinite but I wanted to see a number of times each response was repeated. This sounded like it would be a fit. Since text responses are not supported, I was unable to use.
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
October 15, 2015
It works very well for external data sources that do not change very often. However, it did not work in my application because the data source list may change in between form submissions. By this I mean... a form would have the right choices, the form would be submitted - at THAT POINT the form is repopulated, then the external list would change, then next time the form load it still has the OLD list from the external source. If this add-on queried the external source every time a form was loaded it would be PERFECT - unfortunately it does not. I understand it would increase load times for forms, but for people with dynamic external sources this really is a must to ensure the correct list items are piped into the form. Makes me sad that it doesn't query every time the form loads :(
Is this review helpful?
Yes
No
Profile Picture
Jeremy Newman
August 24, 2017
It seems to work for the most part but it does not work correctly with the "grid checkbox" option. You have to start with the "grid multiple choice" option, load the data, and then switch to "grid checkbox." Once you've done that, though, it won't update the list automatically and you have to switch it back and forth again to make the list update.
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
May 30, 2019
Have loved this in the past, but - like other users have reported - it no longer works for me! Just spins when trying to add a range.
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
July 27, 2017
The function it provides is pretty awesome. However I discovered that after sometime it stops refreshing the form. It is supposed to refresh the choices after every submit or every hour. However it wont until you open the form in the edit form and then open the add on and click manually on refresh the question.
Is this review helpful?
Yes
No
Profile Picture
Wendy Ying, DVM MS TCVMP
September 15, 2017
This would be great if it worked. I installed the add on and am trying to get it to populate a person's name from another sheet. It only works on one question with a drop down to nowhere and when i refresh, I get a spinning wheel.
Is this review helpful?
Yes
No
Profile Picture
A User of Form Ranger
June 15, 2017
Love this add on, it is super handy and is working fine for me! Would you ever consider making a version that lets you automatically create new sections (column header rows) as well as auto-populating a single question within the section (rest of data in relevant column)? This would be SO helpful for setting up forms where you want to have many 'go to section based on answer' elements set up from an existing database. Thanks so much for the wonderful add-on!
Is this review helpful?
Yes
No
1-10 of 1207
Search
Clear search
Close search
Google apps
Main menu