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

  • 3
  • 2
  • Question
  • Updated 4 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

  • 92 Points 75 badge 2x thumb

Posted 1 year ago

  • 3
  • 2
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,074 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.
Photo of Lee Gilmore

Lee Gilmore

  • 790 Points 500 badge 2x thumb
This was very helpful! In sync tables from one app to another, attachments do not pass through in the sync. However, I was able to create a formula URL for the file attachment with this information which I can pass through the sync. Thanks for the help!