AppsScriptPulse

Snippet, Beginner, Gmail

[Solved] Inline images break when embedded from the htmlBody of an existing Gmail draft

Tags:
| | 0 Comments |

Handy snippet from Andras Sztrokay to handle inline images when using Gmail draft messages as part of your script projects. As highlighted by Romain Vialard in the Google Apps Script community:

Google added the ability to easily retrieve the inline images in an existing draft via the getAttachments() method on October 30, 2018 (see Apps Script release notes)

Source: Inline images break when embedded from the htmlBody of an existing draft [GmailApp] [Apps Script]

Solutions, Gmail, Sheets, Web App, Beginner

Tracking Email Opens with Gmail, Sheets, and Apps Script

Tags:
| | 0 Comments |

This walkthrough will let you build a tracker for email opens using Gmail, Google Sheet, and Google Apps Script.

Interesting solution that popped up in the Google Apps Script community for logging email opens using Google Apps Script. The post includes a detailed walkthrough for setting this up as well as some caveats about reliability.

Source: Tracking Email Opens with Gmail, Sheets, and Apps Script

Solutions, Sheets, Beginner

Introducing LASTEDIT(), a Timestamp Formula for Google Sheets

Tags:
| | 0 Comments |

“When was the last time this sheet was uploaded?” Probably one of the biggest requests I get is how do I add a timestamp to check when some particular range was changed. Well, [here] is a simple function you can add to your Google Sheets doc to add the formula LASTEDIT()

The question of recording when a cell/range has been edited has landed in my inbox before. I’ve not tested this solution myself but from the scan of the script worth noting that this solution will only work on one cell array per Google Sheet, so some modification might be required if you have more than one range you’d like to monitor.

Source: Introducing LASTEDIT(), a Timestamp Formula for Google Sheets

Library, New IDE, Solutions, Beginner

Google Apps Scripts Libraries — How to set them up and turn Slack into a real-time logging platform

Tags:
| | 0 Comments |

This post shows how to setup Libraries in Google Apps Scripts to share code and functions. We will use this while using Slack for logging.

Nice post from Matt “Rudy” Benton on using libraries in your Apps Script projects to make it easier to share code/credentials. Matt illustrates this with a Slack app that has also been documented.

Source: Google Apps Scripts Libraries — How to set them up and turn Slack into a real-time logging platform

Snippet, V8, Beginner, Sheets

Setting Alternate Background Colors for Rows in Google Spreadsheet using Google Apps Script

Tags:
| | 0 Comments |

This is a sample script for setting alternate background colors for rows in Google Spreadsheet using Google Apps Script.

It has already been known when the conditional formatting rule and custom function are used, this can be simply achieved. In this report, I would like to introduce the method for using Google Apps Script.

Source: Setting Alternate Background Colors for Rows in Google Spreadsheet using Google Apps Script

Solutions, Web App, Beginner

Synchronous Class Dashboard with Apps Script – a personalized online interactive classroom

Tags:
| | 0 Comments |

Andy Rundquist has created (and released as open source!) a synchronous class dashboard built entirely out of Apps Script.

As my school went mostly online last spring, I started collecting my thoughts about what I really wish I had for an online platform to work with my students. I quickly realized that my dream of all videos on and fully interactive students 1) wasn’t as good as I thought, and 2) didn’t happen because many students couldn’t or wouldn’t make use of video. I began to realize that video is the dominant feature in things like Zoom and Google Meets. It gobbles up nearly all of the screen space and is responsible for nearly all the bandwidth. So I started to consider what I might be able to do if I just stopped using video.

So I set out looking for ways to build in collaborative tools like whiteboards and understanding checks that would make better use of screen space. This is the result.

https://github.com/arundquist/synchronous-dashboard-with-jitsi

Andy’s full project is on GitHub is worth checking out.

Solutions, Drive, Forms, V8, Beginner

How to Move Files Uploads from Google Forms to a Specific Folder in Google Drive – Digital Inspiration

Tags:
| | 0 Comments |

The File Upload feature of Google Forms lets you receive files from form respondents directly in your Google Drive. You may add the File Upload question in your Google Form to receive PDF assignments from students, résumé applications, portfolio images from contestants, and so on.

When a respondent uploads a file through Google Forms, the file are stored in a fixed folder of your Google Drive. All files are uploaded in the same folder and, thus looking at the file in your Google Drive, it is difficult to determine which respondent has uploaded which set of files.

Learn how to organize file uploads and attachments from Google Forms and move files to a specific folder in Google Drive.

Source: How to Move Files Uploads from Google Forms to a Specific Folder in Google Drive – Digital Inspiration

New IDE, Solutions, Beginner

5 Great Features in the new Google Apps Script Editor for Beginners

Tags:
| | 0 Comments |

The new editor (Integrated Development Environment — IDE) for Google Apps Script is out! There is a lot of features in the new editor to make your lives easier; here’s my top 5 favorites that I think are helpful for beginners to write and manage their scripts.

We’ve reshared a number of community contributions about the new Apps Script IDE, but this is the first we’ve seen that is specifically targeted at beginners. As well as useful functionality within the IDE Cleo also shares some of her tips which should help writing code easier.

Source: 5 Great Features in the new Google Apps Script Editor for Beginners

New IDE, Advanced, Beginner, Intermediate

16 secrets tips, tricks and features for new Google Apps Script Editor (v2020)

Tags:
| | 0 Comments |

Google Apps Script has a new editor, which is better, nicer, and completed ready for future new features. Today, I would like to introduce you to several dirty and secret tricks, what you can do.

If you like a keyboard shortcut you’ll love this post from Ivan Kutil! For those less keen on keyboard commands there is still plenty of other productivity tips from Ivan shared in this post.

Source: 16 secrets tips, tricks and features for new Google Apps Script Editor (v2020)

New IDE, Official News, Advanced, Beginner, Intermediate

Get ready to up your Apps Script! – Google Developers Blog

Tags:
| | 0 Comments |

The new Apps Script IDE features the same rich integration with Google Workspace as it did before, allowing you to get started building solutions without having to install or configure anything. If you are working on a standalone script project application, you can use the Apps Script Dashboard to launch your project directly, or if you are working on a container bound project in Sheets, Slides or Docs, you can do so from selecting Tools > Script editor from their top menus.

Charles Maxson, Developer Advocate Google Cloud, has highlighted some features Google Apps Script developers new and old should keep an eye out for. I think one of the big ones for experienced Apps Script developers who work mostly in the online editor is going to be the context menu options and the Command Palette. Find out more in the source post.

Source: Get ready to up your Apps Script! – Google Developers Blog