How To Use The 'File Deleter' Shared Script

'File Deleter' is a script shared in the private Patreon folder, that will automatically delete files and images when a corresponding record is deleted from an app.
- A very common problem is "leftover" images and files from uploads inside your AppSheet app
- The new utility script I've shared helps reduce this problem
- You can create a new automation that runs when you delete a record that contains a file, calling this script - which will find the file from the record and delete it
----------------------------------------------------------------------------------------------------------------------
SCRIPT PARAMETERS
----------------------------------------------------------------------------------------------------------------------
1) startingFolder (string)
- The ID of the root Google Drive folder for your AppSheet app
- (Most likely, if you're using Google Sheets as your data source, the Google Drive folder that holds the Google Sheet for your app is the folder you want to use here)
2) filepath (string)
- The "folder/folder/file" value from the "image" or "file" column
- This value tells the system which subfolders to look through, and what file to try and find
3) deleteEmptyFolders (boolean)
- If the folder is empty after the file is deleted, should the empty folder be deleted too?
4) logging (boolean)
- Would you like to see logs for what's happening along the way?
- This gives you the ability to go into the execution logs and see what's happening
- They can be a bit verbose, as I wanted to let people know how things were progressing; that's why I've included this on/off switch for them.
----------------------------------------------------------------------------------------------------------------------
Table of Contents |----------------------------------------------------------------------------------------
COMMING_SOON (someone help me out here...)
-----------------------------------------------------------------------------------------------------------------------
/////////////////////////////////////////////////////////////////////////////
/// SUPPORT THE CHANNEL
/////////////////////////////////////////////////////////////////////////////
//
//
// Patreon
// / multitech
//
// Merch
// multitech-merc...
//
/////////////////////////////////////////////////////////////////////////
For more information about MultiTech Visions, visit
www.MultiTechVisions.com
#CitizenDeveloper #AppSheet

[@hamvasq]

Thank you, Matt!

[@MultitechVisions]

Your welcome! Next up: an update to also include deleting the empty row from the sheet if you wish.

[@afrinsir7479]

make a videos on runnig sum on appsheet

[@MultitechVisions]

Thanks for the suggestion! You might check out this video, it might have your answers: th-cam.com/video/aq5fS5yuQ1U/w-d-xo.html

[@tanjidahmedjony4667]

❤️🥇❤️