LINKTOFILTEREDVIEW()

AppSheet AppSheet Q&A
1

no real question here, just an anecdote. I am going through classes at appsheettraining.com and I was today years old when i first saw the LINKTOFILTEREDVIEW() expression…
You mean to tell me i don’t have to clone views but change the slice/table it points to?

Mind you, i am just starting this lesson, so i have yet to see practical application, but it looks on the surface like i can, for example, have a single view setup the way i want, but make buttons/actions to go to a filtered view that shows something like In Hospital patients in one view, and Discharged patients in the other, but all based on the same view!!!

https://support.google.com/appsheet/answer/10107338?hl=en

3 Likes
2

Seems that LINKTOFILTEREDVIEW() has some limitations. The brief video on the topic suggested that “unlike slices, the filtered view no longer exists once you click away from it.”

I am hoping they explain this in more detail, but just in case, anyone care to explain use cases for slices versus linktofilteredview()

Also, is there a way to “link” views so that if you make a change in one view, the other is auto updated, assuming you have multiple views that are mostly the same, except they target different slices?

3

The only way to get to a filtered view is with an action (or by clicking a URL); you cannot use a filtered view as a bottom-row navigation button or as a main menu view.

I don’t understand.

1 Like
4

I think i was looking at this as a way to not have to have so many Views.

For example, these two view are the same except they target different slices:

0OD0LMTNN4.png
0OD0LMTNN4.png2135×1615 144 KB

so if i make a change to the order of columns, for example, i have to do it in more than one place for what is essentially a cloned view. The ability to have a “master” or template view that controls the appearance of other connected views would be fantastic, as that would prevent having to edit the copies

sorry, sometimes my english fails me, i hope that explains a bit better

5

EDIT: The picture above is not quite right. Here’s a better example:

TAhtgmf
TAhtgmf2168×930 105 KB

6

As told by @Steve , LINKTOFILTEREDVIEW() is used on the “Go to another view within this app” kind of actions.
Now, this means that you could setup a custom menu using detail views and a lot of actions there, but views on the other hand are based always on a dataset and are the only ones that can be shown inside the drawer/menu and navigation bar.

You could also think about many different ways to implement LINKTOFILTEREDVIEW() like a Form view on drawer/menu and the action gets fired after save using values from the recently added row, etc…

2 Likes