|
XPages Social Enabler |
|
When working with Excelfiles it is very common to know how many rows there is to process in the file so that You can inform the user in a progressbar or something. I've seen a numerous examples of simple looping through each row until the ActiveCell is a nullvalue (empty string). This is not very ... |
|
Create a Symphony Document (attachment) with script code in Lotus Notes |
|
I'm continuing the discussion on how to create a word document. Now it's time to understand how to format text in Word; This time I'll show how to write Bullet Lists into a word document. First, read up on how to create a word document here: ... |
|
To create a word document from LotusScript is quite simple, though it has some pitfalls that is caused not by LotusScript, but by the fact that working with the COM object isn't always as straightforward as working directly in any Microsoft Product. This works for ND5, ND6, ND7 and ND8. I ... |
|
In LotusScript You have the option to open files with the OpenFileDialog (or SaveFileDialog) or open databases with OpenDatabase methods found in the NotesUIWorkspace class. But what if You are only interested in getting user input for a FOLDER and not the full path to a file? Then You have to use ... |
|
Obviously I forgot about the "fraction()" function, so I removedchanged parts of this article (thanks @Mario for the hint) :) If you need the digits behind the decimal seperator of a number, you might subtract the integer of the number from the number itself: 1.3 int(1.3) e.g. would result ... |
|
Do you know the difference between rounding a number commercially and rounding it mathematically? Notes does... This is, why in Formula @Round(0.5; 1) equals 1, but the equivalent in LotusScript round(0.5, 0) equals 0... Wonder if round(1.5, 0) equals 1? No, the result is...: 2 The reason is, that ... |
|
Yes, SaveOptions understands more than just "0" or "1": Did you ever face the problem, that Lotus Notes keeps asking if you want to save the current document, even though you just did? Picture the following scenario: A user creates a document with a certain form that contains a "Change Field ... |
|
This code will allow you to run a program, batch file etc and wait for it to finish before executing the rest of you code |
|
When performing mixed changes on fields, i.e. changing fields in a NotesUiDocument and others in the corresponding backend NotesDocument, it is very important to make sure that they do not have any sideeffects on each other. Could be ugly... To see what I mean, try this one: Build a simple ... |
|
I still often see code like 'NotesDocument.form(0)' in LotusScript agents to access the value of a NotesItem. When the item name and the purpose of the item is not as clear as on "form", I prefer using 'NotesDocument.GetItemValue("form")(0)'. This seems to be the safe way to go, as you will always ... |
|
As you (if you are a LotusScript developer ;)) know, Msgbox "a" + 3 results in a type mismatch error. Msgbox "a" 3 delivers "a3". Now, do you know what the result of this line of code is? Msgbox "1" + 1
A. "11". B. 2. C. A type mismatch error occurs Solution: B LotusScript ... |
|
Here's a list of links that are a great starting point if you want to learn Flex (for integration w Domino). Some, like the style and component explorer, still help me a lot during the development process. Originally, these links were put together by http:www.thbaumi.deThomas Baumgartner ... |
|
When you copy + paste a table or other contents from a NotesRichtextItem to Excel using LotusScript, the formatting mostly will get lost. There is a workaround to keep all the formatting and display your content in Excel just the way it appears in your NotesRichtextItem: Copy+paste the content to ... |
|
Some time ago I wrote a small LotusScript agent, that updates a document's NotesRichTextItem with text, that I send to my Notes mailfile. Problem is: I wanted to insert the text at the *beginning* of the Body item, what seems simple and still has some pitfalls. Here is what I tried, and the ... |
|
If you need to simulate @Trim (formula) / fulltrim (LotusScript) in JavaScript (string-only), you can do so with the following function using regular expressions: {code:} function trim(txt) {
return txt.replace(/(^ +} +\$)/g,'').replace(/ +/g, ' '); } {code} About the Author
Marcus ... |
|
If you look for the cause of an error, it's not always the obvious - like in this case: The following LotusScript function retrieves a Notes database filepath, a view name and title and prompt to show a picklist to the user, and display the user selection in a messagebox. {code:} Function ... |
|
Some time ago I was asked to make a print form in Lotus Notes (R7), that required certain things you would normally rather do with a word processor. One of these things was a variable, computed footer (a dblookup from a parameter). Now Notes knows footers and Notes knows computed values, but it ... |
|
I had to write a small maintenance agent to reset NotesItems, and, to not accidentally trigger it, I used the @Prompt function to ask the typical "Are you really sure?" question - not a good idea ;-) The result was, that I had to keep clicking message boxes until the agent was finally done - ... |
|
<embed src="http://www.youtube.com/v/8uy7micFCcA&hl=en_US&fs=1&" ... |