How can I get a chart report to display on a triggered notification?

  • 0
  • 2
  • Question
  • Updated 2 years ago
  • In Progress
So I have a form on one table that is used only for reporting needs. It displays multiple report links from various tables within the application directly on the form. This allows me to trigger a report with various different reports based on a record change. My question is this.
How can I get a chart report to display on a triggered notification? On my form I can add a report link to the form, select a chart report and it will display when I hit preview but when the notification is triggered the chart reports that are supposed to display in the e-mail only state "Show details in a new tab".
Photo of Peter

Peter

  • 30 Points
  • like i should be able to do this without asking for help

Posted 2 years ago

  • 0
  • 2
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
From my experience and a little understanding of how the QuickBase reports work.  They are very data heavy.  And require an individual query to generate, separate from the general form data.

As such, this might be a little too much to be sent in an HTML enabled email.  They have the reports "Show details in a new tab". to help keep the message size down, and avoid email errors.

This would be a great enhancement in future releases of QuickBase.
I believe it is possible to embed a dynamic image in a notification based on a pic stored in a file attachment field on a record. We could potentially find a way (with some code) to create an image snapshot of the report and save it to a file attachment field which would drive the formula text field to display the image in the email. It's sort of convoluted but probably doable.