Create a sidebar input form for a Data Log in Google sheets with Google Apps Script
The Starter Sheet: https://docs.google.com/spreadsheets/...
In this tutorial, we are going to build a Google Sheets sidebar that we will use to conveniently input data into a data log in our sheet tab.
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:
CSS package for Google Apps Script editor add-ons: https://developers.google.com/apps-sc...
Apps Script client-side API: https://developers.google.com/apps-sc...
If you like the video, check out my website:
https://yagisanatode.com/
00:00 Intro & Example
00:57 onOpen() logging menu
03:09 createEntrySidebar()
05:01 Adding CSS from Google Editor Add ons
05:59 Add style tag for padding
06:36 Bulid the form in Iindex.html
15:33 Buttons & google.script.run API
19:13 appendEvLog() append data
24:17 Up next
Here is the link to just Google Apps Script tutorials:
https://yagisanatode.com/google-apps-...
#GoogleSheets #GoogleWorkspace #GoogleAppsScript #AppsScript #Spreadsheets
