Discussions

 View Only
  • 1.  exporting photos as links

    Posted 04-10-2019 19:04
    I am exporting data from quickbase into a .kml file for use in google maps. There are photos attached to many of the waypoints but they show up in the .kml file as they look on the form (i.e. photo1.jpg) and not as the URL where the file is located, so they don't appear in google maps. Is there any way to have the URL appear on the form instead of the clickable link?


  • 2.  RE: exporting photos as links

    Posted 04-29-2019 15:55
    Hi Dante, 

    It is possible to get a URL for your file attachment you can create a formula URL field that will pull out the address for your file attachment. I typically use a formula like this:

    URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#]& "/e9"
    Then you just have to change e9 to be the field id of your file attachment field. So if your file attachment field has a field id of 13 you would just have /e13. Then you can export that field instead of the file attachment field and it will give you a URL. I hope that is helpful.