My app will have a large number of ways of filtering data, and I'd like to avoid having to create special views/slices for each. So, I'm making a table that will list view options and I'd like the primary action to be a linktofilteredview action. The table will store one column that represents the name of the view to go to and another column that represents the required filter values. But it's not working, and I'm not sure what change.
Here's the table:
And here's the formula for the action:
Note that the formula is failing. Is there some special way to get the text of my [filter ] field to be interpreted as a valid 2nd parameter in the function?
Solved! Go to Solution.
No, Appsheet can't convert stored text into an expression.
Or maybe a better way to say that is it can't parse data values as expressions.
User | Count |
---|---|
31 | |
14 | |
3 | |
3 | |
2 |