Discussions

Expand all | Collapse all

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

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

    Posted 02-14-2018 22:14
    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?


  • 2.  RE: Is there a formula that will retrieve the url of a file attachment field?

    Posted 02-14-2018 22:38
    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.


  • 3.  RE: Is there a formula that will retrieve the url of a file attachment field?

    Posted 01-09-2019 20:11
    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!