App Icon
New Visions Cloudlab
•  
10,000,000+
Overview
Form Ranger allows you to populate multiple choice, list, checkbox, and grid options from columns in any Sheet or Doctopus roster.
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
Language:
Sort by:
Profile Picture
dme1 sbmpl
June 21, 2021
form ranger is not working now.
Is this review helpful?
Yes
No
Profile Picture
Nitesh Sood
June 20, 2021
I used this since 2-3 months but its is not working now to populate the data from sheet, trying a lot since so many days.
Is this review helpful?
Yes
No
Profile Picture
sukesh sukesh
June 19, 2021
Yu
Is this review helpful?
Yes
No
Profile Picture
Alifushi Council
June 19, 2021
nice
Is this review helpful?
Yes
No
Profile Picture
Md. Mosaddek Hossain
June 18, 2021
So nice
Is this review helpful?
Yes
No
Profile Picture
Data Seimpian
June 17, 2021
best
Is this review helpful?
Yes
No
Profile Picture
Thomas Hartnett
June 16, 2021
Currently not working! The app is only compiling lists with very few entries. Please fix ASAP - happy to pay for this app!
Is this review helpful?
Yes
No
Profile Pciture
Scholarship Coordinator
June 18, 2021
Yes, very limited to only limited entries on the pull-down menu. Sadly, it stopped working yesterday :(
Profile Picture
MJ Capalad
June 16, 2021
Don't do automatic updates in a timely manner. Does anyone find an alternative add-on for Form Ranger?
Is this review helpful?
Yes
No
Profile Picture
Darpan Shah
June 14, 2021
Not working .. Worked for 2 questions and then stopped. Still not able to figure it out why it suddenly stopped.
Is this review helpful?
Yes
No
Profile Pciture
IRSHAD PWMT
June 16, 2021
YES, NOT WORKING
Profile Picture
Pasaydan Sanskar Classes
June 10, 2021
It doesn't work anymore. This is why I don't like automatic updates. It was working fine and updating the field with new entries. Then it suddenly stopped.
Is this review helpful?
Yes
No
1-10 of 103
Additional information
New Visions Cloudlab
Terms of Service
Search
Clear search
Close search
Google apps
Main menu