Discussions

Expand all | Collapse all

Child report on parent record to show photos

  • 1.  Child report on parent record to show photos

    Posted 7 days ago
    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
    Child table on Project RecordAllot 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
    ------------------------------


  • 2.  RE: Child report on parent record to show photos

    Posted 7 days ago
    Edited by Mike Tamoush 7 days 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
    ------------------------------