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

MarkShnier__You

Qrew Legend

2 years ago

Impressive use of Chat GPT.

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