Creating a 1:1 chat

Should I make “Has new messages” any changes to this column?

In another column “Count unread” I am counting the number of TRUE “Has new messages”, which is the value for the counter in my tab.

You may want to apply row owners to both email columns. Not only for security purposes, but it would be the easiest way to correct the counts so it would only count rows that the app has access to for the user. Otherwise you would probably have to restructure your If column to ignore any rows where you are not the sender or receiver.

Makes sense. I’ll try that. I’ve added so many new columns trying to make the calculations that I think my head is going to explode. This seems to be the better way. :crazy_face:

1 Like

Find all uses is your friend :wink:

Still not working. I’ll get back to this later today. Enjoy your cake! :wink:

1 Like

I think row owners fixed it after all. Maybe my computer was exhausted, too. Seems like it’s working now. Thanks!

2 Likes

The “Values from Screen” is not pulling from the correct sheet.

Anyone know why? I’m pulling my hair out here. I’ve copied the sheets verbatim…

Screenshot 1 is from my app.
Screenshot two is from the 1:1 private chat app.