Challenges with an expression... Hi all, I'v...

expressions
(Elan Bailey) #1

Challenges with an expression…

Hi all, I’ve created a data slice that is meant to only show information inline to a user if it meets three conditions:

User and Useremail match Share = True Record ID matches the ID of the current row

AND([CommentShare]=“true”, [Learner] = USEREMAIL(), [LifeDomain] =[_THISROW].[LifeDomain])

This filter works when the record is first created. If Share = False the client (learner) can’t see it.

If I change Share to True, the record appears in the client list as expected.

But if I later change Share back to False, the record still appears in the client list.

I’ve tested the expression and the test always gives the intended result. But the record still appears in the app even though all of the AND conditions are not being met.

Any ideas?

(Aleksi Alkio) #2

May I ask what is the meaning for [LifeDomain]=[_THISROW].[LifeDomain]?

(Elan Bailey) #3

@Aleksi_Alkio I threw in that final condition hoping it would make the filter work. It’s meant to ensure that the entries shown are only the entries that match the life domain that is referenced in the row for that entry.

The test is successful with or without it. But the entry is still appearing in the app when it should be filtered out.

(Praveen Seshadri (AppSheet)) #4

Is CommentShare a Yes/No type? Could you use [CommentShare] = true

(without the double quotes) instead of [CommentShare] = “true”

Not sure this makes any difference but just want to remove that wrinkle