Image url links

Sirfyaad · 01-22-2023 07:55 AM

Hi!

I want when uploading an image in an Appsheet, shows in Spreadsheet the URL of the image not the folder and file name in the Google Drive.

I am using:

CONCATENATE(

"?appName=", ENCODEURL(CONTEXT("AppName")),

"&tableName=", ENCODEURL(CONTEXT("Table")),

"&fileName=", ENCODEURL([image])),

"")

the result:

So Spreadsheet show appname and table name but not file name

Can somebody help?

Kirk_Masden

Is [image] the name of the column? By the way, I don't fully understand your goal. Are you trying to get the image to display in the spreadsheet?

Sirfyaad

I want to generate clickable url.

Kirk_Masden

Inside the app? OK. What about my first question? What is the name of the column to which the image is saved?

Sirfyaad

The URL is to be generated in the column containing [image] to [image link].

Kirk_Masden

Thanks! But it does look like you [image] column is empty. I wonder why.

Sirfyaad

The image column is not empty.

Kirk_Masden

Thanks for your response. I'm afraid I don't understand what the problem might be.

Here's a URL that works:

https://www.appsheet.com/template/gettablefileurl?appName=KankakuV9-3097139&tableName=Kankaku&fileNa...

This has an app name, table name, and file name. But your "result" doesn't have any of those. I think you need to figure out how to access those names in your expression.

Sirfyaad

@Kirk_Masden Thank you for your reply. But it is not working in my case. All my formula are correct still not working.

Kirk_Masden

I see. I'm sorry to hear that. I'm afraid I don't know what to do next. I hope you can find a resolution.

SEUAdmin

Remove both "Context" words from expression, that worked for me, after spending a whole day wondering why it would not work

Remove what's on red

CONCATENATE(

"?appName=", ENCODEURL(CONTEXT("AppName")),

"&tableName=", ENCODEURL(CONTEXT("Table")),

"&fileName=", ENCODEURL([Image Column])
)