Embedded Reports on Exact Form
I want to be able to put a custom report in an exact form, and Quick Base Help seems to be missing some important information in its tutorial, i.e. where the Report ID is supposed to go in the code it...
Forum Discussion
Add the highlighted below, replace X with the Report ID of your choice.
~=qdb.GetURL("DetailsTableDBID", "API_GenResultsTable^query={'DetailsFieldID'.EX.'"+ field["MasterSourceField"]+"'}^qid=X^options=nvw.ned.phd.nfg.sortorder-A.groupby-V^slist=DetailsGroupFieldID^ts="+ new Date().getTime());~
In addition, it may be beneficial to you to pull some of the code for the query/table you're building from the 'show expanded url of this report'. You can find this in the 'More' dropdown of the old style interface of the table report.
------------------------------
Brad Lemke
------------------------------
~=qdb.GetURL("DetailsTableDBID", "API_GenResultsTable^query={'DetailsFieldID'.EX.'"+ field["MasterSourceField"]+"'}^qid=X^options=nvw.ned.phd.nfg.sortorder-A.groupby-V^slist=DetailsGroupFieldID^ts="+ new Date().getTime());~
In addition, it may be beneficial to you to pull some of the code for the query/table you're building from the 'show expanded url of this report'. You can find this in the 'More' dropdown of the old style interface of the table report.
------------------------------
Brad Lemke
------------------------------