Most of the time, when I write Google Scripts that address a Google Form, I almost always access the data through the spreadsheet of responses. But sometimes, getting back to the Form itself is necessary. In those cases, I use this code to access the final response. It’s not quite as simple as it seems.
The script below accesses the last response to a form, gets the email, timestamp, and answers and then adds them to a Google Sheet.
SCENERIO: You are admin of a G-Suite set up. You upload training videos for your organization members on Google Drive/Team Drive. To increase productivity, you want to ensure all members watch the videos you upload.
SOLUTION: You utilize this amazing GSuite Reports API and use Google Sheets as your dashboard to view all details about your MP4 videos.
The app benefits from Google App Maker to authenticate the user, create a responsive application that allows the visualization of good practices in the form of cards. …Â Access is secure and restricted to a small group of users via a Google Group.
Google Sheets is great out of the box, but can be even more powerful if you use Google Sheets scripts to enhance its capabilities.
Always nice to see Google Apps Script getting some publicity in the general tech news. In this post on makeuseof.com some basic Google Apps Script functionality is highlighted in particular highlighting how “productivity is the secret to productivity success”
Recently during a consultation I was asked if it would be possible to check if the date submitted on a Google form was over a month ago, to which I responded “sure …”.
Admittedly this was a lot more difficulty than I thought it would (and should) be – I was bamboozled by online forums and posts suggesting to convert dates into numbers and perform other incoherent functions to achieve this. Eventually however I came across the single JavaScript function that I would need to achieve this feat …… ‘getMonth’.
The following Google Apps Script code is from some recent learning I have been doing when asked about locking-down certain areas of a sheet. I knew of named ranges and protecting cells but not quite that it could be done with apps script.
SpreadAPI is a free Google Apps Script that allows you to add REST API to any spreadsheet in Google Sheets in a few minutes. The API can be accessed over HTTPS from back-end as well as front-end apps.
It’s currently possible to publish a Google Sheet as JSON to get the data in a third-party application, but it’s harder to allow for posting new data back to that sheet. SpreadAPI is a script that creates a full-function REST API for a Google Sheet. Each implementation is set up individually and provides multiple authentication methods for specific users or even anonymous users.
I’ll start this tutorial by admitting you shouldn’t actually use Google Sheets as your CMS for a production level site or project. However…
