Forum Discussion

Qrew Trainee

7 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

Qrew Captain

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

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
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
  Qrew Member
  2 years ago
  That works, thank you!
  
  ------------------------------
  Sheryl MacGibbon
  ------------------------------