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-sprin...
//
/////////////////////////////////////////////////////////////////////////
For more information about MultiTech Visions, visit
www.MultiTechVisions.com
#CitizenDeveloper #AppSheet