Hi! This post will be a quick tip for people who don’t yet know how to make images that they’ve captured in their apps visible inside their Google spreadsheets.
Then, I’d like to pose a question about the expression we use to make this happen.
First of all, the image you see shows how an image that I captured through my app appears in my spreadsheet.
This magic is explained here:
Displaying Images and Documents https://help.appsheet.com/ux/views/displaying-images-and-documents
The spreadsheet formula that needs to be in your “column definition” (Data --> Columns --> Table that has the column you want to hold the url for
the image --> pen mark by that column) in the “Spreadsheet formula” box is
=SUBSTITUTE(CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=",“AppName-Account#”,"&tableName=",“TableName”,"&fileName=”,+ImageColumnCell), " ", “%20”)
Now, the easiest way to learn how this works would be to look at a sample app that has the function.
I think there is one but, alas, this article does link to such a sample app (lack of such simple linking is a major problem with AppSheet documentation, in my view) and I can’t remember where it is.
At any rate, that’s what I know about how this cool function works.
Here’s what I don’t know:
Is there an expression that will automatically put the real app name into a spreadsheet formula like this?
The reason I ask, is that I would like a prototype app that I have students copy and use for free to have this function.
I can explain to my students how to go into the spreadsheet formula and change it to the specific name that was assigned when they copied the app but it would be SOOO much easier if their were an automatic function for this.
The rest of the formula is all “relative” so the only thing that needs to be changed after copying is the app name.
Thanks in advance!