Searching Multiple Unrelated Tables

[Valik]

Hello. If I have multiple tables that are not related (i.e. there is no common field between them so I cannot combine them in a View) and  I want to run a search across ALL of them for some string and get a report saying which Table(s) have that string. can that be done with Caspio? Thank you.

[TellMeWhy]

You can still combine all of them in a View, just that it would be OUTER JOIN, nothing is similar.

You can create another field in all your tables just to store the table name.

Use View as the Data Source for Reports DataPage, and use Keyword Search.

https://howto.caspio.com/faq/reports-datapages/how-to-do-keyword-search-across-multiple-fields/

You might encounter some problems with joining all those tables tho, if you have so much records in each one. Setting up the Reports DataPage will be too much work, as well.

[NailDyanC]

Hi, just to add to the previous comment above. You may also try this other workaround: