Form Ranger allows you to populate multiple choice, list, checkbox, and grid options from columns in any Sheet or Doctopus roster.
Works with:
51M+
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
Developer
Trader status unspecified
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
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
Yessiko Yolanda Dwipunopanen
July 20, 2023
This is great tools. Unfortunately, it seem limited by 1000 row of data. Developer, hope you help please for this issue
Is this review helpful?
Yes
No
Profile Picture
Mohammad Alali
July 12, 2023
when I add new row to questions and successfully and make new response ( it will create new rows in forms response sheet ) , i would like to add only the row I added , could please how tell me how can i did this
Is this review helpful?
Yes
No
Profile Picture
Mission Brain IWZ
May 4, 2023
The add on is really of great help! I had a question regarding how can we get more than two options N/A after the limit has been reached? I tried but only one option is changing to N/A after the limit crosses and others are still visible even though the limit has been reached. If someone could help out, it would be much appreciated. Thankyou!!
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
Profile Picture
Anamika Saini
September 12, 2023
Clearly this plug in doesn't work anymore. Is there an alternative anyone has figured?
Is this review helpful?
Yes
No
Profile Picture
Adit GCM
June 29, 2023
doesn't work. shows 404 page upon clicking "complete setup"
Is this review helpful?
Yes
No
Profile Picture
Husein J
May 7, 2023
All my existing playlist saved in youtube overwritten. Please advice how do i get it back. 100s of my saved videos and playlist gone.
Is this review helpful?
Yes
No
Profile Picture
Dustin Simmons
July 4, 2023
Doesn't work. Installation shows a 404 error. Unusable
Is this review helpful?
Yes
No
Profile Picture
Barrett Knox
March 29, 2023
It has been working great. It stopped working the other day. Won't update. I will update if it changes.
Is this review helpful?
Yes
No
Profile Picture
Chris Ruiz de Velasco
March 28, 2023
Idea is great. Installed but will only shows "help" with no start option when I try to use it. Maybe the review will help like below. - update: works after the review. Instant fix for some reason.
Is this review helpful?
Yes
No
1-10 of 1196
Search
Clear search
Close search
Google apps
Main menu