Dear AppSheet team,
Today, I'd like to ask if it's possible to enable the option to create an expression that limits the filtering of a specific column. Imagine you have a table called "Storage" with records representing stored items, categorized by various levels. These categories belong to a parent table.
Using the LINKTOFILTEREDVIEW() function and an action from the parent table, you can navigate to child records where the parent matches the row you clicked on.
However, there could be a chain of dropdowns, such as Category, Family, Type, and Instance. This way, when you click on a Category, it takes you to the Families within that Category. Then, by clicking on a Family, you’re taken to the Types within that Family, and finally, clicking on a Type takes you to the Instances of that Type (simply different ways to organize many records).
The challenge arises when filtering Instances: I want to filter by Type, but instead of seeing only the Types associated with the Families, I see all the Types. This happens because I can "search," but there’s no option to create a search expression that limits the results.
That’s all. It would be a wonderful feature to have.
... View more