Help! how to get a listing of a table filtered by the column of another table that is not referenced to the main table

Rha45
Participant I

how to get a listing of a table filtered by the column of another table that is not referenced to the main table.

I can do this seamlessly from SQL Server by simply creating a view, but if I add the view to appsheet, appsheet creates it as a separate table.

The question would be how can I filter the slice with the expressions in appsheet.

Here is an image with the structure of the tables.

0 3 338
3 REPLIES 3

Steve
Participant V

I really know the way to create the Slices, where I am really having problems is in the creation of the formula to be able to filter and reach the objective that I mentioned above.

I donโ€™t know if I could express myself well about the objective that I want to achieve.

Thanks a lot!

Could you explain in plain language what you want the filter to do? Iโ€™m happy to try to help with the expression.

Top Labels in this Space