It would be easy if 1 message was for 1 user, but 1 message is for all the users in the conversation.
I have a data type Conversation that has a list of Messages and a list of Users (and the User also has a list of Conversations).
Option 1. I could have another data type Read Messages (or Read Conversations) that keeps track of this. I’ve managed to avoid this type of table so far in Bubble.
Option 2. Currently, the User has a ‘list of Conversations’. I could change this to ‘list of Read Conversations’ and add another field ‘list of Unread Conversations’, changing this every time a new message is created.
Option 3. Is there anything better than the above?