I have a slice set up that filters my data so that if a row is marked as โDoneโ it hides the row in the app. This current slice works just fine for the table of data it is linked to. I tried to copy the slice to preform the same function but for a different table of data and for some reason it is not having the same effect. Instead of eliminating all the rows that are marked as โDoneโ it eliminates the first row marked as such and then every row after that. So in theory it is no longer โslicingโ my data. Thought the columns are not identical between the two tables of data, they are fairly similar so not sure if it is the column structure perhaps. Honestly do not even know where to look.
Any idea what setting might be throwing this off?
Solved! Go to Solution.
I removed the @(_FILL) and that seemed to fix the issueโฆthank you!
Please provide a screenshot of the complete row filter expression, and of the column list of the table the slice is built upon.
Slice info attached
Column Info attached
Try to change your condition to
[Done?] <> TRUE
Appsheet auto converts โYesโ and โNoโ to True and False when evaluating formulas; Iโve found โYesโ and โNoโ to actually be the better choice more often than True and False which annoys the programmer in me almost as much as <> instead of !=.
I prefer to just use the value of the Yes/No column:
NOT([Done?])
to test if [Done]
is FALSE.
Also recommend changing your initial value for Done? to โyesโ not @(_FILL). I donโt even know what that formula does but I do know thatโs the old syntax for appsheet. Also if possible Iโd get rid of the ? in your column name I donโt know how that would affect it but it probably not recommended.
I removed the @(_FILL) and that seemed to fix the issueโฆthank you!
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |