Forum Discussion

AnthonyWong1's avatar
AnthonyWong1
Qrew Member
3 years ago

Reports Pulling Data from 2 Tables at once

Hello, I have 2 tables that separate projects from  my internal team, and external team. I would like to pull a single report that shows both entries and information regarding the projects i...
Data import and export
reports and charts
katlyncowley's avatar
katlyncowley
Qrew Assistant Captain
Probably not the perfect solution - but you could set up a pipeline that copies/updates records in a third table any time a record is created or changed in the first two tables, then make the report in the third table.

------------------------------
Katlyn Allen
kallen@eatatjacks.com
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago

On the same theme, you could make a 3rd table. Then create two saved table to table copies  to copy the data from each of the two tables into  the 3rd table. 


then create a formula URL button to

1. purge the third table
2. import from table 1
3. Import from table 2
4. Run you report.



------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------