I already got help from the forum and now I still need it!
I wanted to use this spreadsheet project which works fine with text and numbers, but I don't know how to show the images of column "c" from the app when I press search
Could I have suggestions?
thanks
images.aia (964.3 KB)
link spreadsheet.txt (100 Bytes)
TIMAI2
January 21, 2021, 10:13pm
2
Which project ?
Show the "images" in column C ?
Where are the images stored?
Do you want to display them one by one or all at the same time ?
Also:
Before you ask a question / open a new topic
please take care of the following points:
The forum was previously searched for similar topics / issues.
Give a precise (detailed) description of
the issue / bug,
the goal.
Show the (relevant) blocks (images, screenshots of blocks in high quality).
Debug your blocks (connect to Companion and right mouse click: β Do it).
Name the Android / iOS version running on your (test) device.
Do not open multiple threads on the same topic.
If you haven't alβ¦
TIMAI2
January 21, 2021, 10:15pm
4
You will need to provide more details and information about what you are trying to achieve...
TIMAI2
January 21, 2021, 10:30pm
8
They are not images or links to images, but char() characters (can't see/access them in your view only sheet)
I do not think this will not work...
in column c of the spreadsheet there are images
TIMAI2
January 21, 2021, 10:34pm
10
OK, how are these "images" entered into the cells / where are they from ? I made a copy of the sheet, if i try to edit the cell i get a blank.
they come from my computer and I insert them in the cell through the menu insert image of the spresdsheet
Do you think it is not possible to do?
TIMAI2
January 21, 2021, 10:42pm
14
OK I see.
This will not work. Google Sheets stores images to cell in a different way and there is no "file" available.
You will need to upload your computer images to google drive and link to the files there, so that the file can be downloaded to the app, or the url is available to display the image online.
1 Like
I put the link in the cell but in the app I see the link and not the image
Maybe I should use Webviever in the app?
TIMAI2
January 21, 2021, 10:54pm
17
For example
You have an image file on your google drive that anyone can view. If you right click on the file at "GetLink", you will get this:
https://drive.google.com/file/d/1bTfY-Np3v4bHhRJOh1WJV9virrxmezJ7/view?usp=sharing
you need to change the url as below.
you will need this in your cell to show the image:
=image("https://drive.google.com/uc?export=view&id=1bTfY-Np3v4bHhRJOh1WJV9virrxmezJ7")
and this as a url to access the file from the app (place in the next cell)
https://drive.google.com/uc?export=view&id=1bTfY-Np3v4bHhRJOh1WJV9virrxmezJ7
I modified the link as you told me and pasted it in the sheet in C3, from the app but I don't see the image sorrylink image modify.txt (178 Bytes)
TIMAI2
January 21, 2021, 11:21pm
20
Does "image" need to be in French (en francais) ? for your spreadsheet locale ?
TIMAI2
January 21, 2021, 11:23pm
22
Can't see any other reason why the image is not showing in the sheet....
No in the sheet you see it is from the app that I do not see it
TIMAI2
January 21, 2021, 11:40pm
24
This is odd, it is not working for me either now. Sometimes the image will show on startup, but then disappears. I see that others have the same issue.
If you need to view the image on the sheet, maybe you need to use your previous method, but you will need the cell with the url in order to see the image in your app.