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!
.
Welcome to the AppSheet community.
Are you looking for the approach described in the sample app below
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.
If you can share the screenshots of your relevant expressions and how you have implemented it, the community could help you better.
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”)”
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.
