Forum Discussion

YudisleydisPere

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

Quickbase Staff

3 years ago

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