If you want to customize the base layer of your map view, consider ‘XY’ column types. When the column type is marked as ‘XY’ you’ll see the option in your column definition to link to a hosted image (that will serve as your map base layer).
After including a link to the map image, you’ll be able to add points to that image, just like you’d add lat/long points on a map. Your XY coordinates will be percentages across the height/width of the background image (50,50 will be the center).
helo Peter…
im Dewa from Indonesia…
thanks for all the guide n share u been doing recently
its really help me understanding more about Appsheet.
But for this share about XY colum type …
its seems i cannot posible to use any baseimage that i wanted
its any creteria, likewise size picture etc …
plis respond it in fast … i tend to forgot lately
Hi. I struggled with XY column and images for a long time. The trick for me is to store my images (images of general arrangements of buildings for example) in my own website. (http://my-sgf.co.uk/workspace/storage.html) then copy and paste the URL into the Base Data section.
Good luck
Good point, @Steve_Fuller, thanks. Google Cloud is another good option, for those without hosting elsewhere.
Is it possible to specify a URL link that comes from another column in the app? I have a drawings table and I want to add the ability to add multiple (LatLong) markups on each drawing in a separate markup table. The URL of the drawing image is stored in the original drawings table as Link_URL.
I’d certainly think so. You can use an expression to construct the URL however you want.
@Riki_Armstrong you can definitely do this. Here’s an example where each ‘facility’ in an app has an indoor map. To accomplish this, the table of facilities has a column for the XY image value of each indoor map (click on the map icon associated with inspection points to see the indoor maps, and check out the ‘Data’ to see how it’s setup).
https://www.appsheet.com/samples/?appGuidString=12df3bbe-f379-4552-b412-8fe813a28e70
Is there a an “easy” way to upload an image with appsheet, intra app, and then utilize it as the floor plan?
I see your URLs, but where did those come from?
I figured this one out today. Details are at the bottom of this help file
https://help.appsheet.com/ux/views/displaying-images-and-documents
Basically, add a column to your sheet with a formula that points to the image column (where the user uploads intra-app.
Add this formula to the column in Google Sheet:
=SUBSTITUTE(CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=“,” Your app name - number “,”&tableName=”," Your table name “,”&fileName=",+ your spreadsheet column and rowi.e. E2 ), " ", “%20”)
You will have to regenerate the structure in Appsheet to get this formula as the autocomplete.
Use this new column as the background for the XY column.
@Riki_Armstrong Genius, I’m on it!
Thanks, @Peter, Is it possible to then flatting a copy of this map with the data point content layered over the top so it can be used in a report?
@Octfolio_Seb For the moment there’s not a good method for including these in workflows or reports, but looking into it!
@Grant_Stead you could try also to calculate it inside AppSheet.
[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 …
Thanks for that tip. I have a use case where I would like the user to be able to edit the XY location immediately without having to save the record. Would you be able to advise how I could i do this?
@Gerald_Wee you should be able to do this by specifying your XY field as a ‘Quick Edit’ field in the detail view.
HI Peter, belated seasons greetings and thanks for your guidance. I’ve enabled QuickEdit beta on the view as well as set the XY position field as a QuickEdit column, However I still find that the XY location pin for editing is only displayed when I’ve saved the record. I am able to edit the XY location directly from the table view however. Grateful if you could advise again if this is the most expedient route to allow the edit of XY location on the uploaded base image
Hi @Peter your App seems to be broken. I can search for it in the sample Apps, but when I open it, I get a 404 Error.
Thanks for the heads-up, @Fabian, updated the post to include the direct link.
Hi Grant, Did this work for you ?
I also have a use case and am interested if you managed to get this working.
Also, it appears that the XY coordinates are relative to an image (jpg) rather than a pdf.
Appreciate any feedback.
Cheers
Craig
Hey Craig, we now use XY extensively, pushing the boundaries on it for sure. Yes, it needs to be an image. If you use file with a pdf it will look like it’ll work, but really it’s just using the thumbnail, so don’t do that.
All you need to do is have an image column and then reference that image column in your expression for the background XY. (It used to need to be a public URL, but not anymore, way easier now.)
