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