Forum Discussion

ASullivanFFRASu's avatar
ASullivanFFRASu
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's avatar
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.  
ASullivanFFRASu's avatar
ASullivanFFRASu
Qrew Trainee
7 years ago
I am missing something, I am sure:

var text Words = ToText([FFSP Top 5 Cover Sheet]);
var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0";
"<a href=" & $URL & ">" & $Words & "</a>"

var text Words = ToText([Publication Submission: Fleet & Family Support]);
var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0";
"<a href=" & $URL & ">" & $Words & "</a>"

var text Words = ToText([CYP Top 5 Cover Sheet]);
var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0";
"<a href=" & $URL & ">" & $Words & "</a>"

var text Words = ToText([Publication Submission: Child & Youth]);
var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0";
"<a href=" & $URL & ">" & $Words & "</a>"

var text Words = ToText([Housing, Lodging, Navy Getaways Top 5 Cover Sheet]);
var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0";
"<a href=" & $URL & ">" & $Words & "</a>"

var text Words = ToText([Publication Submission: Housing, Lodging & Navy Getaways]);
var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0";
"<a href=" & $URL & ">" & $Words & "</a>"

var text Words = ToText([SFA Top 5 Cover Sheet]);
var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0";
"<a href=" & $URL & ">" & $Words & "</a>"

var text Words = ToText([Publication Submission: Sports, Fitness & Aquatics]);
var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0";
"<a href=" & $URL & ">" & $Words & "</a>"

var text Words = ToText([REC Top 5 Cover Sheet]);
var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0";
"<a href=" & $URL & ">" & $Words & "</a>"

var text Words = ToText([Publication Submission: Recreation Programs]);
var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0";
"<a href=" & $URL & ">" & $Words & "</a>"

var text Words = ToText([LIB Top 5 Cover Sheet]);
var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0";
"<a href=" & $URL & ">" & $Words & "</a>"

var text Words = ToText([Publication Submission: LIBERTY Programs]);
var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0";
"<a href=" & $URL & ">" & $Words & "</a>"

var text Words = ToText([FBE Top 5 Cover Sheet]);
var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0";
"<a href=" & $URL & ">" & $Words & "</a>"

var text Words = ToText([Publication Submission: Entertainment & Dining]);
var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0";
"<a href=" & $URL & ">" & $Words & "</a>"

List(", ",
[FFSP Top 5 Cover Sheet], [Publication Submission: Fleet & Family Support], [CYP Top 5 Cover Sheet], [Publication Submission: Child & Youth],  [Housing, Lodging, Navy Getaways Top 5 Cover Sheet], [Publication Submission: Housing, Lodging & Navy Getaways], [SFA Top 5 Cover Sheet], [Publication Submission: Sports, Fitness & Aquatics], [REC Top 5 Cover Sheet], [Publication Submission: Recreation Programs], [LIB Top 5 Cover Sheet], [Publication Submission: LIBERTY Programs], [FBE Top 5 Cover Sheet], [Publication Submission: Entertainment & Dining])