[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1064
  • Last Modified:

Simple Lotus Notes Calendar Appointment form used in an application.

Is there a way, using the same appointment fields like StartTime, EndTime, etc. to add the data to your lotus notes calendar when user reserves an event in a Lotus Notes application that emails the date, time, event to the user that can be added to their calendar from the memo?
0
KTTKTT
Asked:
KTTKTT
  • 3
1 Solution
 
KTTKTTAuthor Commented:
This is what I've done thus far:  
1.  In my Notes Application, created a form w/the Appointment fields:  StartDate, EndDate, StartTime, EndTime, Subject, Location.
2.  Set the Form field to "Appointment"
3.  User creates an appt. from the db., saves, hits SEND document - it's routed to user's Inbox
4.  When you open the from Inbox, it looks like a Calendar Appt.
5.  It shows up in the Calendar View as an Appointment.
6.  In the example above, I set the StartDate to 03/29/2010, EndDate 03/29/2010,  StartTime: 04:00 PM  EndTime 05:00 PM
7.  It lands on my Notes Calendar View for the correct date 03/29/2010, but shows in calendar view with wrong time: at 12:00am
8.  When I open appt, it shows 4:00 pm startdate and 5:00 pm enddate
9.  I can then Drag and Drop to correct view time in calendar view w/no problems.

I would like to get it to display on my Notes Calendar for the correct Time.  Any help is appreciated.  thx
0
 
Sjef BosmanGroupware ConsultantCommented:
There some more fields that require a value, see in the Document Properties of a manually created Appointment document (and the Calendar view, in the first few columns).

Fields you might need to set explicitly:
- CalendarDateTime
- EndDateTime
- EndTimeZone
- StartDateTime
- StartTimeZone
0
 
KTTKTTAuthor Commented:
Thanks.  I reviewed the field properties of a manual appt. in my calendar, The notes mail ($Calendar) view, and the appointment form, added the fields you mentioned and was able to get this to work.  Thanks !
This can probably be improved to work with busytime, etc.  For now here are a few simple things I did to get it to work:
Used the following formulas for fields below:
StartTimeZone default formula: @If(@IsAvailable(CopyInto); StartTimeZone; @GetCurrentTimeZone)
EndTimeZone default formula: @If(@IsAvailable(CopyInto); EndTimeZone; @GetCurrentTimeZone)
StartDateTime Inputtranslation formula:  @If(@IsAvailable (StartDate : StartTime ); @TimeMerge(StartDate ; StartTime)  ;  StartDateTime)
EndDateTime Inputtranslation formula: @If(@IsAvailable (EndDate : EndTime ); @TimeMerge(EndDate ; EndTime)  ; EndDateTime)
CalendarDateTime Inputtranslation formula:  @If(@IsAvailable (StartDate : StartTime ); @TimeMerge(StartDate ; StartTime)  ; CalendarDateTime)
For good measure, added hidden fields in appointment form:  LocalTimeZone, AppointmentType, $CSVersion, TaskType
Added simple action button:  Add to my Notes calendar with simple 2 simple actions:  SEND DOCUMENT, and a Run Function formula:
@Prompt([Ok] ; "Added to Calendar" ; "Please check your calendar date for accuracy" ); @Prompt([Ok] ; "Added to Calendar" ; "This calendar entry does NOT check for free time and calendar double booking" );@Command([FileCloseWindow])
0
 
KTTKTTAuthor Commented:
Other references I used:
http://www.ibm.com/developerworks/lotus/library/cal-apps/
Scroll down to "Build a simple event calendar"
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

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