Multiple different data tables in one search and report.

[Pumpedplop]

As said in the title, I'm searching for a way that I can use all the different data tables in the picture as one on one datapage.
if any extra data is needed I will try to provide it.

[Kronos]

Hi @Pumpedplop,

If you have any similar unique fields in all of the records in your tables you may use a View as a Data Source to your Reports DataPage.

You may refer more in these links as your guide:

https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-join-tables/

https://www.youtube.com/watch?v=UHqA4FYPPyQ

 

I hope this helps!

[NiceDuck]

Not a single datapage but you can make a setup to make multiple report datapage for each of those tables and have them embeded in a single webpage and use a single search form.

You may want to check this out: https://howto.caspio.com/tech-tips-and-articles/how-to-separate-search-page-and-results-page-into-two-different-webpages/

Just repeat the step 4 on each of the table and embed all of those report on a single webpage.

I hope this helps!