Images missing

[tom_smith]

After working on a different project, today I come back to this project and all the images which previously worked fine don't display. I am on the work network today (I was at home when it did work). All the images are hosted in Google Drive, in an AppSheet Tools_Images folder (and still there etc).

What's going on?

Tom

 ssin

[tom_smith]

To add insult to injury, I went looking for my Tools_Images folder and it was now at the root of  My Drive when previously it was in a folder deep in the bowels of the /appsheet folder... I had added Sharing to it, but hadn't moved the folder. ????

[tom_smith]

Weirdly... My Tags table image (of which there's only one, rather than a few hundred) displays.

[peterson]

BY any chance are you using the link of the image in the datebase? for example /uc?export=download&id

Is your link something like that? if yes, this kind of link is not working anymore.

[tom_smith]

Nope. The URL in my Tools sheet is, for example, Tools_Images/f609831f.Image.104022.png and the default image location was automatically set... and it all worked... I've monkeyed with it since it broke trying to fix it...  but I believe it was  /appsheet/data/PROJECT_NAME-NUM/data or some such. 

The weird thing was that it worked... then returning to project just didn't. No work on it. No edits etc.

Tom

[tom_smith]

p.s It'd be useful in the Settings page if the location of these files had a link to open that particular folder... 

[peterson]

I have a post where I teach how to generate and access a folder in Google Drive

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Learn-how-to-open-a-file-generated-in-Appsheet/t...

[peterson · Accepted solution]

You don't need to make this fold sharable in order to Appsheet read it. 
Have you tried to open the form and insert a new image and check if it will be ok?

[tom_smith]

Oh very clever... I tried that and a Folder called Tools_Images magically appeared in the /appsheet/data/ folder (so not a subfolder of a project folder) and had one image in it, and that was the only image that worked in the app.

Brilliant, thank you! 

Except that having shunted all the images over, quite a few are broke.  And it isn't easy to debug why that's the case. And also, an odd thing, in Settings > Default app folder is still the old ...  /appsheet/data/DigitalCreativyTools-AppSheet-163908/data

I don't know whether or not I should change that to /appsheet/data/Tools_images or leave it be...  I guess my project (days worth of work) is totally shafted anyway, what's to lose.

Phew, that seems to have fixed it... Massive thank you @Petr ... 

I'm suspecting that because AppSheet doesn't support basic one-to-many data in a meaningful (bi-directional) way, and by that I mean...

a. It's easy to implement and supported by AppSheet with expressions and conventions that are easily explained and work (see another thread of mine) 
b. Whether I use EnumList or a JOIN sheet, people tell me that won't work, and the thought of having to have to design in compromises like columns called category1, category2, category3 is simply technologically inept.   
c. To be honest AppSheet should "just do" this stuff. It's been solved since sql databases were invented in the late 60s, and vendors seem to just ignore the massive elephant in the room of relational data saying "it won't scale" as if that's an excuse... sigh... a simple table with 4 one column of 4 billion emails won't scale either, and 90% of my use cases are complex-ish tables of fewer than a 1,000 rows... 

So, thanks for your help but I'm really disappointed to resussitate this project because it makes me want to see if I can figure out relational data SOMEHOW, when all the forums, here and elsewhere point to the fact that it's either not doable, or won't work.