Google Sheet Pictures

[CarlosDelgado]

When pictures are taken using the app, google sheet enters the location of the picture and creates the name for the file.  Is there a way I can create a link to the actual picture instead of the file name?  OR maybe display the actual picture in the cell?  Below is what google sheet shows when a picture is taken.

Form Responses 1_Images/07-26-2022 11-42-05.Picture of Left Side of Vehicle.154355.jpg

[franc]

Hola Carlos,

I am not sure if I fully understand what you need to build but I think that here you can find the answer that you are looking for in the comments:

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Automatically-generate-images-URL/m-p/324249

please let me know if this is what you need or not.

F.

[CarlosDelgado]

No, the google sheet does not have links that display appsheet. Column I
below is a  column from the google sheet responses.  The app contains a field that requires the user to take a picture.  The app then creates the picture in a subfolder and enters the name of the picture file on the google sheet.  The picture resides on the folder but what appears on the google sheet is a file name of the picture that was created. I'm trying to show the actual picture in the field rather than
the file name

[franc]

OK, so I suppose that this example is what you are looking for:

https://www.appsheet.com/templates/How-to-have-images-show-up-in-your-Google-Sheet?appGuidString=e16...
(you can also copy it and test/copy the formula of course)

Please let me know if you have any issues with the formula or if this is the solution you were looking for.

[franc]

and here you can find more information in case you have another kind of trouble:

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Insert-google-sheets-formula-to-display-image-w...

https://support.google.com/appsheet/answer/10107317

[franc]

SUBSTITUTE(CONCATENATE("https://www.appsheet.com/template/gettablefileurl?appName=","Imagesinsheets-71626","&tableName=", "Data","&fileName=",RC[-1]), " ", "%20")

sorry Carlos, just a last tip: if you copy and test the App just mentioned above, you'll see that the formula uses the name of the App. When you copy the App, in order to make your own images displayed on your Spreadsheet, you need to change that value with the one that your copied App has, in its own URL

[CarlosDelgado]

The images taken with the app will always be new.  The app itself does not display the image, it just asks for a picture to be taken.

[franc]

Hi Carlos, 

Yes, and this is actually what you need to have the photos on the spreadsheet. Anyway, if you want to test the functionality that you are looking for, do the following:

- copy this app https://www.appsheet.com/templates/How-to-have-images-show-up-in-your-Google-Sheet?appGuidString=e16... 

- install the app on your mobile (first, install Appsheet App)

- then change the formula on the App, as commented above, with your App name

- then open the App and take a photo:

At this point, you'll be able to see the photo you have just taken at the same time in the App itself and in the source spreadsheet file. 

If you only want to show the pictures in the spreadsheet, create a View without including the image column. The options of where to show the data and images in your spreadsheet depend on how you define the Views.

I hope this is clear but if you have any doubt just let me know.

Franc

[franc]

Hello Carlos,
has this information helped you to make images visible in your spreadsheet?