• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 417
  • Last Modified:

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.
0
Macavity12345
Asked:
Macavity12345
  • 7
  • 4
  • 3
  • +1
1 Solution
 
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
 
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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
 
qwaleteeCommented:
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
 
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

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 7
  • 4
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now