Forum Discussion

EddyElasmar's avatar
EddyElasmar
Qrew Member
2 years ago

File Attachments In Connected Tables

Should be a simple fix that I cannot figure out for some reason... I have a connected table across two apps that mirror each other for much of their fields. 

Everything transfers over BUT file attachments carry over as text but not as an openable file. both fields are file attachments and both are linked though the connected table. I want it to be so when someone attaches a file in the main table... You can then open that file in the other app's connected table. see below snip for what the connected table looks like... it should be blue/a click to download. Thank You in advance... please help!



------------------------------
Eddy Elasmar
------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend

      A connected Syncc table does not Sync acress files atatchment. But you can make a Rich text formula field to gove the user the appearance of a file attchment whihc they can click on

       

      Basic setup for a Rich Text field 
      var text Words = ToText([File name field]);
      var text URL = URLRoot() & "up/" & "xxxxxxxxx" Dbid() & "/a/r" & [Record ID# of the source table] & "/e99/v0";

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

       

      // replace the 99 with the fid of the file attachment field in the source table.

      // replace the xxxx with the table code

       

      Feel free to post back if you get stuck.

  • Thanks Mark, that makes sense.  I'd just need to make sure the user has access to that table/record/field in the source table, I guess.  

    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend

      Sorry, I forgot something important. Go to the field properties of the file attachment field in the source table and click the setting to allow view access by everyone on the Internet without signing in. That way you don't have to worry about permissions.

      • MFCQB_Admin's avatar
        MFCQB_Admin
        Qrew Member

        Thank you Mark.  I don't think I want to open the aperture that wide, as some of the data could be sensitive, but glad to have a solution that works.