Image storage, How do I display captured images in Google Sheets automatically?

[Ratatosk]

Is there a way to actually show the images uploaded from Appsheet in a Google sheet?

Now it only shows the text “Sheet1_Images/6.Image 1.091041.jpg” in the sheet.

[Suvrutt_Gurjar]

May be the following sample app will help you

https://www.appsheet.com/samples/How-to-have-images-show-up-in-your-Google-Sheet?appGuidString=e161a...

[Ratatosk]

Thank you Suvrutt_Gurjar! Getting closer but I get bad request, even though I’ve shared the folder in google drive to “view for all”.

[Kirk_Masden]

I wonder if what I wrote here might not help:

Insert google sheets formula to display image when saving changes to appsheet Questions

This post from a while back has some relevant links: It links to a sample app and to a page documenting how to do this Scroll down to “Showing Images in Google Sheets”. Now, as to your problem, I’m not completely sure that I understand your problem but let me suggest that you try the following. Copy the sample I introduced above. After copying the sample, use it to add a new image. You’ll find that the new image doesn’t display in your sheet. The problem is that the correct nam…

I just tried it and it worked.

[JensenDK]

Put this formula in the first cell in the first unused column of your sheet if your local paths to your images are in the G column:

=ArrayFormula(Image("https://www.appsheet.com/template/gettablefileurl?appName=YOURAPPNAME&tableName=YOURSHEETNAME&fileName=" & G:G))