Messaging style app, how to detect when a message is read/unread?

[Patrick_Paul]

I am building an app that allows users to effectively send messages to one another.  It accomplishes this by having a table called "Messages" and users can add rows to it and each user can only view the messages (rows) directed to them.  How can I have the app detect when a user clicks into the detail view and "reads" a message?  I need to be able to indicate which messages are "unread".  Thanks!

[TeeSee1 · Accepted solution]

One way I would try this..

Add a column - let's say [Message Read] of type text

Create the following three actions and set the last grouped: execute.. action as the event action of the table view

1. Action to update the [Message Read] with USEREMAIL()

2. Action to go to LINKTOFILTEREDVIEW("Meassages_Detail", [id] = [_THISROW])

3. Action to execute the above two, this should be set as the action triggered on the row selected event of the table view.

[Patrick_Paul]

This worked beautifully, thanks!  The view type I had chosen did not permit event actions to be triggered, so I didn't consider this method.  I changed the view type, and this worked great.

[suriyass08]

Hi @TeeSee1 , In my case I have massage as primary table and comment as secondary table , What I want is when I click the message table record it show only the unread comments in the detail page 

Note : Comment will be inline column in the message detail view 

suggest a way to achieve this .

[suriyass08]

Hi @TeeSee1 , I need similar help , I have table "Message" and "Comment"

User will create a record in message and add more comments , When a user click the message record , I want to show the unseen/ unread comments only in the detail view of the message table record 

Note : comment is the inline column of the message table  

Please suggest a way to achieve this.

[TeeSee1]

You should start a new q&a. 

You can make a reference to this q&a if you like. 

You also want to clarify who are the intended audience of a particular message and comments. Is it one person, a particular group of users or for anyone logged on in the application?