Filter for a slice to be used for a table view

[Naff]

Hello,

I have one table. 

The first view to enter data is a form view, where I have one field to scan a rfid card (Column KART), so I get a number on this card and press Save. Then it leads me to the Dashboard view which consists of two views: a details view which has the number of the card from the previous form view (also several quick edit columns) and a table view. I have created a slice for this table view: I want it to show only the rows for a particular card which is entered in the last row (Column KART). 

I tried several options:

1. I created a virtual column to get this value of the card from the last row: [_THISROW].[KART]. As for the column filter for the slice I used: 

ANY(Satışlar[KART])=[MAXROW KART Virtual Column]

It doesn't work when I scan a new card.

2. The second attempt:

The column filter for the slice: AND(([KART] = [_THISROW].[KART]),([Timestamp] <= [_THISROW].[Timestamp]),[Date]=TODAY())

It also doesn't work in general. When I scan a new card in the first Form view and save, I come to the dashboard and see the number of the card in the details view, but the table view (which is based on the slice) is not filtered. Only the Date and the Timestamp conditions are correct. But it shows the rows for all cards scanned this day.

BUT: If I scan a card again in the quick edit KART field, then I see the rows in the table view filtered correctly for this card! HOWEVER, if I wait for several seconds, the table view "breaks down" - It shows all the cards lines.

Here is how I see it for 3-4 seconds

And here is how it changes after several seconds without doing anything:

What can be the problem here? Do you have any ideas? 

[yasarcan]

bursadan selamlar. 

KART okut sütunundaki 399 lu numara başka bir id ye mi ait? bu hücreye bağlı formül var mı?

kolay gelsin.

[Naff]

Merhaba. Evet KART OKUT sütununda belirli değerlere izin veren formül var. Kart listesi başka tabloda yer alır. 

[Suvrutt_Gurjar]

in general, it sounds that you are trying to create a slice based on user selection. In that case, I believe you will need to have a record for each app user that holds the values of her/his filter selection values.

You may want to take a look at the sample app Slice based on user input - AppSheet  from the help article Get started by using the sample apps - AppSheet Help

In the app, when the user selects the color, the slice changes and the view based on it.

The sample app is for one user. If you have a multi user app, you will need a Users table with one row per user to store the selection of that each user and use it in slice filter expression.

[Naff]

Thank you for your answer. This is exactly the sample app I took as an example for my first attempt: row filter for the slice: ANY(Satışlar[KART])=[MAXROW KART Virtual Column]. But I am not sure that I use it correctly...

I have a USER column in the same table, so I will certainly use this column values to differentiate the filter selection values. But now I have only one user, it's me. I mean there is nobody to enter another row and another card number now, but the table view changes to unfiltered rows in several seconds. 

So, I open the form and scan a card (by a rfid card scanner). Then I press Save button and a new row appears in my google table. There is an ID, Date, Timestamp, Card number, User. After the form view I see my dashboard. In the details view the value of the card, that comes from the previous form view, is correct. But the table view shows the rows unfiltered (only a date filter is correct). If I scan the same card or a new card in the details view, the table shows correct filtered rows.

I have noticed now that when I scan the card in the details view (left), the search field at the right part over the table view is also filled with the card number. So, this is the reason why filter works (at least for 3 seconds:). But the slice is not filtered at all...

Again, I try the formula for the slice: [KART] = ANY(Satışlar[KART] ) (from the sample app), but nothing happens. 

[Suvrutt_Gurjar]

It is not clear if  Satışlar is a slice on the same table that you are trying to create a slice of?

In the sample app , the Filter and Data are different tables.

[Naff]

Satışlar is the main table, and I try to create a slice for it. Yes, the example app is a bit different because of two tables. I have only one table, and I want to filter its rows for the table view by creating a slice.

[Suvrutt_Gurjar]

My suggestion will be to use two table approach as it is more straightforward.

We could come up with a single table approach but it will be a bit convoluted and unconventional.