Displaying an image in google sheets

[lindsey_allen1]

Hello

I am struggling with the equation that displays images captured in an app in a google sheet. can anyone help?

[Phil]

Have you tried the technique described in topic “Showing Images in Google Sheets” in this article https://help.appsheet.com/en/articles/961605-displaying-images-and-documents

[lindsey_allen1]

Yes. That is what I am struggling with

[Phil]

Can you be more specific?

1. What exactly have you tried?
2. What error, if any, are you seeing?
3. What result are you seeing?

[Joe_Ojay]

@Phil

I have the same problem.

1. I’ve tried exactly the instructions under the heading “Showing Images in Google Sheets”
   using the following formula but replacing my app name, table name, and applicable column and cell number.
   =CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=”, ENCODEURL(“Inventory-114348”), “&tableName=”, ENCODEURL(“Orders”), “&fileName=”, ENCODEURL(+B2)))

Attached is the error page image and the code I used.

I’ve tried and retried, and am pretty sure I have the right table name and app name, unless there’s something I don’t know.

[Westmount_Trans]

Same problem as expressed by @Joe_Ojay

Anyone got a solution to this?

Is appsheet still supporting this feature?

@praveen

[pravse]

That filename is wrong. It shouldn’t be https://docs.google.com/… That is a URL.

Instead, I’d expect it to be something like “Images/Photo1.jpg”

If you already have a url, then you don’t need to construct another url by doing the concatenate, etc.

[doan]

how can I keep the my image on google sheet like picture;

[SkrOYC]

If this is a worksheet you are using on an AppSheet app, you shouldn't be using it with anything else actually.

Think of it as a database.

One of the main points of the usage of an app instead of the worksheet is the fact that you can have rules that protects your data from being deleted or changed.

You shoudln't be using your worksheet and neither your images need to be shown there, just the text path required by AppSheet.

If I was not clear: Your worksheet should be usefull for AppSheet, not for you. AppSheet is the one usefull for you in this case, is the one in the middle

[doan]

It should be possible, app and google sheet is my responsibility. probably, it is related appsheet talent.

[SkrOYC]

It's possible, but not actually recommended.

I use MSExcel so this idea was even easier for me to understand and accept since it needs to be closed for AppSheet to sync.

Now, even if it's possible, as I told before, the usage of an app is directly related to the fact that you can have rules to prevent data corruption, which is the opposite when you have a worksheet open and you can delete info with just an accidental click.

About the thing if GSheet/MSExcel knowledge is related to AppSheet knowledge (which is what I understand from your last sentence) it's not that true sadly.

I mean, I can't say that GSheet/MSExcel skills are useless inside AppSheet but AppSheet is it's own thing. So, it's a similar experience but you won't have a edge just because of knowing GSheets/MSExcel functions.

Actually I saw the opposite, the AppSheet experience helped me to be a better excel user.

Although now I use excel 10% of the time compared to maybe 90% as it were before AppSheet.

So, here you have it. Hope this helps