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

  • 1
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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!
Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb

Posted 1 year ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
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.
(Edited)
Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb

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!

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
No hack. Dumb Luck.  I have that formula saved in my Tips app and I just used it "as is".