Forum Discussion

Qrew Elite

8 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

Qrew Cadet

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

Qrew Trainee

5 years ago

Has anyone been able to implement this within QuickBase to work with a button action?

------------------------------
Hector Aubert
------------------------------

MarkShnier__You
Qrew Champion
5 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
  Qrew Trainee
  5 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
  Qrew Captain
  5 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
  Qrew Trainee
  5 years ago
  Hi Mark,
  
  Can you please tell me step by step to achieve your solution?
  
  Many thanks
  
  ------------------------------
  Syaeful Bahri
  ------------------------------
  - MarkShnier__You
    Qrew Champion
    5 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
    ------------------------------