Form Fill

Overview

This add-on can create shortened prefilled links to Google Forms in bulk based on data inputted into a Google Sheet. Each row represents a potential response, and the links generated will have the information already filled into the form. The add-on also creates QR codes that are easily printable for distribution.

Instructions

1. Pick a Google Form and select which questions in the form you would like to prefill.
2. Add your prefilled response data to Google Sheets. Form Fill automatically created shortened links for the responses.
3. Create printable QR codes to share

Attribution

Links and attribution for code from external sources used in this app:

• Material Design Lite - Copyright Google, 2015. Licensed under an Apache-2 license.

• jQuery - Copyright JS Foundation and other contributors, https://js.foundation/. Licensed under the MIT License (MIT).

• jQuery UI - Copyright JS Foundation and other contributors, https://js.foundation/. Licensed under the MIT License (MIT).

• mdl-stepper - Copyright Alexandre Thebaldi, 2016. Licensed under the MIT License (MIT).

• material-loading - Copyright, 2017. Licensed under the MIT License (MIT).

Additional References

Programmatically prefilling Google Forms

Google Drive File Picker

Making jQuery UI Sortable Accessible