Skip to main content
Question

Storing and Display Image Library

  • August 8, 2019
  • 0 replies
  • 81 views
Forum|alt.badge.img+11
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):
  • Tables
  •   Projects
  •   Daily Reports
  •   File Attachments
  • Relationships
  •   Projects have many Daily Reports
  •   Daily Reports have many file attachments

On my daily reports I have an add photo button and a table below which shows the file names.  It does not show the images.  how do I get the images to show on the form?  In addition, from a mobile experience how will this work?  Will my users easily be able to take photos from their phone and upload to the daily report?  That is ideal...

I did just buy exact forms plus so I am not sure if I need to do it through that (my training with them is tomorrow)


    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.
    You can see this in action in an app on the exchange where this feature was demonstrated at the most recent Empower... search the app exchange for EMPOWER2019 Advanced formulas
    Terms & ConditionsAccessibility statement