Identify (in Inbox) whether I am on the To / cc / bcc list.


How would I go about identifying this - is it a feature in 6.5+ or something, or should I use designer to include a column which detects this and shows an icon or something?  If it is the latter - please give pointers on the formula to use.
Macavity12345Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
qwaleteeConnect With a Mentor Commented:
If you have 6.0x or 6.5x, just use the OpenNTF Mail Experience template.  It includes an indicator to show how you were designated recipient.
0
 
madheeswarCommented:
yeah. u need to modify mail template to do this. Create 3 columns and for each column give th respective field names. as
SendTo ,CopyTo, BlindCopyTo


0
 
Macavity12345Author Commented:
That would give me three columns with a lot of stuff in each.  I just want an indication whether I am in to, cc, or bcc.

So I was thinking more along the lines of one column, with
@if(I am in to; icon1; I am in cc; icon2; icon3)
kind of thing.

Complication is "I" could be part of a group, which is in to: etc.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
madheeswarCommented:
Ok, no problem.

create a column and in the column properties, enable display as icons.

and in the formula:
U can change the no's upto 99 for icons.
@If(SendTo<>"";55;CopyTo<>"";56;57)
0
 
madheeswarCommented:
u can see help for icon no's.

the above code will work and hope ur asking some thing like that.
0
 
Macavity12345Author Commented:
The code will give value 55 as long as SendTo is not empty - which is practically always.  Just checking whether the field is empty does not work.  

I need some way to check if the mail is addressed to ME in to, cc or bcc.  i.e., "I" or "Username" is a member of SendTo, ...  Problem is the mail can be addressed to me from Notes or Internet, or could be addressed to a group I belong to etc.  
0
 
madheeswarCommented:
somewhat tricky.
But I need send time. and it can be done. You can have hope.
0
 
madheeswarCommented:
sorry. it is Some time
0
 
Macavity12345Author Commented:
So far here is what I have for the hidden column:

tempName := @Name([CN]; @UserName);
tempName := "*" + @ReplaceSubstring(tempName; " "; "*") + "*";
@If(@Matches(SendTo; tempName); 148; @Matches(CopyTo; tempName); 159; 0)

This works for me, and some others, as most of our internet email ids are FirstName.LastName@..., however it does not work for groups, and for those people whose middle names are in CN.
0
 
madheeswarCommented:
looking good.
0
 
madheeswarCommented:
I suspect the performance will be very slow. Since ur using @username in views.
0
 
p_parthaCommented:
@username if used in view column formulas gives unpredictable results,. It can be used "shared, private on first use"
0
 
Macavity12345Author Commented:
Checked the OpenNTF template - uses DbfTitle, which is OK, and modified the internet address conditions.  Works fine.  While I probably wont use the entire template, (some things dont seem to be working right), this column was useful. Thanks.
0
 
qwaleteeCommented:
If something doesn't work right in the template, let me know!  We'll get it fixed in a jiffy!

or, you can correct it and post the correction for template inclusion.
0
 
qwaleteeCommented:
Any progress?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.