Include a report table in a notification email
Hi! I have created a notification that sends an email any time a record is added to a table called "instance." I want to include a report with this email. I've been able to include a link to this report, by adding the following HTML snippet in my custom email message:
<a href="https://myCompany.quickbase.com/db/brckkkkkk?a=q&qid=5&nv=1&v0=[Related Subsystem]">Click here</a>
Side note: The [Related Subsystem] marker makes sure this report filters records that share the same parent record in the Subsystem table.
But what I really want to do is show this report, in the format of a table, in the notification email body itself. I tried using <iframe> to embed the webpage with the report into the email, but that didn't work. Just to be clear, I do not want to create a subscription -- the email needs to get sent when the trigger happens (new record created), not on a daily or weekly schedule.
I would appreciate any advice, thank you!
------------------------------
Aaron Alpert
------------------------------
<a href="https://myCompany.quickbase.com/db/brckkkkkk?a=q&qid=5&nv=1&v0=[Related Subsystem]">Click here</a>
Side note: The [Related Subsystem] marker makes sure this report filters records that share the same parent record in the Subsystem table.
But what I really want to do is show this report, in the format of a table, in the notification email body itself. I tried using <iframe> to embed the webpage with the report into the email, but that didn't work. Just to be clear, I do not want to create a subscription -- the email needs to get sent when the trigger happens (new record created), not on a daily or weekly schedule.
I would appreciate any advice, thank you!
------------------------------
Aaron Alpert
------------------------------
