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.

    Bronze
    Contributor
    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.

    Bronze
    Contributor
    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!



  • 4.  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".