Best way to link the same Excel file to every record in a table?

  • 1
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have an Excel file that I would like to be a default attachment to every record in a table. Thought I could do this through a relationship to an "Attachments" table but that doesn't seem like it works. Also acceptable would be a button on the record that opens the file versus it being an attachment. Thoughts?

Photo of Chris_MCD


  • 0 Points

Posted 3 years ago

  • 1
  • 1
try this as a formula URL field

URLRoot() & "up/" & [_DBID_DOCUMENTS] & "/a/rXXX" & "/e11/v0"

where XXX is the record ID where the document is attached, and 11 is the field ID# of the field that holds the attachment and _DBID_DOCUMENTS is th table name form the Advanced Properties of the table that hides the attachment.