File Attachments In Connected Tables

Question

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.&nbsp;
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------------------------------

mfcqb_admin · Answer

I would like to know if this is possible too. &nbsp;EddyElasmar did you ever solve this issue?

markshnier__you · Answer

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.

mfcqb_admin · Answer

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

markshnier__you · Answer

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 · Answer

Thank you Mark.&nbsp; 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.

Forum Discussion

File Attachments In Connected Tables

6 Replies