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
Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.
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]
I’m a public school teacher writing Apps Script projects to manage documentation and to make life easier in general. You can read more on my blog, blog.ohheybrian.com or follow me on Twitter, @bennettscience.
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
I use Google Apps Script to support staff and students in my job. I enjoy dabbling with creating tools to help with automation and I freely share my learning experiences on my blog, where I also have a number of useful Google Add-ons: www.pbainbridge.co.uk
Screenshot of template sheet with signatures to copy to other files
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
I use Google Apps Script to support staff and students in my job. I enjoy dabbling with creating tools to help with automation and I freely share my learning experiences on my blog, where I also have a number of useful Google Add-ons: www.pbainbridge.co.uk
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
I use Google Apps Script to support staff and students in my job. I enjoy dabbling with creating tools to help with automation and I freely share my learning experiences on my blog, where I also have a number of useful Google Add-ons: www.pbainbridge.co.uk
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
I use Google Apps Script to support staff and students in my job. I enjoy dabbling with creating tools to help with automation and I freely share my learning experiences on my blog, where I also have a number of useful Google Add-ons: www.pbainbridge.co.uk
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.
Source: The Gift of Script: Fixing dates from a Google Form
I use Google Apps Script to support staff and students in my job. I enjoy dabbling with creating tools to help with automation and I freely share my learning experiences on my blog, where I also have a number of useful Google Add-ons: www.pbainbridge.co.uk
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]
I’m a public school teacher writing Apps Script projects to manage documentation and to make life easier in general. You can read more on my blog, blog.ohheybrian.com or follow me on Twitter, @bennettscience.
Unit tests are for single units of code. They test a specific function for a specific result…
Part two in a series on unit testing, this configures the QUnit web application and has you write simple tests against an Apps Script class.
Source: Unit Testing GAS Part 2: Simple Tests | ohhey[blog]
I’m a public school teacher writing Apps Script projects to manage documentation and to make life easier in general. You can read more on my blog, blog.ohheybrian.com or follow me on Twitter, @bennettscience.
I’m not good at writing testable code. I’m more of a ‘figure it out when it breaks’ kind of hobby programmer. The problem with this is that I am constantly making my own bugs and not really finding them until a bad time.Unit testing is the process of running automated tests against your code…
The first post in a series, this will eventually be an in-depth look at unit testing both as a habit of writing code and through the lens of large Apps Script projects.
Source: Unit Testing GAS Part 1: QUnit Setup | ohhey[blog]
I’m a public school teacher writing Apps Script projects to manage documentation and to make life easier in general. You can read more on my blog, blog.ohheybrian.com or follow me on Twitter, @bennettscience.