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 […]
You are browsing archives for
Category: Google Sheets
Search a Google Sheet for Duplicates with this Macro
Being a teacher I often am working with datasets that contain hundreds or even thousands of rows of information. I need to be able to easily locate duplicate data within spreadsheets, it is an essential tool for me. In this tutorial I continue to build upon the find duplicate program I have been working on. […]
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 Sheets: Find Duplicates in Spreadsheet Columns and Rows
Need to easily find duplicates in Google Sheets? This is a critical feature, not finding a good alternative, I built my own. In this tutorial I continue to work on the duplicates program from my last video. I added the ability to scan a row or a column for duplicated data, making the application more […]