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

Actually, I think it needs a slightly different syntax if you were going to list them together. I will post back to this forum in the next hour or two. In the car right now.

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.

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])

Sorry, *without* the dbid(_DBID_Publication_Tracking)

Error says there are extra characters beyond the formula:
var text Words = ToText([FFSP Top 5 Cover Sheet]);
var text URL = URLRoot() & "up/" & dbid() & "/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() & "/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() & "/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() & "/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() & "/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() & "/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() & "/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() & "/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() & "/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() & "/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() & "/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() & "/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() & "/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() & "/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])

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)

That worked! Thank you!

Thx for letting me know that we got there. :)