Is there a formula that will retrieve the url of a file attachment field?

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
I'd like to create a field that returns the url of a file attachment in quickbase.  Is there a function in quickbase that will return the url of an attached file?
Photo of Gary


  • 52 Points

Posted 9 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,522 Points 20k badge 2x thumb

A URL such as this:

Might be written as a formula like this:

""; & [Record ID#] & "/e8/v0"

The essential part is the [Record ID#]. The fid "8" and version "0" are usually hardcoded. The front part of the URL might use the formula function DBID() rather than hardcoding it.