Forum Discussion

Qrew Member

3 years ago

Attach files from Table A to Table B through Pipelines

Is it possible to attach a file from Table A to Table B through Pipelines? If so, could you provide the steps? ------------------------------ Yudisleydis Perez ------------------------------

Pipelines

EvanMartinez

Quickbase Staff

Hi Yudisleydis,

Do you want the file attachment to be attached in both tables or would it be helpful to have a link in Table B that would allow your users to access the file attachment in Table A without having to duplicate the attached file?

------------------------------
Evan Martinez
------------------------------

YudisleydisPere

Qrew Member

3 years ago

Both scenarios would be helpful.

------------------------------
Yudisleydis Perez
------------------------------

SeanConnaughto1
Qrew Cadet
3 years ago
If you only need the ability to download through either table, you could use pipelines to link the two tables via a relationship. You can create a field on the attachment table and use the following formula:

URLRoot() & "up/" & [DB NAME HERE] & "/a/r" & [Record ID#] & "/***INSERT ATTACHMENT FIELD ID HERE***/v0"

If you use the formula above, it will give you a download link to the attachment. You can use a lookup field and convert it to a button if you want it to look nicer than a link on the form.

------------------------------
Sean Connaughton
------------------------------