Forum Discussion

RyanRyan2's avatar
RyanRyan2
Qrew Assistant Captain
7 years ago

Can i add a picture of a product to products table?

I wanted to see if I could add a picture of each product to the products table and form. I know I can add an attachment, but I'm looking for the picture to remain up within table and form when i view it. Is there a way to do that?

12 Replies

  • If you can get the URL from the file attachment field then you could make a formula text field that takes HTML tags
    "<img src=\"" & [URL] & "\" />
  • No problem.
    The low tech way to show an image on a form is to use the checkbox on the field properties to show the image.  But that does not work when used on a report.

    To show an image on a report this works

    If(Contains("jpg,jpeg,png,gif", Right([File],".")),

    "<img src=" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e140/v0" & " height=\"150\">"
    , "No Preview Available")

    or just

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


    This would be a formula text field type

    The e140 in the above refers to field ID 140 being the field holding the file attachment.

    Play with the 150 to get the size you like. you can also specify instead width=\"150\"

    Note that if you have a huge report of images, it will take a long time to load the page.
  • RyanRyan2's avatar
    RyanRyan2
    Qrew Assistant Captain
    this was a big help. I got it on the form to show, but it did not show on report. do i need to have the If statement on this second formula or no (i did not add).
  • You do not have to do the IF statement, but if you have records without images, then you will want to suppress the image if the file is not loaded.  otherwise there will be an icon showing of a missing image.