Forum Discussion

BlakeBurns1's avatar
BlakeBurns1
Qrew Member
6 hours ago

Displaying QR Code Attachments on Forms

Hello!

I'm trying to set it up so a user can upload QR Code images to a file attachment field and then have that QR Code display on a invoice form. However, while I can set the attachment field to display the image of the QR code on the form, when I go to print the form it instead displays it as the .png file name.

Is there some way I can get a file attachment field to display as an image when printing a form, or is there a better way to go about this?

Thank you in advance!

Forms

1 Reply

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 hours ago

    Try this syntax as a formula Rich Text field.  It should defeat the known image caching issue that Quickbase has as long as the file name changes if the user uploads a new file to replace one they just uploaded.

    "<img src=" & URLRoot() & "up/" & Dbid()
    & "/g/r" & QB32Encode([Record ID#])
    & "/e" & QB32Encode(12) // 12 is the fid of the file attachment field
    & "/va/" & URLEncode([Picture]) // my file field is called [picture]
    & " width=30>" // adjust the width or alternatively use the parameter "height=30 .... instead