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

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

Qrew Captain

7 years ago

Not tested but I think that the syntax will need to look like this. It will be a formula Rich Text field Type - not a formula URL

var text Words = ToText([File Attachment 1 field]);

var text URL = URLRoot() & "up/" & dbid() & "/a/r" & [Record ID#] & "/e30/v0";

"<a href=" & $URL & ">" & $Words & "</a>"

if you make one of those for each file attachment field, then you should be able to use a List statement in a formula Rich text field to list them.

List("<br>",
[Link 1],
[Link 2],
[Link 3],
[Link 4])

Post back if you have any problems.