Why can't we drag a customer from a customer list onto our Customer Visit Calendar and make an appointment with them that way?
Good question. We already have that functionality on the web interface. Popup a customer list, select the customer or customers from the list and drag them to the day you want to schedule the visit and it auto creates the document for that customer on the day you dragged the document(s) onto.
I sucked my pencil for a bit, scratched various bits of my anatomy that would not be misconstrued by my colleagues as offensive and hummed and ahhed. I pinged Julian Robichaux and bounced the idea off him. Can I drag docs which are not calendar docs from an embedded view on a page (or form) onto calendar view embedded on the same form and create a document or documents based on the QueryDragDrop event of the calendar based on the documents that I had dropped.
Julian confirmed my initial thoughts that this was a non-runner because when a view is embedded you can't seem to access the drag drop events - BUMMER! So I then mentioned a word not mentioned in polite society much these days and to give Julian credit it didn't finch or berate me in any way. "What about Framesets?" I said
After a bit of futtering about we discovered that yes you could accecss the Drag and Drop events from FrameA to FrameB and Joy of Joys the CurrentView in the UIWorkspace FrameB's QueryDragDrop event was the view from FrameA! _ YIPEE!
I took my leave of Julian with much thanking and promises of beer and proceeded to have a bit of a debug to see what I could do.
I created a wee test NSF with two forms CUSTOMER and CALENT Followed by a View of just the CUSTOMER forms and a Calendar view of the CALENT forms A Frameset was created and in the LHS frame I popped CUSTOMER view and in the RHS frame CALENT calendar view.
On the CALENT view's QueryDragDrop I entered some code and had a ferret about in what was an what was not passed, this is what I found out.
If you grab one doc from the CUSTOMER view and drop it over the calendar, then there are no documents in the UIView.Documents collection, there is a CaretNoteID that links to the dragging document in the UIView.
If you select more than one document from the CUSTOMER view and drag it over the Calendar then the UIView.documents collection contains the documents you selected. If you actually select (the wee tick in the gutter) one document the UIView.documents will contain that one document, but you cannot count on users doing that.
Sub Querydragdrop(Source As Notesuiview, Continue As Variant)
Dim ThisSession As New NotesSession Dim ThisDB As notesdatabase Dim ThisUI As New NotesUIWorkspace Dim ThisUIV As NotesUIView Dim ThisDC As notesdocumentcollection Dim OldDoc As NotesDocument Dim NewDoc As NotesDocument
Set ThisDB = ThisSession.CurrentDatabase Set ThisUIV = ThisUI.CurrentView ' *** Test to see if the view I am dragging from is the calendar or the customer list If ThisUIV.ViewName <> "Calendar" Then Set ThisDC = ThisUIV.Documents '*** Well you must have dragged SOMETHING to fire the event so get it from '*** from the CaretNoteId If ThisDC.Count = 0 Then Set OldDoc = ThisDB.getDocumentById(ThisUIV.CaretNoteID) Set NewDoc = New NotesDocument(ThisDB) NewDoc.Form = "CalEnt" NewDoc.Customer = OldDoc.Customer(0) NewDoc.City = OldDoc.City(0) NewDoc.Date = Source.CalendarDateTime NewDoc.Time =Format(Now,"hh:mm") NewDoc.Status = "Planned" Call NewDoc.Save(True,False) Else Set OldDoc = ThisDC.GetFirstDocument Do While Not (OldDoc Is Nothing) Set NewDoc = New NotesDocument(ThisDB) NewDoc.Form = "CalEnt" NewDoc.Customer = OldDoc.Customer(0) NewDoc.City = OldDoc.City(0) NewDoc.Date = Source.CalendarDateTime NewDoc.Time =Format(Now,"hh:mm") NewDoc.Status = "Planned" Call NewDoc.Save(True,False) Set OldDoc = ThisDC.GetNextDocument(OldDoc) Loop End If Else '*** This is the calendar and I am moving docs around inside it Set ThisDC = ThisUIV.Documents If ThisDC.Count = 0 Then Exit Sub Set OldDoc = ThisDC.GetFirstDocument() Do While Not (OldDoc Is Nothing) OldDoc.Date = Source.CalendarDateTime Call OldDoc.Save(True,False) Set OldDoc = ThisDC.GetNextDocument(OldDoc) Loop End If Call ThisUI.ReloadWindow()
End Sub
This code allows the user to drag a customer (with or without tick selction) or customers from the customer list in the left hand frame onto the calendar and create a calendar entry for that customer on the dropped on date. The user can also safely drag and drop calendar entries around inside the calendar.
Useful and cool. :-)
I have popped the NSF up here so if you are interested in seeing it in action you can have a go.
ILUG countdown widget
Sun, Aug 22nd 2010 1:30p Steve McDonagh If you would like an ILUG 2010 Widget like the one on the left just copy this code into a convienent HTML/JS widget enclosurer on your blogbr /
br /
pre style="font-family: Andale Mono, Lucida Console, Monaco, fixed, monospace; color: #000000; background-color: #eee;font-size: 12px;border: 1px dashed #999999;line-height: 14px;padding: 5px; overflow: auto; width: 100%"codelt;script language='javascript' src='http://slightlydoolally.com/ilugcd.js'gt;lt;/scriptgt;lt;div id='ilug'gt;lt;/divgt;lt;scr [read] Keywords: ilug
blogger
javascript
widget
36
Help required with Duffy The Opera (An Idea waiting for a very drunken party)
Wed, Aug 11th 2010 8:27a Steve McDonagh It has been suggested by Mike Smith that we make the "Duffy" epic into an opera.. and tentative work has begun.. picture the scene.. duffy in a cubicle with the lights subdued and a general air of saddness fills the stage.. Duffy takes a deep breath and start to sing....the Duffy Aria ....br /
br /
blockquoteIm being swallowed by a sharepoint migrationbr /
I'm being swallowed by a sharepoint migrationbr /
I'm being swallowed by a sharepoint migrationbr /
And I don't like it very muchbr /
br /
Oh [read] Keywords: blogger
sharepoint
workspace
133
Single authenticated point of entry to iNotes for all your users
Tue, Aug 10th 2010 10:27a Steve McDonagh It has been a while since I did a Domino Geek posting, however I came across this today and thought I would share it. Basically you can if you know the URL get into your Lotus Notes eMail via a browser. The problem is that most users can be .. well .. forgetful and having to remember a big long string of characters is a bit of a pain that and we wanted a single URL that would (a) authenticate the user and (b) open the mail file so we came up with this solution.br /
br /
A single NSF with a short [read] Keywords: agent
domino
inotes
lotus
notes
ajax
blogger
email
password
server
53
Offical Minutes of the ILUG oganising committee - 9th Aug 2010
Mon, Aug 9th 2010 7:31p Steve McDonagh i**** Names, locations and proclivities have been redacted to protect the guilty ****/ibr /
br /
ILUG 2010 is now so certain to go ahead that Celine Dion is penning the lyrics to the theme song and even as I write the organisers are throbing with preternatural wibbliness for tonite was one of the famed ILUG 2010 skype calls.br /
br /
div style="font-family: Arial,Helvetica,sans-serif;"span style="font-size: small;"Date : 09 August 2010/span/divdiv style="font-family: Arial,Helvetica,sans-serif;" [read] Keywords: administration
ilug
mashup
quickr
xpages blogger
development
mobile
skype
tivoli
34
Duffy the Banana Slayer - Chapter 3 "Is this your Ewok?"
Mon, Aug 9th 2010 3:30p Steve McDonagh iWhere we are introduced to a Pseudo French Inspector, Mistress Marybeth of the "Never used Vista Virgins" and the difference between Dastard and Bastardbr /
br /
/ibr /
He looked around the room surrounded by the detritus of a party. Half eaten pizzas beer bottles by the dozen, an unturned bottle of diet Coke in a ice bucket, a dart board with a picture of Bill Gates on.. the picture was more hole that picture. He stooped and picked up a crumpled flyer "Sharepointless Summer Party" .. yes they [read] Keywords: connections
sametime
blogger
development
javascript
vista
53
Duffy the Banana Slayer - Chapter 2 "The Journey Home"
Thu, Aug 5th 2010 8:31p Steve McDonagh iIn which we do not meet Nigel the out of work sarbannes oxley auditor and bus shelter attendant, Duffy has a Beatlemania flash back, Bill Buchans Knees make an appearence and we meet Gladys from the Sharepoint Coven/ibr /
ibr /
/ibr /
The group had been partying in the tea shops of south central Portaland. Tonight was the re-opening of the hottest geek club in town. The owner had completely remodelled the club in yellow and renamed it "Banana Daiquiri". No one actually knew who it was that now [read] Keywords: admin
domino
applications
blogger
sharepoint
sql
wifi
52
Duffy the Banana Slayer - Chapter 1
Thu, Aug 5th 2010 5:29p Steve McDonagh iWhere Duffy and his sidekick Privet are introduced to the reader and Matt White gets Dissed/ibr /
br /
"Are you sure this is a good idea Privet?" Duffy asked, peering at the screenbr /
br /
Privet laughed at the concern in his friend's voice. "It'll be fine, Duffy. It's a very simple xPages App. I won't mess it up."br /
br /
"I don't know," Duffy said, unconvinced. "I'm just not sure you should be using fancy coding tricks to spice up your life." He thought for a moment, then chuckled. "I'm sti [read] Keywords: ilug
lotus
quickr
xpages application
blogger
css
openntf
56
Irish Notes Geek in Israel - Jerusalem for a week any notes folk fancy a pint?
Sun, Jul 18th 2010 7:30p Steve McDonagh I will be finding myself in Jerusalem, Israel from the 25th-29th July and I seem to remember that there is an active Notes/Domino community in Israel. So if anyone wants to accompany a very pink (people tell me Israel is warm this time of year) Irish Notes Geek for a pint and a bit of a geek chat on one of evenings while I am there, drop me a line at mcdonaghs (at) utvinternet (d0t) com and lets collaborate socially :-)div class="blogger-post-footer"img width='1' height='1' src='https://blogger. [read] Keywords: domino
notes
blogger
community
186
NotesMan Saves the day AGAIN!
Wed, Jul 14th 2010 7:25a Steve McDonagh It is nice to give a product a "call out" once in a while and today is one of those days.br /
br /
I had an app today where a unintentional download FUBARed exchange rates over a large number of records. Now I could have written an agent and fixed it that way however in my essential notes tool box I have a copy of a href="http://www.martinscott.com/Site.nsf/ID/Noteman"NotesMannbsp; /aand I was able to go into the app, created a collection of docs that needed changed , did the change, a quick "Co [read] Keywords: agent
notes
blogger
exchange
exchange
87
Nerd Vs Geek a Taxonomy
Sun, Jun 6th 2010 7:57p Steve McDonagh Twas only last weekend when thwe Arch Bishopess of ITIL a href="http://www.eileenfitzy.com/"Ms Eileen Fitzgerald/a and her chums Clara and Máireád plodded 22 miles around the north coast of Northern Ireland. Many and various were the topics we covered in those miles. One of said topics was the great Geek Vs Nerd debate. Both Clara and Máireád mistakening thought that Eileen and I were nerds ... OH how we laughed at that one. br /
br /
Eileen deffered to my age, experience and abilty to gesti [read] Keywords: blogger
facebook
office
twitter
