Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
6 years ago

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):
  • 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)


Forms
Relationships
reports and charts
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    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.
    • IvanWeiss's avatar
      IvanWeiss
      Qrew Captain
      6 years ago
      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
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      6 years ago
      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.
    • IvanWeiss's avatar
      IvanWeiss
      Qrew Captain
      6 years ago
      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.
  • AlexCertificati's avatar
    AlexCertificati
    Qrew Cadet
    6 years ago
    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