Category: Code
-
Search a Google Sheet for Duplicates with this Macro
Page moved: http://techyesplease.com/education/google-sheets-menus-prompts-user-interface/
-
Easily Code a Google Calendar Appointment Booking System
Need an appointment booking system for Google Calendar? Daring enough to look at a bit of code? This program enables people to be able to make appointment requests using a Google Form. After the user hits submit the program checks for conflicting calendar events. If there are conflicts, the user receives an email asking them…
-
Google Sheets: Menus and Prompts in Google Apps Script
Google Apps Script is endlessly versatile. Automating small and large tasks makes working within Google Sheets more convenient. However, it is difficult to share your work with those that aren’t familiar with coding. User interfaces solve this problem. Thankfully Google makes it easy to create menus and prompts that appear on spreadsheet itself, meaning there…
-
Google Apps Script: Find Duplicates in Sheets
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…