Forum Discussion

AudreyBenenati's avatar
AudreyBenenati
Qrew Cadet
6 years ago

Embedded Report on Exact Form

​These instructions seem to skip a step.

An embedded table displays with no grouping or subtotals. You can change this by typing the following formula on your exact form:

~=qdb.GetURL("DetailsTableDBID", "API_GenResultsTable^query={'DetailsFieldID'.EX.'"+ field["MasterSourceField"]+"'}^options=nvw.ned.phd.nfg.sortorder-A.groupby-V^slist=DetailsGroupFieldID^ts="+ new Date().getTime());~

...

You'll need to replace the following values in this formula with your own information, as outlined in the table below:

You replace...

With the...

DetailsTableDBID

Database identifier of the details table from which the embedded report comes.

Note: The Details Table DBID needs to be inside quotation marks.

It goes on to list every single bolded field in the code and what you should replace it with. Except the last one does not correlate to any bolded or non-bolded field in that code.

My report ID is 20. Now where to I place that info?

Report ID

Identifier for the table or grid edit report you'd like to use as the embedded details table. When you display the report in Quick Base, the identifier is after qid= in the URL.


Thanks

------------------------------
Audrey
------------------------------
  • Audrey,
    try replacing
    query={'DetailsFieldID'.EX.'"+ field["MasterSourceField"]+"'}
    with
    qid=99

    where 99 is the value of the report id

    Keith

    ------------------------------
    Keith Jusas
    ------------------------------