Run Authorisation and Setup Script Before Revealing Google Sheet Tabs Using Google Apps Script
Setup Sheet Template: https://docs.google.com/spreadsheets/...
Starter Sheet to play along:
https://docs.google.com/spreadsheets/...
The Written tutorial:
https://yagisanatode.com/2022/05/23/o...
It can be hard to get users to run starter scripts before they start playing around in a spreadsheet. In this tutorial, I walk you through a process that gets users to authorise their Google Apps Script in the Google Sheet and then runs the Startup process before displaying selected Google Sheet tabs for the user.
00:00 Intro
00:41 Setup Sheet
01:09 Explaining the layout of the Template Setup Sheet
02:47 Add the Template Setup Sheet to your Spreadsheet
03:33 User's workflow
04:13 The code
13:04 Test run the buttons
More on:
Running Apps Script for the first time:
• Running Google Apps Script for the Fi...
Hiding Buttons after being clicked:
• Remove a Google Sheet button after it...
-How to connect a button to a function in Google Sheets
https://yagisanatode.com/2019/03/07/g...
Learn more about Google Apps Script here:
https://yagisanatode.com/google-apps-...
#GoogleAppsScript #GoogleSheets #GoogleWorkspace
Sur cette page du site, vous pouvez voir la vidéo en ligne Run Authorisation and Setup Script Before Revealing Google Sheet Tabs Using Google Apps Script durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Yagisanatode -Scott- 24 mai 2022, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 1,695 fois et il a aimé 27 téléspectateurs. Bon visionnage!
