Forum Discussion

MattMakris's avatar
MattMakris
Qrew Assistant Captain
3 years ago

List unique parent record counts in child table Summary Report

I have a Clients table (parent) and a Products table (child). I am trying to list how many Clients  records are related to records in the Products table. The `Product Name` from the Products (child) ...
MattMakris's avatar
MattMakris
Qrew Assistant Captain
3 years ago

I figured it out with help from ChatGPT. Apparently it has been trained on all Quickbase user guides and API guides.

Solution: Rather than summarizing `# of Clients`, I summarized the `Related Client` record ID field and set 'Summarize by' to "Distinct Count".



------------------------------
Matt Makris
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago

Impressive use of Chat GPT.



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------