exporting photos as links

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
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?
Photo of Dante Tognoli

Dante Tognoli

  • 682 Points 500 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 12,338 Points 10k badge 2x thumb
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.