Skip to main content
Question

How do I get an Image (file attachment field) to appear on the list report of main table page?

  • March 24, 2017
  • 0 replies
  • 177 views
How do I get an Image, which is currently a field in a form as a "file attachment", to appear as a much smaller version on a list report pertaining to that table?
      This topic has been closed for replies.

      • ChrisChris
      • Registered
      • March 24, 2017

      You can use this code to capture the URL of the object in the file attachment field::

      Below is a URL field. Call it [Company Logo URL]

      URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e6/v0/" & [Image]

      [image] is the file attachment field.

      ===

      Then....

      Create a formula text field. Call it [Company Logo]

      "<img src='" &[Company Logo URL]& "' width='148px' alt='"&[text field with text]&"' title='"&[text field with text]&"'>"

      Put [Company Logo] in your report.



      • MCFNeil
      • Registered
      • March 24, 2017
      Or you can just go straight to the formula text field for the image, and use something like this:

      "<img height=\"80\" src=\"" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e41/v0\" />"

      changing the "41" to the field ID of your file attachment field.
      • MCFNeil
      • Registered
      • March 25, 2017
      So QuickBase and Browsers seem to have a caching issue when files are updated.

      If you upload a new file and you are testing it in your same browser session, you will want to clear your cache / history.  Then re-view the image.

      odd I know...
      • EricJHansen
      • Registered
      • March 25, 2017
      Also, you can turn off the keeping of revisions in the file attachment field. That will usually prevent this issue as well.
      Terms & ConditionsAccessibility statement