Creating Reports Between Removed-Relationship Tables

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • In Progress

We work in property management. Our properties report incidents to the corporate office, and we'd like to report back to the properties on the incidents we have collected. Below is a diagram of the tables we have setup and the reporting we'd like to run. Is it possible to create a report which runs based off a distantly related table?

An equation would be something like (see diagram below):

Incident X, Y, & Z is related to Property A, and if Property A has Resource Z, then the report would return Incidents X, Y, & Z in its report. A report run for Resource Z to know the incidents at their Property A.




Photo of Devin

Devin

  • 362 Points 250 badge 2x thumb
  • Unsure

Posted 8 months ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Without a direct connection between the "Incidents" and the "Property Assignments" it will be rather difficult.

However, you could put a report link on the 'assignments' table that would display any related incidents at that property.  But it would have to be a drill down behavior, rather than a count/summary.

If you want better reporting with this you need to find a way to connect the assignments to the actual incidents. 
Photo of Debbie Taylor

Debbie Taylor

  • 604 Points 500 badge 2x thumb
The best way to create reports with data in multiple, un-related Quick Base tables is to use reporting software like Google charts, Tableau or Power BI.  Then, put the reports onto a Quick Base dashboard for licensed users to see.  CloudBase Services has done that for many clients.  Here are 4 sample charts - all of which use data in un-related tables.  Contact us via our website and we can get you started.