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

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
Docs:

https://help.quickbase.com/api-guide/index.html#filemanagement.html

A URL such as this:

https://team.quickbase.com/up/bdb5rjd6h/a/r13/e8/v0

Might be written as a formula like this:

"https://team.quickbase.com/up/bdb5rjd6h/a/r"; & [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.