Populate table data in Dashboard summary report when clicked on Pie chart slice in the same Dashboard page.

I do not have an answer to your specific question but I will say that it is possible to click on the left-hand column of a summary report and execute a URL as opposed to drilling down into the summary table itself.


I�m not sure if that is helpful but if there�s no solution to your pie chart problem perhaps someone could click on a summary report as opposed to a pie chart as a second best option and accomplish what you want.


Basically the left-hand column of a summary report can be whatever words you want and any action you want when that link is clicked.

That same functionality can also apply to the column headings of a summary report where they are using a group by function on columns

Thanks for the reply QuickBaseCoach. Can you please provide an example using drilldown in summary report. Thanks in advance.

You can make a Hyperlink field and use that as the group by for the rows of your summary report.

The Syntax for a general hyperlink field is a formula Rich Text field 

var text $Words = [your field name here foe the words];
var text $URL = [The URL formula field or formula field you want to execute]; 

"<a href=" & $URL & ">" & $Words & "</a>"

now whether this syntax will work is dependent on the complexity of the  URL.  It should work if you just do one API call.

Like this

var text URL= URLRoot() & "db/" & [_DBID_TABLE_1] & "?act=API_EditRecord"
& "&rid=" & URLEncode ([Record ID#])
& "&_fid_7=" & URLEncode ([Status])
& "&apptoken=" & "XXXX";


"javascript:" &
"$.get('" & 
$URL & 
"',function(){" &
"location.reload(true);" &
"});" 
& "void(0);"

I suggest getting the URL formula field working first, and then getting the Hyperlink to work

Thank you very much. I will try this approach.