Forum Discussion

ASGSystem_Admin's avatar
ASGSystem_Admin
Qrew Member
4 years ago

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 provides for formatting an embedded details table. Does anyone know where the "Report ID" should go?




------------------------------
ASG System Admin
------------------------------
Wizards and add-ons
  • BradLemke's avatar
    BradLemke
    Qrew Assistant Captain
    4 years ago
    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
    ------------------------------
  • MichaelTamoush's avatar
    MichaelTamoush
    Qrew Captain
    4 years ago
    You can also check out a third party app from Jucied Technologies. Their Exact Forms Plus is a nice upgrade over the native EF. Many more options and much easier to add subtables.

    ------------------------------
    Mike Tamoush
    ------------------------------