Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoCorrect, the Automaton will not copy across file attachments. But It can copy across a link to view the file attachment.
You can make a formula rich text field on the source table called perhaps [View File]
"<a href='"& URLRoot()&"up/"&Dbid()&"/a/r"& [Record ID#] & "/e7/v0' target='_blank' >" & [File] & "</a>"
where you would replace the 7 with the field ID#of the file attachment field. Get that working on your source table first.
Once that is working, Sync it across to the target table but call it like [View File (raw text)], as it will Sync across as a text field and not a Rich Text field.
Then create a Formula Rich Text field with the good name of [View File] and the formula will just be
[View File (raw text)]
Lastly, there is the pesky permissions issue. Nothing in Quick Base works without Permissions. So either you users will need to have access to those Source table records, or else , most conveniently there is a field property on all file attachment fields to allow EOTI access (Everyone On The Internet).
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
You can make a formula rich text field on the source table called perhaps [View File]
"<a href='"& URLRoot()&"up/"&Dbid()&"/a/r"&
where you would replace the 7 with the field ID#of the file attachment field. Get that working on your source table first.
Once that is working, Sync it across to the target table but call it like [View File (raw text)], as it will Sync across as a text field and not a Rich Text field.
Then create a Formula Rich Text field with the good name of [View File] and the formula will just be
[View File (raw text)]
Lastly, there is the pesky permissions issue. Nothing in Quick Base works without Permissions. So either you users will need to have access to those Source table records, or else , most conveniently there is a field property on all file attachment fields to allow EOTI access (Everyone On The Internet).
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
TimEgerton
5 years agoQrew Trainee
Hi Mark,
Thanks for setting out how to do this and we have it working.
Is there a way, rather than download the PDF, to view in a new browser window?
Thanks
Tim
------------------------------
Tim Egerton
------------------------------
Thanks for setting out how to do this and we have it working.
Is there a way, rather than download the PDF, to view in a new browser window?
Thanks
Tim
------------------------------
Tim Egerton
------------------------------
- MarkShnier__You5 years ago
Qrew Legend
I believe that's a setting in your Browser as you whether to automatically open files of a certain type.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------