Forum Discussion

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

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

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