Controlling Google Drive folder access with an AppSheet app (the old way) | AppSheet Explained
You can easily control access to a Google Drive folder using Google Scripts (it's like one line of code (if you have the appropriate data already)). In this video I'll show you how you can use a Google Script that's watching the changes you make to a Google Sheet via AppSheet, and based on the data entered either add or remove access to a Google Drive folder.
NOTE FROM THE FUTURE:
This is an older way of doing things begore we could natively execute a script through an automation task in AppSheet.
- Now you can just execute the script below, without all the "sheet watching" bs that was involved before. ;)
Permission Control SCRIPT
-----------------------------------------------------------------------------------------------------------------------
function Manage_Folder_Access(emailFromRow, type){
var Folder = DriveApp.getFolderById("FolderID");
if(type == "Add_Access"){
Folder.addViewer(emailFromRow);
Logger.log(emailFromRow + " Added");
} else if (type == "Remove_Access"){
Folder.removeViewer(emailFromRow);
Logger.log(emailFromRow + " Removed");
}
}
-----------------------------------------------------------------------------------------------------------------------
-----| Table of Contents |-----
0:00 - Intro
2:17 - Script Overview
3:08 - AccessControl() run-through
4:05 - Finding column numbers
5:53 - Pulling the trigger word
8:40 - Pulling the email to use
11:29 - Actually changing G-drive permissions
13:31 - Let me know if you have any questions!!!
-----------------------------------------------------------------------------------------------------------------------
/////////////////////////////////////////////////////////////////////////////
/// SUPPORT THE CHANNEL
/////////////////////////////////////////////////////////////////////////////
//
// Answer Portal
// https://www.MultiTechVisions.com/answers
//
// Merch
// https://multitech-merch.creator-spring.com/
//
/////////////////////////////////////////////////////////////////////////
For more information about MultiTech Visions, visit
www.MultiTechVisions.com
#CitizenDeveloper #AppSheet
Видео Controlling Google Drive folder access with an AppSheet app (the old way) | AppSheet Explained канала MultiTech Visions
NOTE FROM THE FUTURE:
This is an older way of doing things begore we could natively execute a script through an automation task in AppSheet.
- Now you can just execute the script below, without all the "sheet watching" bs that was involved before. ;)
Permission Control SCRIPT
-----------------------------------------------------------------------------------------------------------------------
function Manage_Folder_Access(emailFromRow, type){
var Folder = DriveApp.getFolderById("FolderID");
if(type == "Add_Access"){
Folder.addViewer(emailFromRow);
Logger.log(emailFromRow + " Added");
} else if (type == "Remove_Access"){
Folder.removeViewer(emailFromRow);
Logger.log(emailFromRow + " Removed");
}
}
-----------------------------------------------------------------------------------------------------------------------
-----| Table of Contents |-----
0:00 - Intro
2:17 - Script Overview
3:08 - AccessControl() run-through
4:05 - Finding column numbers
5:53 - Pulling the trigger word
8:40 - Pulling the email to use
11:29 - Actually changing G-drive permissions
13:31 - Let me know if you have any questions!!!
-----------------------------------------------------------------------------------------------------------------------
/////////////////////////////////////////////////////////////////////////////
/// SUPPORT THE CHANNEL
/////////////////////////////////////////////////////////////////////////////
//
// Answer Portal
// https://www.MultiTechVisions.com/answers
//
// Merch
// https://multitech-merch.creator-spring.com/
//
/////////////////////////////////////////////////////////////////////////
For more information about MultiTech Visions, visit
www.MultiTechVisions.com
#CitizenDeveloper #AppSheet
Видео Controlling Google Drive folder access with an AppSheet app (the old way) | AppSheet Explained канала MultiTech Visions
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![How To Use The 'File Deleter' Shared Script](https://i.ytimg.com/vi/QglM17cldFk/default.jpg)
![Tracking Inventory Through AppSheet Automation || Let The Bot Do All The Work!!!](https://i.ytimg.com/vi/COmbk-pnOAc/default.jpg)
![OpenAi & AppSheet #2 | Dynamic Starters](https://i.ytimg.com/vi/pIV-_Z10n2M/default.jpg)
![Could use some help (deals with references) | AppSheet Community Answers](https://i.ytimg.com/vi/UM1ck6pTN6E/default.jpg)
![MultiTech's Weekly AppSheet Show || 10/21/22 || #16](https://i.ytimg.com/vi/PNzYpUwj7YE/default.jpg)
![MultiTech's Weekly AppSheet Show || 7/29/22 || #5](https://i.ytimg.com/vi/mRbIrznurIE/default.jpg)
![MultiTech's Weekly AppSheet Show || 2/24/23 || #33](https://i.ytimg.com/vi/gYRnuG1VeEM/default.jpg)
![Ai drafts in Gmail, made easy (TEASER)](https://i.ytimg.com/vi/PE0eqFMAuKA/default.jpg)
![MultiTech's Weekly AppSheet Show || 3/3/23 || #34](https://i.ytimg.com/vi/Y-Md9DkT5X0/default.jpg)
![MultiTech's Weekly AppSheet Show || 1/20/23 || #28](https://i.ytimg.com/vi/aj4EcS5ge4I/default.jpg)
![Scheduled Reminders || Sample App](https://i.ytimg.com/vi/nR7cGCCqIcQ/default.jpg)
![MultiTech's Weekly AppSheet Show || 8/12/22 || #7](https://i.ytimg.com/vi/mZqkODfOa2w/default.jpg)
![Discussion about Importing Data into your AppSheet App](https://i.ytimg.com/vi/MTIgD13ofmw/default.jpg)
![How to make a Public App (with private data) | Sample App](https://i.ytimg.com/vi/gYWfvUQBplc/default.jpg)
![Take control over the 'Add' button | AppSheet Explained](https://i.ytimg.com/vi/g6Q0K3RBBao/default.jpg)
![July 4th - 10th | AppSheet Feature Release - Weekly Run-Down](https://i.ytimg.com/vi/7XYJzdvByiY/default.jpg)
![Secrets To Getting Around AppSheet Faster](https://i.ytimg.com/vi/UBV5jFOHpwo/default.jpg)
![MultiTech's Weekly AppSheet Show || 2/3/23 || #30](https://i.ytimg.com/vi/WIAVUN_RK-s/default.jpg)
![One-Shot Builds | MultiTech Visions | YouTube Content Management App](https://i.ytimg.com/vi/oskOAksjZRQ/default.jpg)
![Discount & Totals || Shopping-Cart [BUILD] - Part 7.1](https://i.ytimg.com/vi/aq5fS5yuQ1U/default.jpg)