Forum Discussion

RussellBeaubien's avatar
RussellBeaubien
Qrew Cadet
5 years ago

Child report on parent record to show photos

I have a parent table "Projects" with a child table of "Supporting Documents"
When viewing a project record I have a table for the child showing all linked supporting documents
Allot of the supporting documents are photos and I would like to have a thumbnail view in this table instead of IMG_****.jpg
FYI: [Document File] is where the attachment is.


------------------------------
Russell Beaubien
------------------------------
Formulas and functions
Relationships
  • MichaelTamoush's avatar
    MichaelTamoush
    Qrew Captain
    5 years ago
    courtesy of Mark Shnier, see below. If you need more help definitely go to him. He consults for me and does an amazing job. Create a formular rich text field with below. Be sure to replace the 15 in both spots (by e15) with your Document File field ID.





    		 var text URL = URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e15/v0/ target=_blank" & "DummydateTime=" & ToText(Now()) & URLEncode(ToText([Document File]));  // that last part is to defeat browser cacheing

    var text words = "<img src="  & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e15/v0/" &  "\" width=\"100\"" & "DummydateTime=" & ToText(Now()) & URLEncode(ToText([Document File])) &">";

    "<a href=" & $URL & ">" & $Words & "</a>"


    // you can set EITHER the width or the height, but do not set both or the image will get skewed.


    ------------------------------
    Mike Tamoush
    ------------------------------