If you have a company logo or some file attachment field that you want to pass down to a child record you have probably found that QuickBase doesn’t list file attachment type fields as a choice when adding lookup fields (like passing a logo from an account table to an opportunity table).
A customer commented to me about this a few days ago and I recall saying… “This is QuickBase, you can do anything with QuickBase”.
Well you can pass file attachments if you want to create a Formula Text field and reference the original attachment field. The Formula Text field will be visible as a lookup field selection and able to be passed by the relationship between the company table and the opportunity table.
[iframe width=”560″ height=”315″ src=”http://www.youtube.com/embed/pDYmsZ9mMiE” frameborder=”0″ allowfullscreen]
The Formula Text field would have to have, “Allow some HTML” checked and something like the following pasted into the formula section (NOTE: When copying and pasting the code below, make sure all the quotation marks are strait up and down and not the curly quotation marks. Copy and paste sometimes converts them.):
Option One: Example of using a hard URL (absolute link). Use Option two below when possible:
Option Two: Example of a relative link to a file attachment (Preferred method):
Example of displaying a graphic with a relative URL:
The [Record ID#] identifies which record and the fid (Field ID) of your File Attachment field would replace the 22 above.How To's | Tagged attachments, file attachment, files, formula text, lookup fields