Slice Problem

AppSheet AppSheet Q&A
1

Hi.

I have a slice to return all JobID events dated today: (21/06/2024)

DaveWillett_0-1718984436442.png
DaveWillett_0-1718984436442.png881Ă—342 22.9 KB

When testing the data I see all rows which have an [EventDate] of TODAY() which is correct as today is 21/06/2024.

However in the UX I am seeing events from a date before TODAY(), the 10/06/2024.

DaveWillett_1-1718984495965.png

When I look in the table ( csv file) and filter on the JobID I see two rows for the same JobID which is not unusual as one is a Collection and one is a Delivery. One [EventDate] is listed as 10/06/2024 and the other is listed as 21/06/2024.

DaveWillett_0-1718984958852.png

Why is the UX showing the earlier dated row (10/06/2024) instead of the row which matches TODAY() which is (21/06/2024)?

Many Thanks

2

DOUBLE ENTRIES CREATED.

3

hi. Yes that is correct, but only one of them has an [EventDate] of TODAY() the 21/06/2024 which is the row I am filtering with the slice?

4

You has finded the problem. You can’t have 2 key colums with the same value.

So, your options are:

  • Change manually in your excel one of the duplicated Job ID.

  • Delete one of them.

But the most important, review way did you write a duplicate ID. The easiest way is to leave this work to appsheet with UNIQUEID() as a initial value in the key column.

Your slice view is showing both values because although the filter is a “yes/no” condition, the result is a list of Key columns.

5

Yes that makes sense, I think I have the solution then.

Many Thanks

6

delete the unwanted entries. and try again