Report Using Multiple Tables
Hi Everyone, Is there a way to create a chart, that pulls in data from multiple table? I'm trying to create a Pie chart showing a count of On Time / Late proposals. This information is stored on ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendNo, there is not way to build a report from multiple tables.
What you would need to do is to create a night;y process to copy the records from each of the 4 tables into a central table and you would need to set up a Key field to preface the record ID of each table with a name for the stable. YOU would then need to set up a relationship so as to be able to detect deleted record in the source table.
Then each night an Automation would need to run to repopulate the target table by running 4 saved table to table imports and delete any target table records where their source record was deleted.
So, yes possible with some setup.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
What you would need to do is to create a night;y process to copy the records from each of the 4 tables into a central table and you would need to set up a Key field to preface the record ID of each table with a name for the stable. YOU would then need to set up a relationship so as to be able to detect deleted record in the source table.
Then each night an Automation would need to run to repopulate the target table by running 4 saved table to table imports and delete any target table records where their source record was deleted.
So, yes possible with some setup.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
This isn't really a solution. Salesforce has allowed combined reports for years. Quickbase should seriously consider enhancing report capabilities as it limits C-Suite buy-in on utilizing the product when it has such severe shortcoming in reporting and the ability to pivot data within multiple tables. You shouldn't have to look to other solutions or manual data export to get what you're looking for.
------------------------------
Tom Roberto
CTO
SG Network Services
Buford GA
888-212-8808
------------------------------