Forum Discussion

MattMakris's avatar
MattMakris
Qrew Cadet
2 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 Cadet

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
------------------------------
BrianSeymour's avatar
BrianSeymour
Qrew Cadet
2 years ago

Nice solution via ChatGPT! Using Distinct Count via a Summary seems like the way to go here since the relationship exists between the records (vs. Formula Queries).



------------------------------
Brian Seymour
------------------------------