This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi
Just wondering what the best option is for housekeeping with images.
My App collects images and forwards via an email. Once they are sent to the recipient they are no longer required.
I am aware we can delete the data from the table but how do other users delete the actual images so saving on storage space?
I would use Apps Script in order to delete images from the folder, provided their names are no longer found in the data table.
Iโm afraid itโs hard to deal with it.
One option is to use AppSheetโs new feature of folder as table. Once you create a table based on folders of your images, you can delete them from the app. Though please note the following
The images go to the trash folder of the G drive . G drive trash anyway gets emptied automatically after every 30 dyas.
The image reference from the other tables is not removed. So if you have image path stored in some other Appsheet table when you captured the image through app, that path will continue to remain intacts. You can set up some automation to delete the image paths as well when the images are deleted from the folder table or viceversa.
The images should not be โRequiredโ fields in the tables from where those are deleted.
I tested the above by including an image folder as a table and deleted the image files fromthe app. I also deleted the image paths in the tables where these were referred with the help of actions. Extensive testing though will show any cracks in the approach.
LinkedIn
Twitter
