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.
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.
User | Count |
---|---|
59 | |
25 | |
13 | |
12 | |
6 |