Skip to main content
Question

exporting photos as links

  • April 10, 2019
  • 0 replies
  • 40 views
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?

    Forum|alt.badge.img+17
    • EvanMartinez
    • Community Moderator
    • April 29, 2019
    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.
    Terms & ConditionsAccessibility statement