Filter in slice not working

[SYawn]

Hello. I’m creating a home inventory. I have a table called “Rooms” with a column called “Location.” Rows in this table are things like “Basement” and “Living Room.”

I have another table called Sub Locations. This has rows with names such as “Shelf A2” and “Bin 1.” It has a column that references the “Rooms” table so that each sub location is tied to a location.

From my view of the “Rooms” table in the app, I want to be able to click on a Location (such as “basement”) and navigate to a filtered list of Sub Locations in which the Location matches what the user has clicked on.

I created a slice that I think should accomplish this:

I then created a view for this slice and an action to go to this view when a location in the “Rooms” view is clicked:

In the preview, the action appears to work correctly, however the list is never correctly filtered. It shows the full list of sublocations. I feel like I’m getting something very basic wrong. Any idea what I should be doing differently?

[jaichith]

Row filter condition is wrong.

And still I want your app table structure and it is doable.

Just see this video for reference.

https://youtu.be/uDvbgDeFsYE?feature=shared

You should use 1 table and 1 slice. Based on the input of table 1 , slice should show the data.

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

[SYawn]

Thanks for your reply, jaichith. Here are the two tables I’m working with:

Here is the view of the Rooms (Locations).

From this view, I’d like to be able to click on a location and navigate to a filtered list of Sub Locations linked to that Location. I tried to do this by creating a slice of the Sub Locations table with the following condition:

I then created a view of that slice:

I then created an action to go to this view:

When I click on the action in the Locations list, it navigates to a list of the Sub Locations, but it is UNfiltered. For example, this is what is previewed when I click on “Basement”:

Let me know where I’m going wrong or if there’s a better way to accomplish what I’m trying to do. Thank you!

[jaichith]

If my understanding is right, you are trying to get the list of sub location linked with the current row location. Data which should be shown is from Sub location table.

Remove the row filter condition in the slice. Use this expression in the linktofilteredview()

LINKTOFILTEREDVIEW(sub location view, ( in( [Sub location column], select (rooms[ sub location],[location] = [_thisrow].[location])) )

Note : make necessary correction in the names of column and table.