Creating a report pulling from different tables

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

So I have multiple tables where I might need to run reports from information from all these tables.  Besides building table relationships, is there a way to pull information from various tables for a report?

Photo of Cecelia

Cecelia

  • 160 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
... only if you are a programmer and want to write you own code as to how this data relates to each other.  Otherwise, you need to have Relationships.  ie, there is no such ting as a =VLOOKUP(  )  or a =SUMIF(  )like Excel has.  That concept in QuickBase is done with Relationships.
Photo of Jack

Jack, Champion

  • 50 Points
as above, but you can create report link fields which will enable you to display reports from other tables within your form without a table relationship, however you cannot perform any math across the tables it is limited to the table in which the data shown on the report is held. Its purely for viewing.