Discussions

Expand all | Collapse all

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

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

    Posted 05-25-2017 21:00
    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 responses. I am using Actions to create a new record in that cross link app table so that I can set up the email as Public and embed the Accept/Decline response and feed it back to the parent app and record. I can get everything to transfer except the actual attachment..it does not even create a link. Trying to keep this simple for the simple mind

    Thanks for any help!


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

    Posted 05-25-2017 21:20
    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.


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

    Posted 27 days 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
    ------------------------------



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

    Posted 27 days 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
    ------------------------------



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

    Posted 27 days 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
    ------------------------------



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

    Posted 27 days 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
    ------------------------------



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

    Posted 05-25-2017 21:30

    Thanks Mark...that was the ticket....it worked great

    By the way, how did you know that the filed was actually 30....did you hack my app!



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

    Posted 05-25-2017 21:50
    No hack. Dumb Luck.  I have that formula saved in my Tips app and I just used it "as is".