URL Based images not updating when image is changed

AppSheet AppSheet Q&A
1

I have an image type virtual column with a formula of:

CONCATENATE(“http://www.qualitymarine.com/Graphics/Wysiwyg/Large/“,[Series],”.jpg”)

This works great, but sometimes I need to swap out the images in the server folder and the updated images aren’t reflect in appsheet. For example, If I update the image, when I manually type in the image URL, the updated shows up. But the old image is still showing up in the app. It looks like maybe appsheet is storing the initial image pulled from the URL somehow? Any help would be great. Thank you!

2

When I test the URL/Image Expression, you can see the correct URL is being generated for the image, but the old photo is still being pulled (even though it doesn’t even exist on the server anymore).

2X_7_7ff0d1cff86d5b8d9756b5a870e81b02a9a2d9be.png
2X_7_7ff0d1cff86d5b8d9756b5a870e81b02a9a2d9be.png2914×196 95.6 KB

3

I encourage you to contact support@appsheet.com directly for help with this.

4

I concur with @Steve as I have not had the same issue with relative url paths.

1 Like
5

hank you @Steve and @Bahbus I just sent them an email and will reply with the result

1 Like
6

See topic “Image Caching” in this article https://help.appsheet.com/en/articles/961605-displaying-images-and-documents

7

@Steve and @Bahbus and anyone else that has this problem; the reason why the images aren’t being updated are because their cached by appsheet indefinitely. I contacted support and they had me change the URL image expression from:

CONCATENATE(“http://www.qualitymarine.com/Graphics/Wysiwyg/Large/“,[Series],”.jpg”)

to

CONCATENATE(“http://www.qualitymarine.com/Graphics/Wysiwyg/Large/“,[Series],”.jpg?v=2”)

I have no idea what the ?v=2 means or does, but it worked perfectly!

4 Likes