Stack Overflow
Stack Overflow

Questions tagged [lotus-formula]

Internal Lotus Notes formula language. All commands start with the '@' symbol, and because of that another name for Lotus formulas is "@-formulas".

Internal Lotus Notes formula language, used for following purposes:

  1. Database replication control (what should be replicated)
  2. Computed field formula calculation
  3. Editable field default value calculation, input translation and input validation actions
  4. Form/View/Page/etc property (window title, ) calculation

And much more.

It was the first language implemented for Lotus Notes by Lotus Software Company (now belongs to IBM Corporation). LotusScript was the second language, with richer functionality. But for some purposes there is only lotus formula available. For instance, calculating text for window title.

323 questions
5
votes
4 answers

Calling Lotus Script Function From Lotus Formula

I need to call a lotus script function from Lotus Formula. The function returns a result. I do not just want to run a script which does not return any value. This is for Lotus Notes 7. Example LotusScript Functions: Function isName( name As…
Andrew
  • 51
  • 1
  • 2
4
votes
4 answers

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.
Todd
  • 313
  • 1
  • 4
  • 17
4
votes
1 answer

How to make automated notification using Lotus Script

I know that using Lotus Script you can make an notification (auto email), ONLY If you have some control that will be triggered manually (like a button etc etc..). What I want is to trigger the notification automatically (with out human…
Bimbz
  • 443
  • 2
  • 5
  • 18
3
votes
1 answer

*= operator in formula language in lotus notes

Please tell me what is the role of *= operator in below piece of code @If(@UserRoles *= "[admin]" ; "" ; @Return("")); It is formula language used in lotus notes databases.
NotesArt
  • 383
  • 9
  • 20
3
votes
6 answers

Create Lotus Notes hotkey/shortcut key for "reply to all with history"

Because I like to make common actions quick to access, I'd like to define a hotkey, e.g. Alt+L to do "reply to all with history", to act on the selected email. I'm using Lotus Notes 8.5 under Windows. Currently I have to either click the Reply…
Dean Hill
  • 4,369
  • 6
  • 31
  • 35
3
votes
1 answer

Refresh regular view and embedded view

I have a view from which I can open documents and change its status. After I change status document is being closed but view doesn't refresh until I press F5. Same thing happens when I create a response document from an document with embedded view.…
Anatoly
  • 5,056
  • 9
  • 62
  • 136
3
votes
1 answer

Hide when formula returns always true

I have a view called "vwTest" which has one column and lists 3 docs: John Mcoy Peter Pap Ashley Young I have a picture with a default hotspot on which I typed the following Hide when formula: view := "vwTest"; nume :=…
Florin M.
  • 2,159
  • 4
  • 39
  • 97
3
votes
1 answer

Lotus Notes custom view received mail

I am using lotus notes 8.5.2 on windows 7. I would like to create a custom view that shows all emails EXCEPT sent mail. In other words it contains: INBOX & ALL FOLDERS. Currently my ALL DOCUMENTS view has the following formula conditions: SELECT…
Xavier Bourret Sicotte
  • 263
  • 5
  • 14
2
votes
3 answers

@dbcolumn in session.evaluate in xpages

I am trying to execute this code for a listbox but its not working, this gives me the error 500. If i directly write the @formula in listbox it works fine. return session.evaluate("@DbColumn(@DbName(), \"viewName\", 1)").elementAt(0) but if i write…
NotesArt
  • 383
  • 9
  • 20
2
votes
5 answers

Lotus Notes toolbar button to move documents to favorite folders

I'm looking for assistance to create some Notes toolbar buttons to move selected documents to a favorite folders. I just want to hardcode a specified folder per button. I'm not familiar with Notes Formula language or creating buttons so any tips…
PeterE
  • 23
  • 1
  • 4
2
votes
2 answers

Notes toolbar button to archive selected (email) document

You can archive e-mails immediately by using the menu, Actions > Archive > Archive Selected Documents. How can I create a toolbar button that I can click which will perform the above action? I've already created toolbar buttons to move documents to…
Ben
  • 67
  • 1
  • 4
2
votes
1 answer

Lotus Notes 8.5 client hide action button

I am having problems hiding an action button in a view. We recently upgraded to 8.5 and the method I used to use no longer works. I used to be able to create a role in the acl. Then add this formula to the action button properties "Hide action if…
Mike
  • 713
  • 6
  • 20
  • 41
2
votes
1 answer

@command([ToolsRefreshAllDocs]) not working in Lotus Notes

I changed property of few form fields in my lotus notes database. There are 1000+ documents in the database. To reflect that field property change if I open each document and and then Save and Close it, the field is getting updated. But doing it…
Kirti Jha
  • 93
  • 1
  • 3
  • 10
2
votes
1 answer

Document selection fails in view for one user

In Notes 9.0.1 the following formula in an Action Button on a categorised view of Company/Contacts throws the error prompt for one user, even though they have selected a Contact. The error is the same with the margin selected and the document…
Mark Maden
  • 468
  • 2
  • 13
2
votes
3 answers

Filter View on Year value of Date

I have a view that so far works okay but now I need to add a column that shows the year the document was created and filter to only show documents created after the year 2011 (2012 on-wards). The view is created with the formula of; SELECT…
AJF
  • 1,801
  • 4
  • 27
  • 54
1
2 3
…
21 22