SHOW() images not displaying

[Jonathon]

Has anyone elses SHOW() columns with images stopped working?

Specifically, I have virtual columns of type SHOW() that reference .png images in a common folder in MSFT OneDrive. These have all worked previously, and have all simultaneously broken.

Other media files in onedrive are still accessible, so I’m inclined to think something has changed on AppSheets end.

[Steve · Accepted solution]

This?

Call to Action for Apps Constructing URLs to GetTableFileUrl Announcements

We recently made a security enhancement wherein image and file type columns have signed URLs generated for them. This enhancement prevents an app user from changing the table name or file name parameters in order to access app files that they should not. In the near future, we are going to start requiring calls to the gettablefileurl and getappfileurl endpoints to have valid signatures. What does this mean for you? If you have an app where you are manually constructing a link to a gettablefileu…

[hugheshilton]

Yep I think so. If you want app users to be able to access files on your GDrive that are not part of the actual app data, then you need to go to Security -> Options and disable the “Require Image and File URL Signing” option.

[Jonathon]

Yep that did it. Odd that it seems to only effect my SHOW() columns?

Also odd that it took a whole month for that change to get pushed to my account!

---

Edit

@hugheshilton maybe not so odd that it’s only effecting my SHOW columns then, since the SHOW() columns are the only ones not referencing application data specifically. I suppose a workaround (if I wanted to keep image and URL signing enabled) would be to stick these image references in a readonly table and add it to the app.

[Steve]

[pravse]

@Jonathon we were very careful rolling out this change as it had the potential to break a lot of people.

I think the Show Column issue is a bug on our side. At least as long as the image file paths in the Show column type definition are relative paths from the location of the table.

You should not need to change anything. Hope to have a fix out on Monday, Tuesday at the latest.