LinkedIn
Twitter
Hello
I am trying to overlay an AUTOCAD drawing (converted to PDF then PNG) which I have uploaded to google drive
I have X/Y coordinates setup in data so I can use pinpoints which will show more data about it
It shows the pin but just grey nothing image on the map display. I thought it might be an image problem so I tried a random pic of a tiger, still same issue
I tried changing host (image host) to Unsplash still same thing?
I have embeded the google drive link with " in the expressions and nothing works!
I'm quite desperate to get this to work :)(
Hi.
Please show the table where your file is.
Here is a configuration I can suggest :
You must have at least two columns, an XY column and a File column.
In your XY column : Set the formula in the parameter 'Background image for your XY column' as [drawingcolumn]
Then, set the drawing column as a File instead of Image type (even if it contains PNG). I suggest to insert the PNG through appsheet (you must enable file sharing in your app security options), but you can try to add the link in the File folder path in the column settings.
Lastly, to be sure, the 'map column' parameter in the view should be a reference to your XY column (the one with the background image). It should work 🙂
Hello - thanks so much for replying
I will try your solution if I can figure it out but here is a picture of the table
Location XY is where the backround image lives that isn't working currently
Stand by while I try your solution - just to note will this still allow me to enable actions and behaviour where the pin is clicked and it will link to data at that location?
@Klomorax wrote:Stand by while I try your solution - just to note will this still allow me to enable actions and behaviour where the pin is clicked and it will link to data at that location?
I just remembered that having two tables is the best way to manage this, sorry 😅
I'll provide you a full tutorial, it should work.
First, disable "secure pdf access".
Let's say you want to have multiple drawings and to each, multiple pins to add. Best way to do this is to create a table for the pins. This is how to set it :
You must have two tables, one for the pins (i'll call it PinTable), the other to store drawings (i'll call it MapTable).
1) Create the PinTable. Inside, have at least those columns :
- XYPoint (XY type) In the settings of this columns, set background parameter formula as "[MapID].[Map Image]"
- PointID (Text type, key column with UNIQUEID() as Initial value)
- MapID (Ref type, to the table with the maps)
2) Create (or use the one you have) the MapTable
Create at least those columns :
- MapID (Text type , key column, uniqueid() as initial value)
- DrawingName (the name of your drawing, text type)
- Map Image (File type, this is where you insert your PNG drawings, it's the column u can see in the formula in the screen above)
3) Create two ref views :
List of drawings : a table view type of the MapTable view.
Map view : a map view type of the PinTable view.
4) Create a dashboard view and add the two views you created. Turn on interactive mode.
5) Configurate the map view :
- Map column : XYPoint
- Secondary data table : PinTable
- Secondary data column : XYPoint
That's it. Now, you can edit each drawing from your dashboard view. As it's in interactive mode, ref rows will be selected when you select a drawing. So when you select a drawing, each related pins that you created will be shown.
With this, you only have one layer of referenced data to your drawing. If you want more, just add a new table, with a PointID column set as Ref to PinTable. Then, inside each Pins, you will be able to add new data rows.
To configure actions, just add actions and columns to the PinTable table.
