Know if an email has been replied or worked upon

No comments

This is very common question that i get on community or on other forums on how to identify if an email has been replied or worked upon by a user.

Well the easiest approach to tackle this is that there is a field on emails as parentactivityid  which can be used and put on the views, this field basically will contain the email on which you have replied.

So if this field contains data, it means someone has replied on this email.

for example , see below :

Capture

  1. My first email doesn’t contain anything in the parentactivityid because its a fresh sent email.
  2. My second is actually the email which i have sent above – it has the parent activity id as the first email.
  3. My third email is a reply on the previous email received, hence it has that in the parentactivity id column.
  4. My last email is the received email which has the parentactivity id as the email which i sent previously.

Hence, the logic should be like.

1.)

Email direction = incoming

parentactivityid = contains email

Action = you have to reply to this email.

2.)

Email direction = outgoing

parentactivityid = contains email 

Action = it means it has been replied.

3.)

Email direction = incoming

parentactivityid = doesn't not contains emails

Action = you have to work on it

4.)

Email direction = outbound 

parentactivityid = doesn't not contain email

Action = its a fresh email.

I hope it makes sense.

Cheers!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.