Form Ranger allows you to populate multiple choice, list, checkbox, and grid options from columns in any Google Sheet™ or Doctopus roster.
By:
Listing updated:April 10, 2024
Independent security verification
Works with:
56M+
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
PricingFree of charge
Developer
Non-trader
Support
Privacy policy
Terms of service
ReportFlag as inappropriate
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
View and manage your forms in Google Drive
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
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Jason Schapansky
June 24, 2024
it quit working, it was working good up until now...
Is this review helpful?
Yes
No
Profile Picture
Cassie Williams
September 12, 2024
This was a great extension but doesn't seem to work anymore. Is there a plan to fix it?
Is this review helpful?
Yes
No
Profile Picture
Tim Trainer
June 26, 2024
Add-on seems not to work anymore sind a few weeks. I updated form questions based on various google sheets periodically. Does not work any longer. So I switched to Dynamic Fields add-on. You have to pay for the premium version but it works for my use case and you get support if you have a problem.
Is this review helpful?
Yes
No
Profile Picture
Brandon and Nicole Bolen
July 2, 2024
This doesn’t work.
Is this review helpful?
Yes
No
Profile Picture
Gary C
June 23, 2024
Stopped working. Been using this for years without issue. Very disappointing.
Is this review helpful?
Yes
No
Profile Picture
Michael Cancell
December 10, 2023
It really doesnt work properly. Even if you have the "Refresh After Submit", new entries will not show in the list. You can force the list to refresh by starting Formranger in the form edit. But of course this defeats the purpose of auto updates. It's free, so beggers can't be choosy, but still, it's not very good.
Is this review helpful?
Yes
No
Profile Picture
Said Tojiboev
June 12, 2024
it does not work
Is this review helpful?
Yes
No
Profile Picture
Hendra
June 25, 2024
it stop working, Been using this for years without issue.why?
Is this review helpful?
Yes
No
Profile Picture
Oekyo Klub
June 24, 2024
Does anybody know if the service would be restored or not?
Is this review helpful?
Yes
No
Profile Picture
Mike Posey
June 17, 2023
What was once a great tool has sucked for some time now. Currently just doesn't work at all. Literally completely useless.
Is this review helpful?
Yes
No
1-10 of 375
Search
Clear search
Close search
Google apps
Main menu