Quick Base Discussions

Expand all | Collapse all

How to add a filtered report into a body of the outlook email

  • 1.  How to add a filtered report into a body of the outlook email

    Posted 06-10-2019 17:28
    I would like to add a certain report into a body of the email. I created an email button to populate the subject and send to. Now I want to add the certain report into the body of the email. Below is my formula for an email button

    Email - Button:
    "mailto:"&""&[PR - CR - Email]&"\n"&"?subject="&"\n"&URLEncode([Email - Subject - Pre Qualification]) &""&"&body="&URLEncode([Email - Body])&"&"

    [Email - Body]
    How do I get a report name "TESTING" from a table called "Tickets"?

    Please help. Thanks in advance.




  • 2.  RE: How to add a filtered report into a body of the outlook email

    Posted 06-10-2019 17:48
    I would be very surprised if this was possible.  More likely you will need to include a link to a report.  The report can be an <ask the user> type wth the question answered in the link.

    not tested, but make an ask the user report and answer the question and mimic the URL.


    URLRoot() & "db/" & [_DBID_table name goes here] & "?a=q&qid=99&nv=1&v0=" & [Related Customer]


    Replace the 99 with your report# and and find a suitable question and answer for your report. 

    Mark