Good afternoon,
Please your support. I want a photo captured in the application to be displayed in the google sheets cell. In google sheet I enter the formula of the image and it shows me, but what I would like is the formula to be generated when saving changes in the application.
In the option of auto compute I tried to enter the same formulating concatenating but it does not work, I can not make the quotes appear on google sheets.
This post from a while back has some relevant links:
[[HELP] How to create image links in google spreadsheet](https://community.appsheet.com/t/help-how-to-create-image-links-in-google-spreadsheet/16215) Questions
Hi. Im having a very hard time constructing a simple url to view images in my google sheets. I believe its because of my “spaces” in my table, folder & file name… Example appname = “my app” table name = “my table” file name = “my table_images/A1234.Image 1.12.30 PM_Track_1234.jpg” note: my table_images is an auto generated folder created by appsheet. pictures are inside with name: 1234.Image 1.12.30 PM_Track_1234.jpg → “this has 2 spaces” can someone help me generate the applink using the…
It links to a sample app
and to a page documenting how to do this
Scroll down to “Showing Images in Google Sheets”.
Now, as to your problem, I’m not completely sure that I understand your problem but let me suggest that you try the following.
-
Copy the sample I introduced above.
-
After copying the sample, use it to add a new image. You’ll find that the new image doesn’t display in your sheet. The problem is that the correct name of your app isn’t being added to new data in your sheet.
-
Get the correct name of your app by looking at your URL. Here’s an image of mine:
- In your spreadsheet, delete all of the lines that came with the sample app, leave the line that you added and correct the name in that URL:
- Finally, regenerate the table (inside of AppSheet).
Now, when you add new pictures or edit old ones, they should appear in your spreadsheet.
1 Like
Hi I try to replicate the formula by changing my app id, table name and image column but it still issue bad request.
My App ID
My Formula
Result
Can anyone check it which part I did wrong.
Thank you
Could you please share the complete URL?
My Formula
SUBSTITUTE(CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=“,“WorldwideNewworkorder-799210”,”&tableName=”, “New Work Order”,“&fileName=”,AA3), " ", “%20”)
My Url
Worth visiting our post of
[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…
Sorry if I did something wrong. I simply replicate the formula and change the App ID, Table Name and Image column
My Formula
=CONCATENATE(‘https://www.appsheet.com/template/gettablefileurl?appName= 3’, ENCODEURL(CONTEXT(WorldwideNewworkorder-799210)), ‘&tableName=’, ENCODEURL(CONTEXT(New Work Order)), ‘&fileName=’, ENCODEURL(ae3))
My Result
What is my mistake and is there any sample app that use this formula so I can study it.
I have put into the appsheet formula and the expression is correct and link has been generated when i save the app however it still show bad request
My Formula:
CONCATENATE(‘https://www.appsheet.com/template/gettablefileurl?appName=’, ENCODEURL(CONTEXT(“WorldwideNewworkorder-799210”)), ‘&tableName=’, ENCODEURL(CONTEXT(“New Work Order”)), ‘&fileName=’, ENCODEURL([Action Image 1]))
My Link:
Result
your are wrongly using our tricks.
[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…
Just change the column names only. Dont change the rest.
Finally it works.
Thank you so much for assisting me and your time. Appreciate it.
Hi,
I have proceed using the app formula, first is starts out well. Now the link still shows bad request
My Formula
CONCATENATE(‘https://www.appsheet.com/template/gettablefileurl?appName=’, ENCODEURL(CONTEXT(AppName)), ‘&tableName=’, ENCODEURL(CONTEXT(Table)), ‘&fileName=’, ENCODEURL([Action Image 3]))
My url image link generated
When I compare with the previous successful link. The file name is not included.
Successful Link at row 3
File name not captured at row 6
Why it does not captured my image column?
1 Like
Your image column is just blank.
1 Like
Your expression to construct image URL should be returning the value before the image is saved to the data source as relative path.
That is only what I can suspect.
1 Like
Yes as you suspected. I have to re-open and re-save again then the image link formula will works.
Quite odd for my case that the app formula does not automatically capture the moment that image has been inserted.
1 Like
The image column value is not set until a sync occurs, because the file has not yet been uploaded to cloud storage and given the name by which it will be known to the app.
See also:
Hi.
May i know where to put the formula in the appsheet? For my case,i want my signature appear in the google sheets