Storing and Display Image Library
I am creating a "daily report" for my project managers. When they visit a jobsite they need to create a daily report of what transpired that day with photos. My tables (with relationships are): ...
Forum Discussion
Here is a formula which will display a preview of the image
IF(ToText([my file attachment field])<>"",
"<img src=" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e6/v0' width='300' >")
)
Replace the e6 with e and the field ID# which has the file attachment.
Set either the width or the height parameter but don't use both.
Yes, mobile can easily upload pictures from your camera roll and I think also from taking a picture.
Juiced Exact Forms Plus is a great add n, but will not solve for this issue. it's purpose is to generate a PDF or Word document file attachment, although the generated document can also show images.
IF(ToText([my file attachment field])<>"",
"<img src=" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e6/v0' width='300' >")
)
Replace the e6 with e and the field ID# which has the file attachment.
Set either the width or the height parameter but don't use both.
Yes, mobile can easily upload pictures from your camera roll and I think also from taking a picture.
Juiced Exact Forms Plus is a great add n, but will not solve for this issue. it's purpose is to generate a PDF or Word document file attachment, although the generated document can also show images.
- But that would go in the file attachments table right? I need to get this in the parent table. My thought on juice exact forms was it might be easier to create a pdf report that just shows the image vs try to do it on a form. Wasnt sure about that
- There is a way to float the images up to the Parent Record, but why do you need that, won�t you be viewing a single parent record on the parent form and you can have an embedded report of all the file attachments, with each row of the embedded report showing the image.
- Ah I see what you are doing! i didnt connect it that way with the field visible on the report. hence why I am still new and you are a whole lot more experienced lol. I will give that a try.
