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
In questa pagina del sito puoi guardare il video online Run Authorisation and Setup Script Before Revealing Google Sheet Tabs Using Google Apps Script della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Yagisanatode -Scott- 24 maggio 2022, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 1,695 volte e gli è piaciuto 27 spettatori. Buona visione!
