+ Start a Discussion

Checkbox to show when a New Email has been received on a Case

I created a formula field to show when a new email has been recieved on a case by creating a Checkbox field and when an email is received, the box is checked. I'd like to be able to automatically Uncheck the box when the email has been read. Does anyone have any suggestions on how to do this?


Here is the code that I'm using to check the box:


Object: Email Message

Evaluation Criteria: Every time a record is created or edited

Rule Criteria: OR(Incoming=TRUE,CreatedById <> Parent.OwnerId )


Field Update: Update checkbox field "New Email" = TRUE