Forum Discussion

BenjaminGolden's avatar
BenjaminGolden
Qrew Cadet
6 years ago

Re: Exact Form Report ID

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
------------------------------

3 Replies

Sort By
  • 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
    ------------------------------
    • AdamKeever1's avatar
      AdamKeever1
      Qrew Commander
      6 years ago
      Don't forget Benjamin, there may be others who benefit from you posting this. Someone may run into the same issue and may only be able to solve it because you posted the solution that you found.

      That's the great thing about the community is that it is filled with individuals willing to help others, who don't give up on finding solutions, and who are willing to be vulnerable and ask questions.

      ------------------------------
      Adam Keever
      ------------------------------
  • SteveHoward's avatar
    SteveHoward
    Qrew Member
    6 years ago
    Could you post the full text string?  I tried to follow the separate instructions but get all records and not just the child records.
    Here's what I tried:

    ~=qdb.GetURL("DetailsTableDBID", "API_GenResultsTable^query={13.EX.'"+ field["MasterSourceField"]+"'}^qid=7^ts="+ new Date().getTime());~

    Embedded report number is 7.  Related field is 13.  I substituted the correct info for the DetailsTableDBID and MasterSourceField.

    ------------------------------
    Steve Howard
    ------------------------------