Insert google sheets formula to display image when saving changes to appsheet

[erickcentenoch]

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.

[Kirk_Masden]

This post from a while back has some relevant links:

[HELP] How to create image links in google spreadsheet 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

AppSheet

AppSheet : mobile apps from spreadsheets : Images in sheets - AppSheet

How to build apps for Images in sheets using your data in Google Drive, Dropbox, Office 365, and more.

and to a page documenting how to do this

help.appsheet.com

Displaying Images and Documents

How to display documents and images in your app.

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.

1. Copy the sample I introduced above.

2. 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.

3. Get the correct name of your app by looking at your URL. Here’s an image of mine:

4. 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:

5. Finally, regenerate the table (inside of AppSheet).

Now, when you add new pictures or edit old ones, they should appear in your spreadsheet.

[AIZUDDIN_ABD_AZ]

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

[Kirk_Masden]

Could you please share the complete URL?

[AIZUDDIN_ABD_AZ]

My Formula
SUBSTITUTE(CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=",“WorldwideNewworkorder-799210”,"&tableNa...”, “New Work Order”,"&fileName=",AA3), " ", “%20”)

My Url

https://www.appsheet.com/template/gettablefileurl?appName=WorldwideNewworkorder-799210&tableName=New%20Work%20Order&fileName=Work%20Order_Images/7QL35s62TrKp9-QDV7rcMA.Action%20Image%201.085738.png

[Koichi_Tsuji]

Worth visiting our post of

Quick Tips (Easy) : Expression to construct URL to reach to your files 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…

[AIZUDDIN_ABD_AZ]

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.

[Koichi_Tsuji]

This is appsheet formula, can t be used in spreadsheet

Also there is syntax error.

[AIZUDDIN_ABD_AZ]

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:

https://www.appsheet.com/template/gettablefileurl?appName=&tableName=&fileName=Work%20Order_Images%2F7QL35s62TrKp9-QDV7rcMA.Action%20Image%201.085738.png

Result

[Koichi_Tsuji]

Make sure your security/options are set like this.

[AIZUDDIN_ABD_AZ]

I have turned it off, but the result is still the same

[Koichi_Tsuji]

your are wrongly using our tricks.

Quick Tips (Easy) : Expression to construct URL to reach to your files 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.

[AIZUDDIN_ABD_AZ]

Finally it works.

Thank you so much for assisting me and your time. Appreciate it.

[AIZUDDIN_ABD_AZ]

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

https://www.appsheet.com/template/gettablefileurl?appName=WorldwideNewworkorder-799210&tableName=Work%20Order&fileName=

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?

[Koichi_Tsuji]

Your image column is just blank.

[AIZUDDIN_ABD_AZ]

My image column is not blank:

from my app:

My formula

[Koichi_Tsuji]

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.

[AIZUDDIN_ABD_AZ]

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.

[Steve]

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:

help.appsheet.com

Capturing Images

Capturing images using the mobile device's camera is easy with AppSheet.

[jethunder236]

Hi.

May i know where to put the formula in the appsheet? For my case,i want my signature appear in the google sheets