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
Watch video Create a sidebar input form for a Data Log in Google sheets with Google Apps Script online, duration hours minute second in high quality that is uploaded to the channel Yagisanatode -Scott- 15 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 5,992 times and liked it 98 visitors.
