Forum Discussion

_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
9 years ago

How To Copy File Attachments Between Tables Without Download?

How To Copy File Attachments  Between Tables Without Download? This script is intended to be used from the console in its current form although it would not take much in the way of changes to use i...
APIs and custom code
SiniWickramasin's avatar
SiniWickramasin
Qrew Cadet
6 years ago
Hi Dan,

I know its been a while since this topic had come up. Always fascinated by your solutions like IOL method and so on. Is there anyway we could implement this within QuickBase to work with a button action? For example, if the user clicks on the button, the attachment will be copied over to the attachment field of the target record? I'm very new to JS and struggling to find any solution myself.

Always appreciate what you offer to the community!


------------------------------
Sini Wickramasinghe
------------------------------
HectorAubert's avatar
HectorAubert
Qrew Trainee
6 years ago
Has anyone been able to implement this within QuickBase to work with a button action?

------------------------------
Hector Aubert
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    Outfits like Juiced could be hired to do this, but just to make you aware that it's easy to make a link which behaves like a file down load and which can be referenced by lookups or just a formula field.  So the actually file is not loaded twice, but you have a link which behaves as a file attachment field for viewing.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • HectorAubert's avatar
      HectorAubert
      Qrew Trainee
      6 years ago
      Thanks Mark.  I had seen this option in a separate post.  At first, I dismissed it as an option, but then I had an "Aha" moment and figured out how to make it work for my use case.  I didn't want users to always have access to download the file. So, I created form rules to hide/show the download button (lookup field from parent table) at certain step in the workflow.  Works great!

      Thanks again!

      ------------------------------
      Hector Aubert
      ------------------------------
    • KeithJusas's avatar
      KeithJusas
      Qrew Captain
      6 years ago
      Thanks Mark!

      Demo our file attachment sweep add-on here.
      https://juicedtech.quickbase.com/db/bmzi5qjk7

      ------------------------------
      Keith Jusas
      CEO
      Juiced Technologies, Inc.
      Ronkonkoma NY
      6316175060
      ------------------------------
    • SyaefulBahri3's avatar
      SyaefulBahri3
      Qrew Trainee
      6 years ago
      Hi Mark,

      Can you please tell me step by step to achieve your solution?

      Many thanks

      ------------------------------
      Syaeful Bahri
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        Try this as a Rich Text formula field  on the table where the file is attached.

        "<a href='"& URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e7/v0' target='_blank' >" & [File] & "</a>"

        Replace e7 with eX where X is the fid of the field where the file is attached.  Replace [File] with the field name of the file attachment field.

        The versions above would open in a new window if the attachment was an image

        You can also try it like this

        "<a href='"& URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e7/v0>" & [File] & "</a>"

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------