I need to filter a slice based on the equalit...

AppSheet AppSheet Q&A
1

I need to filter a slice based on the equality of one of the columns with the specific value of another column of another table, based on the user’s record. I tried the following:

[TenantLocal] = LOOKUP (USEREMAIL (), “Tenant”, “TenantId”, “TenantRole”)

But it did not work.

Any idea?

2

If [TenantLocal] evaluates as blank, the equality test will be TRUE. If that is undesirable, confirm it’s not blank with ISNOTBLANK() first.

1 Like
3

AND( ISNOTBLANK([TenantLocal]),

your above expression)

4

Thanks @Steve! I just came across this and will use isnotblank() to fix the problem.

Do you feel that this is something that is unavoidable or do you think it AppSheet should make = really mean = in such cases?

1 Like
5

Kirk_Masden:

Do you feel that this is something that is unavoidable or do you think it AppSheet should make = really mean = in such cases?

I think = should mean “is equal to”, period. I don’t agree with the current behavior. But the current behavior has been around longer than I have, so changing it will cause problems with apps that rely on that behavior. The work-arounds I’ve proposed are EQ() and NE() functions that provide the proper behavior.

1 Like
6

Thanks! I didn’t know about EQ() or NE(). I found a reference here:

That reference took me to

https://support.google.com/docs/answer/3093593?hl=en&ref_topic=3105518

I’ll try it out.

1 Like