Macavity12345
asked on
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.
ASKER
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.
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.
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)
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<>
u can see help for icon no's.
the above code will work and hope ur asking some thing like that.
the above code will work and hope ur asking some thing like that.
ASKER
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.
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.
somewhat tricky.
But I need send time. and it can be done. You can have hope.
But I need send time. and it can be done. You can have hope.
sorry. it is Some time
ASKER
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.
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.
looking good.
I suspect the performance will be very slow. Since ur using @username in views.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@username if used in view column formulas gives unpredictable results,. It can be used "shared, private on first use"
ASKER
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.
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.
or, you can correct it and post the correction for template inclusion.
Any progress?
SendTo ,CopyTo, BlindCopyTo