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
En esta página del sitio puede ver el video en línea Run Authorisation and Setup Script Before Revealing Google Sheet Tabs Using Google Apps Script de Duración hora minuto segunda en buena calidad , que subió el usuario Yagisanatode -Scott- 24 mayo 2022, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 1,695 veces y le gustó 27 a los espectadores. Disfruta viendo!
