Google Apps Script is a JavaScript platform that provides easy ways to integrate with and automate tasks across Google products.
Google Apps Script is a JavaScript platform that provides easy ways to integrate with and automate tasks across Google products.
Customer Reviews
Administrator in Internet
Advanced user of Google Apps Script for G SuiteI love that it is free and open to anyone. It, obviously, integrates perfectly with Google Forms to do almost anything you'd like with the results. It is seamless and runs very quickly. It is an impressive way to power-up your forms and create personalized or custom resources.
There is a decent amount of support out there, as well, on Stack Overflow and other sites.
Google Script is a bit different than Javascript. Not all functionalities are recognized, and the format of responses sometimes make setting up arrays or using certain functions tricky. I had to do a lot of editing and researching to convert my "normal" code to work in Google. Even a more experienced coder had a hard time understanding the structure of the objects and other items.
Enlist the help of a professional coder to navigate the differences in language, if you can.
Also, as you are learning it, definitely set up a test form with just a few questions so that you can test your code quickly (you can't run it within the code editor). You can use the 'pre-fill link' for a quick test.
I've used it to take responses, put answers into a Google Doc template, save and send a copy (PDF) to the respondent. This has allowed me to create personalized results for users and create a more valuable offering because of that. It is impressive, too! I use this for both free opt-ins on my site as well as part of a paid product.