Change status of a record automatically

[Rajan_PACHCHIGA]

Hello,

I have a workflow requirement where in there are 3 statuses to be maintained.

1. Not Read (Initial status on addition of a record).
2. Read
3. Replied

Requirement is such that when a user opens a record, its status should automatically change to “Read”. At present, I have given an action button for the user to click to mark the record as “Read”, which the user wants to happen automatic like when we open an email, it changes the status from “Unread” to “Read”.

Can this be done in AppSheet?

Thanks.