Forum Discussion

DanteTognoli's avatar
DanteTognoli
Qrew Captain
6 years ago

exporting photos as links

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?
Forms
Tables and fields
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    6 years ago
    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.