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.