Filtering List

hello i would like to use a condition where UserEmail is equal to the user logged in
how can i solve this following error?

If I understand correctly you put 2 conditions into select(), right?

  1. [orderstatus] = “pending”
  2. orderlist[useremail] = useremail()

If so, maybe try to write:

SELECT(
orderlist[useremail];
AND(
[orderstatus] = “pending”;
[useremail] = USEREMAIL()
)
)

Hope it helped :slight_smile:

2 Likes

yes i tried it
but i get the same error saying email type can be compared with list type.
[useremail] in orderlist is a list type as one email can have multiple [orderid].

2 Likes