How to make sure if the messages are unread or not?

I have a messaging system in my website. For that I have created two fields namely Conversation and Message. Now I want to let the user know if there is an unread message for him or not.

Now I now I have to create a new field in message type of Read which would be a Boolean with a yes or a no. But the thing is that I don’t know how to implement the feature.

It would be great if I could get some ideas.

Set the boolean default to no on the message.

Then where your user would read a message you need a workflow that updates the message as read. You can do it on page load but there may be a better way to do it for your setup so do some research.

You then may want to add some sort of alert to your UI. Maybe a bell icon etc. You would then just create a condition on the element “when users messages received read contains no then icon is red” etc

Other things are building the ability for a user to view unread messages so they can clear notifications etc.

Hope that helps