Forum Discussion

ZintJoseph's avatar
ZintJoseph
Qrew Captain
8 years ago

Has anyone used the the Actions feature to copy a file attachment from one table to another.

Has anyone used the the Actions feature to copy a file attachment from one table to another. That is the only field that does not seem to transfer. I have created an app to house customer approval ...
File attachments
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Well here is a work-a-round.  In the source table create this formula URL field

URLRoot() & "up/" & dbid() & "/a/r" & [Record ID#] & "/e30/v0"

 and change the e30 to eXX where XX is the fid of the field with the file attachment.

You can then test that in the source app.  It should download the file when clicked.

Set the field properties for that file attachment field to check the box to allow public access (ie to view).

Then copy across that link with your Action.
HemaRajendran1's avatar
HemaRajendran1
Qrew Trainee
4 years ago
Hi Mark, I tried using this formula in my Source table(Table 1) to copy the attachment document from Table 1 to Table 2. Quickbase Action is creating a record in Table 2 but the URL/Attachment is not copied. Can you please help me with this.

TIA

------------------------------
Hema
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago

    Hema,

    I think you misunderstood my post. That code will allow you give the user a link to display the file attachment by clicking a link on a different table from where the file attachment was loaded. 

    It will not copy the actual file to another table. 



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • HemaRajendran1's avatar
      HemaRajendran1
      Qrew Trainee
      4 years ago
      Got you! Thank you for the clarification.
      I'm trying to move a set of file Attachments from Table 1 to its own (New) table( Document table). Is there a way to do it without downloading and attaching the Documents multiple times?

      TIA

      ------------------------------
      Hema
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        I don't know of a no code solution.  If its a one time thing and not too large, then just do it manually.  If it's a one time thing but you have hundreds of files, then you can contract Juiced to move them.

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