Category: Google Sheets
-
Google Calendar Room Reservation System – No Coding Required
Need a room or day booking application? In this tutorial I walk through setting up an easy to manage Google Calendar reservation system and discuss the code. Users or customers, submit a request on a Google Form, that request is sent to a spreadsheet. The program checks the dates on the calendar and creates an…
-
Search a Google Sheet for Duplicates with this Macro
Page moved: http://techyesplease.com/education/google-sheets-menus-prompts-user-interface/
-
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…