Images url in Google sheet
Welcome to the community!
Here’s a link to a sample app:
[Use appsheet image link generated in google sheets](https://community.appsheet.com/t/use-appsheet-image-link-generated-in-google-sheets/58058/11) Questions
Please take a look at the below sample app https://www.appsheet.com/templates/How-to-have-images-show-up-in-your-Google-Sheet?appGuidString=e161a3d2-8b5f-4246-957b-61677be0e81f
And here’s a link to a related tip:
[Quick Tips (Easy) : Expression to construct URL to reach to your files](https://community.appsheet.com/t/quick-tips-easy-expression-to-construct-url-to-reach-to-your-files/40889) Tips & Tricks ?
Manually constructing URL to reach out to your file with expression is found painful, when we need to get the app id, table name etc statically, and push into the part of expression. Sometime decode/encode issue is throw the additional pains to us. To remove all those pains and concerns, this expression could be the most efficient and effective to construct the URL, most importantly automatically and dynamically. CONCATENATE(‘https://www.appsheet.com/template/gettablefileurl?appName=’, ENCOD…
2 Likes
In AppSheet images can be viewed using url only those contain image name at the end. Dropbox images also doesn’t work if the dropbox url is used, so far I have been experienced.
1 Like
HI AppSheet,
I Have Tried this (CONCATENATE(‘https://www.appsheet.com/template/gettablefileurl?appName= 22’, ENCODEURL(CONTEXT(AppName)), ‘&tableName=’, ENCODEURL(CONTEXT(Table)), ‘&fileName=’, ENCODEURL([IMAGE])))
But this is not generating the Url instead saying Bad request. If Possible please share the Similar app with form view.
But I used this Instead (=IF(B2:B=“”,“”,CONCAT(“https://www.appsheet.com/template/gettablefileurl?appName=Untitledspreadsheet-4070857-21-11-28&tableName=Image_capturing_QC_wall&fileName=”,B2:B))
I haven’t taken a look at the sample app that Suvrutt Gurjar introduced, but I assume it works. Have you tried that? If that is working properly, it may help you find the problem. Also, is the second expression you cited working properly?
2 Likes