lotus-formula

Update a list element with Lotus Formula

I am trying to update an element in a list with Lotus Formula. I thought you would do it like this: x := "0":"0":"0"; x[1] := "1"; But when I try to save I get the following error: := must be immediately preceded by a field or variable name ...

How can I do an indexOf() in Lotus Notes Formula language (@ commands)?

I can't find this anywhere in the Domino Designer help. It seems so straightforward! All I need to do is find the position of a character in a string. ...

How do I select all documents from the last 7 days?

I have a view selection formula SELECT @If( @Date(@Now) = @Date(@Created); @All; @False) and I want it to select all documents from the past 7 days rather than just today's. Thanks in advance for any help. ...

Get Today's Calendar Entries in Lotus Note using Java

I am trying to get the calendar entries for a given day. The code works without error however I am getting a wrong calendar date entry. I am sure the formula is correct but neverthless would appreciate any help on this. Here's the code. long startTime; long endTime; String searchFormula; DocumentColle...

How to check if file exists in lotus formula?

Scenario: I have an outline where I have links for my menu. Each link points to file stored on FTP server in DMZ. By clicking each link I run the agent which downloads the file locally and deliver url to it for end user. I would like to hide outline element when file does not exists. Obviously I do not have this information before I tr...

Defining Shortcuts for Lotus Notes 8.x

Hi All, Can someone please tell me how to define a shortcut for a custom command in lotus notes. I was able to define my custom command in under the preferences toolbars section. Now I want to assign that a shortcut (or accelerator key). Can someone please tell me how to do this. I thought once I had defined the custom command I cou...

How do I select all documents manager

I'm new to Lotus development and I need to create a view that shows where the user is manager of another database besides its own mail. Thanks in advance for any help. ...

How to add a field from a 2nd form?

Hi all. I'm modifying an existing Lotus view to include a field from another form. I first appended a new column and set it to the desired field. However, after I refreshed, the new column was blank even though I know it has data. I then updated the View Selection formula from: SELECT Form = "A" & StatusIndex < "06" to: SELECT (For...

How to calculate the date difference between 2 dates using Lotus Notes

How to calculate the date difference between 2 dates using Lotus Notes Fourmular ...

No of Years, Month and Days

I created Lotus Notes database for HR Department. I entered field Join date. Also entered field “Total Service Period”. I want get the calculated Number of Years, Month and Days of service in to “View” and to update the service period daily. ...

Open an attachment for editing and save changes made to it

My Lotus Notes document has a rich text item that stores an attachment. I want to edit the attachment and after this to save the attachment back to the Lotus Notes document. This is the script that launches the attachment: @Command([EditGotoField];"Attachment"); @Command([EditSelectAll]); @Command([AttachmentLaunch]); @Command([EditDe...

Sorting column in both way in Lotus Notes.

I have a Main field which consist the value of 10 other fields for each document , when I tried to sort this field value in the view column using the column sorting properties I didn't get the desired result. Here is the example how value is displaying - 10.other 10.other 1c.NSR 10.others 1c.NSR 2b.First in Fab 10.other 10.other it sh...