Google Apps Script-side (server-side) validation of Google Sheet sidebar input
The Starter Sheet: https://docs.google.com/spreadsheets/...
In this video, we learn the basics of validating input data from a Google Sheets sidebar form Google Apps Script-side.
We'll cover
onSuccessHandlers() and onFailureHanders()
The Javascript Number() constructor
validation if statements
and I may even hack my own sidebar 🐱💻. You will have to watch and see.
This tutorial is part of the: Building a Data Log in Google Sheets with Google Apps Script series. Link to the playlist here: • Building a Data Log in Google Sheets ...
REFERENCES:
Class google.script.run (Client-side API) https://developers.google.com/apps-sc...
Number() constructor JavaScript https://developer.mozilla.org/en-US/d...
00:00 Intro
01:59 Index.html - sendInput()
03:13 withSuccessHandler()
04:14 withFailureHandler()
05:34 Index.html onSuccess()
11:33 Index.html onFailure()
13:00 Code.gs processForm() update
15:37 Code.gs validateInput()
25:34 Testing validateInput()
27:48 Testing the sidebar with some hacking
29:18 Up next.
More on building sidebars in Google Sheets and Apps Script:
How to Get Something from Google Sheets and Display it in the Sidebar in Google Apps Script (Updated January 2022) - https://yagisanatode.com/2018/02/12/h...
Google Apps Script – Disable Enable Submit Button in Sidebar - https://yagisanatode.com/2018/04/27/g...
Google Apps Script: Google Standard Color Palette Picker for Sidebar and Dialog Boxes in Google Sheets, Google Docs and Google Slides (Updated Feb 2022) - https://yagisanatode.com/2019/08/07/g...
Here is the link to just Google Apps Script tutorials:
https://yagisanatode.com/google-apps-...
#GoogleSheets #GoogleWorkspace #GoogleAppsScript #AppsScript #Javascript #Spreadsheets #HTML
Watch video Google Apps Script-side (server-side) validation of Google Sheet sidebar input online, duration hours minute second in high quality that is uploaded to the channel Yagisanatode -Scott- 22 June 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 1,870 times and liked it 34 visitors.
