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
------------------------------