Skip to main content
Question

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

  • February 15, 2018
  • 0 replies
  • 441 views
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?
    This topic has been closed for replies.

    • anomDiebolt
    • Registered
    • February 15, 2018
    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.
    • LeeSGilmore
    • Registered
    • January 10, 2019
    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!
    Terms & ConditionsAccessibility statement