In this episode of Sheets to Apps, see why it can be handy to use a Google Form to help requestors receive assets like e-books or online white papers automatically by email using Apps Script.
Stripe payment code integrated into Google Apps Script
Regular Google Apps Script community contributor Alan Wells has provided example Apps Script code with different examples of Stripe payment integration.
Update: Alan had published the source code to GitHub
Source: Stripe payment system – client version v3 – Apps Script integration
Unit Testing in GAS Part 4: Error Handling | ohhey[blog]
Up until now, our
Calcsclass has handled errors with simpletrueandfalseflags. That’s not helpful to the user. At this point, we’re ready to begin defining and testing custom errors in our functions.
QUnit allows a throws method which can check for errors in your application. This tutorial post adds some error checking to a simple Apps Script project.
Source: Unit Testing in GAS Part 4: Error Handling | ohhey[blog]
Apps Script for SEOs
Notes for “Google App Scripting for Automating SEO Tasks” by @dsottimano
— Eric Wu ❤️💐 (@eywu) December 4, 2019
We can scrape Google SERPs and then process that data all within familiar Google Sheets to automate many of the tedious or hard tasks that take hours or days. Just with a little #JavaScript#TechSEOBoost pic.twitter.com/Lg1ExgGz3A
Get weekday name from a date
Take a date and extract the day of the week from it. By making use of ‘formatDate’ and the pattern ‘EEEE’ within a few lines of code we have a workable week-day name that could be used in an if statement as discussed in the previous post.
Source: The Gift of Script: Get weekday name from a date – alternative
Copy template sheet to Google Sheets and reorder
Take a template Google Sheet (containing fields for 3 signatures) and copy it into other Google Sheet files within a given Google Drive folder and then reorder those sheets so that it was the first one.
The idea was based around needing users to authorise student marks with their signature from multiple Google Sheet reports produced from a third party system.
Source: The Gift of Script: Copy template sheet to Google Sheets and reorder
Dynamically remove Google Form options
This was developed as I wanted to learn about removing Google Form option choices as part of exploring its capabilities for use with appointment slots. I am aware there are a number of Google add-ons that achieve this but they come with potential data protection issues when accessing your Google Account, hence an in-house approach.
The principle is simply that a user would select their desired appointment slot on the Form and then that option would be unavailable for the next user accessing the Form.
Source: The Gift of Script: Dynamically remove Google Form options
Batch get existing Google Drive folder IDs & names
Get the folder IDs of a large number of current Google drive folders along with parts of their name – for capturing in a Google Sheet.
Source: The Gift of Script: Batch get existing folder IDs & names – version 2.0
Fixing dates from a Google Form
For those getting a ‘date’ from a Google Form and finding that it flips the day/month the wrong way around. This small piece of code can be inserted to create a correct date format.
Unit Testing GAS Part 3: Adding and Testing Functions | ohhey[blog]
We’ve looked at how to install and configure QUnit and just finished writing some simple tests. In this post, we’re going to write a new method,
add(a, b)inCalcswhich will add the two passed parameters.
Part 3 in the unit testing series, this post looks at writing tests for new methods and some considerations for when (or when not) to use private functions in Javascript when it comes to testing.
Source: Unit Testing GAS Part 3: Adding and Testing Functions | ohhey[blog]