If this is already doable or simply “impossible” please let me know.
I’d love to be able to query a table in another app in the same account folder without having to add the linked table to the app.
This would be especially handy when I need just one column from quite a complicated table and don’t want to slow down my app or add loads of more rows to my usage.
If it’s a Big Table, you can run a filtered query through the API. Other than that, the only option is to link it. Keep in mind that when you link a table, you only get non-computed columns. So if the table being linked has lots of computed columns in the first App, you would avoid all that bloat in the App that you link it to.