Discussions

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

    Posted 03-23-2017 20:16
    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?


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

    Posted 03-23-2017 20:53

    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.





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

    Posted 03-24-2017 15:02

    Pricilla,

    I should have pointed out that the "6" in the code for [Company Logo URL] is the Field ID of the [Image] file attachment field. You'd probably need to edit that accordingly for your needs. Sorry about that oversight.



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

    Posted 03-24-2017 20:42
    Thanks Chris... if I do it this way, will the image in the [Company Logo] automatically be updates if new images are added? 


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

    Posted 03-27-2017 11:50
    Yes, it will capture the latest update.


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

    Posted 03-24-2017 04:44
    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.


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

    Posted 03-24-2017 20:49
    Hi Matthew, this worked out perfectly. However, if I update the [image] field the new field which we called [display image] does not update with the current image. Is there something that can be done automatically or manually every time a new image is uploaded so that it can be reflected in the main table page? 


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

    Posted 03-24-2017 21:07
    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...


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

    Posted 03-24-2017 21:18
    Wow, that is super easy...thank you! :-) 


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

    Posted 03-24-2017 21:13
    Also, you can turn off the keeping of revisions in the file attachment field. That will usually prevent this issue as well.


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

    Posted 03-24-2017 21:18
    I will try this too.