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 ...
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
------------------------------