How to format Image to be used in XY field type?

AppSheet AppSheet Q&A
1

Hi,
I have an ENUM filed called SELECT IMAGE with base type image.
I have another field called DEFECT LOCATION with XY field type.

I want to use Image from the SELECT IMAGE field to be the base image for DEFECT LOCATION field.

It is straightforward if the image is .jpg or .png.

But in my case, the Images are google drive links which I converted to this format
(https://drive.google.com/uc?export=view&id=[FILEID]" to be able to show them in the app. And it works I can show the images in the SELECT IMAGE field.

But it doesn’t pick the Image in XY field type (Background image for the XY coordinates). (Maybe because the image is not .jpg or .png)

Is there any way to achieve this without having to put .jpg or .png files in SELECT IMAGE field. There will be 100’s of images and converting them all to .jpg or .png is a big hassle.

@praveen @Aleksi

1 Like
2

What format are the files in?

Also, if you remove the select image field, how will people select which image they wish to use as the XY background?

3

Hi,
The files are google drive links.
For ex : https://drive.google.com/uc?export=view&id=1vyq04CjqMXsag953NCd7xZNDB-jI2-GT

And I won’t remove the Select image field. It is required to let people select the base image for XY background.

Can we make the image file in above format work for XY background?
I know it works when I have .jpg or .png file.

4

This might be something to do with only those types being supported.

@Aleksi

5

This should work. Are your images shared as “Anyone on the internet can find and view”?

1 Like
6

As far as I see, the Background image for the XY coordinates has to be an URL (or an expression that creates an URL). Perhaps it will not work with a Google Drive Link.

Maybe you could try this workarround?

[Convert an image to XY](https://community.appsheet.com/t/convert-an-image-to-xy/14190/3) Questions

I found a solution. Please correct me if I’m wrong. In the XY Column you can use the “Background image for the XY coordinates” expression: CONCATENATE( “https://www.appsheet.com/template/gettablefileurl?appName=My_App-12345&tableName=My_Table&fileName=” , [Ref_Column].[Image_Column]) This would produce a link that will not work: https://www.appsheet.com/template/gettablefileurl?appName=My_App-12345&tableName=My_Table&fileName=My_Table::My_Table_Images/0afb8fcb.Image_Column.091309.jpg …

1 Like
7

You can use image from Google Drive with the syntax https://drive.google.com/uc?export=view&id={fileID}. Though that image needs to be shared as "Anyone on the internet can find and view”

3 Likes
8

Thank you @Aleksi for this valuable information.

9

Thanks, Aleksi. It works perfectly.

10

You’re welcome

11

Hey Aleksi,

I just raised another issue.
If possible can you please assist with this?

[New Bug Encountered: Workflow emails not working](https://community.appsheet.com/t/new-bug-encountered-workflow-emails-not-working/14446) Questions

I am having issues with my workflows since yesterday. A couple of my apps have stopped sending emails and giving the attached error below. Not sure why this is happening as everything was running smoothly a couple of days ago. Is this a bug?? When I test the workflow it gives the following error. "The URL was: /template/showtable?appName=133660c8-f4b8-4ee0-bc8e-d6bf0a58aa94&locale=en-GB&location=0%2C%200&tzOffset=-330&workflowRuleName=Send%20Quote%20-%20English Illegal characters in path. …

12

Answered in that post.

1 Like
13

Hello, If I have an image called picture1 on my google drive folder: /My Unit/Images, what would be the {fileID}?

14

3X_4_6_463019d6aa8deb33dc0971e72adfaa9f0719e188.png
3X_4_6_463019d6aa8deb33dc0971e72adfaa9f0719e188.png951Ă—571 23.7 KB

https://docs.meiro.io/books/meiro-integrations/page/where-can-i-find-the-file-id-on-google-drive

2 Likes
15

Thanks @Yogesh_laddha,
The key for me was realising that the default link format from Google Drive did not load but your format with the ID from the default link does. I was tearing my hair out until I found your suggested link format. Many thanks again.

3 Likes