Showing posts with label LotusNotes. Show all posts
Showing posts with label LotusNotes. Show all posts

Friday, April 9, 2010

Lotus-Notes mail rule for auto-forwarded mail from GMail

When an email X is sent from A to B who uses GMail, and B sets filter to auto-forward to C; envelope-address of X will still show A as sender.  However, C cannot define mail rule that sender is A!

Reason
As X is coming from Internet (GMail), there will be field "SMTPOriginator".  And in this case the fields 'SMTPOriginator' = B and 'From' = A; and 'Sender' in mail rule will check field 'SMTPOriginator' instead: i.e., sender becomes B not A.

Monday, January 4, 2010

Google & Lotus-Notes: calendar-item characteristics & differences

This is situation when an organisation has these 2 email systems running.


Google Calendar
Lotus-Notes calendar
Showing on calendar
Item is always posted to GCal as '?' mark (looked similar to 'Maybe' response).  We respond 'No' or choose 'Remove' to remove it from GCal.
Item only arrives Inbox and optionally displayed in 'New Notices' pane.  We respond 'accept' or 'add' to get it displayed on calendar.
Colouring
GCal supports multiple calendars and colouring is assigned to each calendar.
LN can only see calendars of others, but neither see altogether simultaneously nor can create multiple calendars in addition to own one.  Colouring is assigned to calendar types (meeting, appointment, anniversary, reminder, to-do)
Participant list
Has option to add guest by any participant.
Has To/CC/BCC classification.
Calendar-item instance between mail & calendar systems
Separate: Deleting the instance in GMail does not effect one in GCal and vice versa.  However, we can respond in either GMail or GCal.
Same: calendar is another view the mail database so that we see same-single instance.  We do not delete it from inbox but manually remove it away (possibly to other folder), or set option (in Tools |Preferences) to remove meeting invitations from inbox after responded.
Item's content
See body of LN-cal item contains .ics attachment (as common as normal Internet email).
See body of GCal item as: "View your event at http://www.google.com/calendar/..."

Also:
  • Sender & participants name formatting:  In same system, it can look up its "address book" so that we'll see as full-name written (ex., "John Smith").  Whereas each side will see ones from each other system as Internet-email format (ex., john.smith@company.com).
  • Response to GCal invitation via LN can have error such as nonexistent parent document, (field) incorrect data type for operator or @Function.

    Wednesday, March 25, 2009

    LN-admin's function keys

    More will be added here later once I know, you can leave ones to me as comment -- thanks! :-)

    Ctrl-Shift
    Press and hold while select item in menu bar.
    • Database) View |Go To ...: show hidden views in selection list.
    • Workspace) View |Show Server Names: include folder path.

    Monday, May 26, 2008

    LotusNotes: asset aging formula

    This formula calcaluates age from field 'Purchase_date' and rounds to 0.5-year interval.

    y0 := @Today;
    y1 := @Year(y0) +(@Month(y0)/12);
    x0 := @If(Purchase_date=""; y0; @TextToTime(Purchase_date));
    x1 := @Year(x0) +(@Month(x0)/12);
    @If(Purchase_date=""; -1; @Round(y1 - x1 -0.24; 0.5))


    Actually the formula of y1 (and x1) would be "... +((@month(y0) -1) /12)". However, when (y1 - x1) is computed, result will be correct value.

    Offset value 0.24 is used to implement "round down" or "floor" function. It is 0.24 instead of 0.25 in order to avoid case when the item has just been purchased (where result will be calculated to -0.25 and then rounded down to -0.5). If quarterly-basis is preferred, @round's arguments become (y1 - x1 -0.124; 0.25).

    In this context, the field Purchase_date is text type. Formula returns -1 when Purchase_date has no value.

    Monday, June 18, 2007

    How to break "prevent copying" setting from sender

    Solution: remove field "$KeepPrivate".

    Refer IBM/Lotus KB Document# 1097631: Is "Disable Printing/Forwarding/Copying to Clipboard" a security feature?
    ... You can prevent Notes mail recipients from copying a Notes mail message that you send. This includes copying with the clipboard, forwarding, replying with history, and printing. However, this option is merely a deterrent to copying. Recipients can still use other means to copy the message.

    Agent formula "etc\Remove $KeepPrivate"


    FIELD $KeepPrivate := ""

    How to set icon to mail sent in Lotus Notes

    Solution: Set field "_ViewIcon" before sending.
    1. Compose mail and save as draft.
    2. In Drafts folder, select the mail and run agent.
    3. Open the mail and send it out.

    You can also preset mail icon in stationery.

    Refer IBM/Lotus document# 1089446.


    Agent formula "etc\Set mail icon"
    FIELD _ViewIcon := @TextToNumber(@Prompt([OkCancelEdit]; "Set mail icon";
    "Input the icon#."; 99));
    SELECT @All