Forum Discussion

BenjaminGolden's avatar
BenjaminGolden
Qrew Cadet
6 years ago

Exact Form Report ID

Quick question, 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.
AAnyone know where the Report ID should be in the formula? Thanks!


------------------------------
Ben Golden
------------------------------
Wizards and add-ons
  • EverettPatterso's avatar
    EverettPatterso
    Qrew Captain
    6 years ago
    Try to replace the query with qid

    ~=qdb.GetURL("DetailsTableDBID", "API_GenResultsTable^qid=1^ts="+ new Date().getTime());~​





    ------------------------------
    Everett Patterson
    ------------------------------
    • BenjaminGolden's avatar
      BenjaminGolden
      Qrew Cadet
      6 years ago
      Thanks, but I'm trying to generate a report in the form that only contains the child records, this shows all records in the table.

      ------------------------------
      Benjamin Golden
      ------------------------------
      • BenjaminGolden's avatar
        BenjaminGolden
        Qrew Cadet
        6 years ago
        Alright, so coming clean: the mistake I made was assuming that, because QuickBase Help mentioned a Report ID and there wasn't one specified in the code, the code I had wasn't working because I didn't have a report ID in there. As it turns out, my problem was the fact that the single quotes should be omitted from 'DetailsFieldID' (e.g. 6.EX. instead of '6'.EX.) I apologize for any confusion I may have caused, and at the very least I've learned from my mistake and shouldn't have a problem fixing my form.

        ------------------------------
        Benjamin Golden
        ------------------------------