Locating duplicate data is a basic need while working with spreadsheets. Honestly, I was surprised that Google Sheets did not have a tool to locate duplicates built into it. There are a few paid add-ons. Not being impressed with them, I decided to build my own. This project is focused on locating duplicate data within […]
You are browsing archives for
Category: Google Sheets
Google Apps Script Calendar Reservation Confirmation Email for Events
Having automated event creation using submissions through Google Form, it is helpful to have those submitting requests receive a confirmation email. This is part three of my reservation project, part 1 makes the calendar event and part 2 checks for event conflicts. Now on part 3, this code sends an email using another G Suit Service, […]
Google Apps Script Calendar Reservation Project Part 2
Using Google Forms and Google Calendar for a reservation system is handy. Having create the basic program last time, I want to start adding more features. First, and very much needed, is a bit of code that will prevent the script for scheduling two events at the same time. This can be especially helpful if […]
Google Apps Script – Super Simple Calendar Reservation Code
This project is for beginners. It contains only a single function, and that was just so I could have the function triggered on form submission. This project lets you dip your toe into how useful Google Apps Script can truly be. Once you have conquered this, I recommend checking out my full calendar reservation project. […]