Hi! Weโve been using our App for two years now, and some of the images we uploaded months ago are now appearing as broken (with a triangle and exclamation symbol). If i check the Drive, the image is actually there, but it just wonโt show. If i download the image, rename it and re-upload it it gets fixed, but this would be quite difficult to achieve quickly since we have close to 1000 records and many many pictures.
When we update the records, an email needs to be sent, but when the record has a broken image, or images, the email fails to be sent.
Is there a way to fix this in a batch?
Please bear in mind ALL images were uploaded through Appsheet, and were working when uploaded. We canโt really determine since when they start to break.
@Controller_Planeador After debugging your app, I found out that when our server queried Google Drive for the missing image files, the files were not found. There can be a few possible causes. For instance, the image files might have been moved/deleted/renamed. Have you modified any of the image files in the folder โPlan General_Imagesโ recently? If possible, could you share screenshots of of the following:
1/ Screenshot showing where the โPlan General_Imagesโ folder is located in your appโs folder
2/ Screenshot showing the content of the โPlan General_Imagesโ folder.
Thank you.
Is it possible that you have moved the image folder or some images from that folder?
!!
I checked this and realized that someone in my team organized the Google Sheets inside folders (on Drive), and so the images folders where duplicated, leaving a whole set of images outside. I just moved all the images to the new folder location, could you please query the images again to see if theyโre working now?
Thanks!!!
@Controller_Planeador Some of the images are still missing, In particular, the image at column โรltima Acta de Pozo Listoโ is missing in some of the rows of table โPlan Generalโ. Could you check the folder โPlan_General_Imagesโ again to make sure that all of the images have been restored correctly in this folder?
@Harry I checked and the folder is where it should be (see picture attached). You mentioned โPlan_General_Imagesโ but checking the rows in the Google sheet, there are only references to โPlan General_Imagesโ which is the folder that I have on the same location as the main Sheet.
How can I see exactly which references are not working properly?
Thanks!
I manage to Check all the images using the View Data optiom from the Table Definition. I did loose some images from 2016, but thatโs ok, with what I did on the troubleshooting above I achieved the objective.
Thanks you @Harry and @Aleksi_Alkio !!
@Controller_Planeador Hi, I assume that the problem is resolved. If you have any other question, please let us know.
@Harry Yes! Resolved!!! Thank!
I have the same issueโฆ
And yes, my battery is that low lol
@Controller_Planeador May I ask what is your account ID so I could
check the app quickly, if itโs okay for you?
@Grant_Stead lol! Well, hopefully weโll get it sorted
It seems that there is a problem at least with the โรltima Acta de Pozo Listoโ folder. As far as I checked, the photo from this field is always missing. Though some other fields have the same problem but not always.
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |