Attach files from Table A to Table B through Pipelines

Question

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

evanmartinez · Answer

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

Both scenarios would be helpful.------------------------------Yudisleydis Perez------------------------------

seanconnaughto1 · Answer

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

Forum Discussion

Attach files from Table A to Table B through Pipelines

3 Replies