What's wrong with my CONCATENATE()?

[kosukey05]

Hi all,

I want to get image URLs by using concatenate.  

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

I'm using this expression for column [image_url].

CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=",“appname-id”,"&tableName=",“diary”,"&fileName=",[image])

But, it fails to get [image] value...

Can anyone know what I'm doing wrong?

Thanks!

 

[Suvrutt_Gurjar]

Could you try the expression with a virtual column? 

Also for real column you can try the following test approach. Once the record is saved ( when probably image URL will not be there) first time, please open the record in app again and save back.  You will most probably see  the image URL column populated.

[kosukey05]

Hi Subrutt 

Thank you so much for your help. I tried with a virtual column and yes, it's working! But unfortunately the same expression in real column doesn't.

But I need this URL in the real column since I want to access this data from external services.

I tried your suggestion for real column but it didn't work and still missing the file name...

[Uk]

sometimes it works . sometimes it doesn't. i don't know why

[Uk]

i've just tried and It works using bot automation. 

I'm using this formula in the table CONCATENATE("https://www.appsheet.com/template/gettablefileurl?appName=","xx-xx","&tableName=","xxx","&fileName=",ENCODEURL([xxx]))

[kosukey05]

Thanks Uk,
I've tried your suggestion and didn't work...
The same case as above, it works in a virtual column but not in a real column.

[Suvrutt_Gurjar · Accepted solution]

Thank you. In a real column did you try saving the new record. When you first save there will not be the image URL. When you open that saved record again and resave it, does it create the URL?