Show image as url expression is not working

Robinthebest · 12-12-2021 10:21 PM

I went on using the above expression, the generated link is out on the spreadsheet, but it doesn’t contain the value of the column [Photo Ref].

I tried pasting my image column file on the url, it still works tho.

Suvrutt_Gurjar

There could be more issues but if you are really using the above expression as you have shown in the image, you will need to replace A ) “AppName” with the app name where you are using the expression B) “Table” with the table name in the app where you are using the expression. Hope [Photo Ref] is the name of a column in your app. Or please replace that as well with the correct column name in the app.

Robinthebest

sorry my bad, i posted a wrong image, btw i have fixed it.

the link now comes up like this: https://www.appsheet.com/template/gettablefileurl?appName=CSTicketing-4328965&tableName=Ticket%20Iss...

but the file name doesn’t generate when the image is being uploaded, i cant seem to fix it

Suvrutt_Gurjar

Please elaborate on where you are using the link? Where do you wish to show the images? In the spreadsheet or in the app?

Also what kind of field [Photo Ref] is?

Edit: Added a query.

Robinthebest

i would like the url being shown in the column in a spreadsheet, so i can click on it.

[Photo Ref] is a image type column, for our officer to upload image into it.

Suvrutt_Gurjar

Okay, thank you. Please take a look at the following sample app.

Have you included a spreadsheet formula like in the sample app?

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

Robinthebest

This one is working, but why the one I mentioned at first doesn’t work?

Also is there any way to stop showing the link on spreadsheet unless there are photos being uploaded?

Suvrutt_Gurjar

Yes, you may try a spreadsheet formula something like below. I am giving the formula with respect to the test app. Please make suitable change as you need

=IF(NOT(ISBLANK(B2)),SUBSTITUTE(CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=",“Imagesinsheets-71626”,"&tableName=”, “Data”,"&fileName=",B2), " “, “%20”),”")

You may wish to compare the formula you were using with the formula that is working. Possiblly the last string “%20”),"" was missing earlier?

Robinthebest

Sorry, I meant the formula I posted with image. I have seen people suggested it and it worked very well.