i have a dashboard that contains multiple table style views. these table views may be filtered (standard behaviour of app sheet). is there a way to preset these filters, e.g. by creating a deep link (https://support.google.com/appsheet/answer/10106757?sjid=2613829996161196601-EU#manual) that set a filter parameter of a certain view?
Have you given a try to LINKTOFILTEREDVIEW() deep link?
I'm aware of LINKTOFILTEREDVIEW, but this removes entries completely from the view. but in any table you can filter on many of the fields, this is a view only filter and can be reverted by the user anytime.
@phileasfogg wrote:
is there a way to preset these filters
Nope.
User | Count |
---|---|
21 | |
15 | |
4 | |
3 | |
3 |