Skip to main content
Question

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

  • May 26, 2017
  • 0 replies
  • 72 views
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!

    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.
      • ZintJoseph
      • Author
      • Registered
      • May 26, 2017

      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!

      No hack. Dumb Luck.  I have that formula saved in my Tips app and I just used it "as is".
      Terms & ConditionsAccessibility statement