How to fetch URL of the captured images through app into spreadsheet

[Ashish4]

HI, I am new to AppSheet and trying to build an inventory management app. I need to have URL code instead of name(directory) of the image captured through App in the spreadsheet.

I tried making an URL Column (with a formula I found online) to get the URL ,but its not providing table name and file name in the URL. Therefore the link is not working. Please Help!

.

[Suvrutt_Gurjar]

Welcome to the AppSheet community.

Are you looking for the approach described in the sample app below

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

[Ashish4]

Sorry Sir, for late reply, I am new to AppSheet.
Thanks for the template app link. I tried it , the link constructed by spreadsheet formula is complete, but still I am unable to access the new images uploaded through app. Tried switching off security options still it didn’t work like the template app showing.

[Suvrutt_Gurjar]

If you can share the screenshots of your relevant expressions and how you have implemented it, the community could help you better.

[Ashish4]

HI,
The issue has been resolved.
I was using this Spreadsheet formula which I got from the source file of the template you have provided, the issue was I just put the App Name in the formula without the Account ID, that’s why the link wasn’t working.
Thank you for your help

“=SUBSTITUTE(CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=","APP_NAME-AccountID”,”&tableName=", “TABBLE_NAME”,"&fileName=",COLUM_NAME), " “, “%20”)”

[Suvrutt_Gurjar]

Thank you for the update. Yes, that is a common likely mistake that happens - App name or account ID or table name needs to be changed as required. Good to know you solved it.

All the best with your app creation.