In-App Chat Notification

Triggered by notify column in Users sheet, see below:

Users sheet has a relation to chats sheets, which brings only Chat user 2 email.(this is the column to whom the chat request is sent to) . Then I use lookup to bring the User 2 emails,

Then use a if-then-else that checks the lookup if its the signed-in user, it puts a 0, if row is empty its blank, else it puts 1.

1 Like