Forum Discussion

ASullivanFFRASu's avatar
ASullivanFFRASu
Qrew Trainee
8 years ago

I would like to list the attachments in a single field, to be referenced using a relationship in another form?

I have attachments within Table A, called Publication Tracker, and I would like to quickly access these attachments via single field, both for a report and so I can ideally pull this info into another...
Ask about Quickbase functionality
File attachments
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
You do not need to concatenate the actual file attachments, you need to concatenate a link to each file attachment.

Here is the syntax to make a link to display a file attachment.  Get it working on the parent table and then use it in any List (...) formuals or lookups


URLRoot() & "up/" & dbid() & "/a/r" & [Record ID#] & "/e30/v0"


Replace the 30 with the fid of the field holding the file attachment and you are all set.  
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Let's get just a smaller link working before you got crazy with 10 links.  This formula would be in the Parent record.

You need to change the 99 in the example below to the respective field ID's where the file attachments are stored.  


var text WordsONE = ToText([FFSP Top 5 Cover Sheet]);
var text URLONE = URLRoot() & "up/" & dbid() & "/a/r" & [Publication Submission#] & "/e99/v0";

var text LinkOne = "<a href=" & $URLONE & ">" & $WordsONE & "</a>";

var text WordsTWO = ToText([Publication Submission: Fleet & Family Support]);
var text URLTWO = URLRoot() & "up/" & dbid() & "/a/r" & [Publication Submission#] & "/e99/v0";

var text LinkTWO = "<a href=" & $URLTWO & ">" & $WordsTWO & "</a>";

List("<br>", $LinkONE, $LinkTWO)
  • SherylMacGibbon's avatar
    SherylMacGibbon
    Qrew Member
    2 years ago

    Hi,

    From above,

    List("<br>", $LinkONE, $LinkTWO) 

    How do you have the list not show blanks?

    Thank you!



    ------------------------------
    Sheryl MacGibbon
    ------------------------------
    • ChayceDuncan's avatar
      ChayceDuncan
      Qrew Captain
      2 years ago

      The List formula won't account for blanks - you would have to change the method to potentially do an ordered list HTML element, or you could just check if it's blank with an if statement like so: 

      If( $linkOne != "", $linkOne & "<br>", "") & 

      if( $linkTwo != "", $linkTwo & "<br>","")

      ...

      So on and so on



      ------------------------------
      Chayce Duncan
      ------------------------------
      • SherylMacGibbon's avatar
        SherylMacGibbon
        Qrew Member
        2 years ago

        That works, thank you!



        ------------------------------
        Sheryl MacGibbon
        ------------------------------