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
Смотрите видео Google Apps Script-side (server-side) validation of Google Sheet sidebar input онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Yagisanatode -Scott- 22 Июнь 2022. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 1,870 раз и оно понравилось 34 посетителям.
