: 4582 | 108668 | 12353
Domino Designer|

Domino Designer / - formula 


@IsRichTextEmpty and LotusScript/Java equivalents

: Domino Designer
: richtext, @formula, lotusscript, java
Ben Langhinrichs7009 - 05 2007 / (4)
Even having a rough way to do this in Midas, I would really like to see a simple @formula (and matching LotusScript) method for determining if there was anything in the rich text.  Even better would be if it took an argument that specified whether whitespace was included, so you ...

Custom @Functions

: Domino Designer
: @formula, lotusscript
Carl Tyler5446 - 08 2007 / (6)
1-2-3 has a feature where you can create a new @function based upon a lotusscript function.  I would like to see the same feature in Notes/Domino.  Allow me in the Database script library to create a lotusscript function and mark it as being available as an @function within that database.

Bring us back the Formula Debugger

: Domino Designer
: designer, formula, @formula
Werner Novak1161 - 07 2008 / (5)
Please bring us back the @formula debugger !!
Local and Remote Debugging !!

Define View Column Titles using @Formula

: Domino Designer
: view, column, title, @formula
Philippe P.348 - 29 2009 / (2)
Now you can only specify 1fix text label for Notes view column titles. 
It would be very usefull to be able to specify an @Formula to define Notes view column titles. Especially in multilingual environments, where you can use @formula to show the column title in the user's language.

PickLists should have a defaultchoice

: Domino Designer
: designer, @formula, picklist
Theo Heselmans6409 - 28 2007 / (2)
I often use @PickList (and its lotusscript cousins) with the [Custom] option.
I would like to present the dialogbox with the current entry (or entries of it's multi-value) already selected, so she/he does not have to start from scratch.
@Prompt has a defaultchoice parameter too.

Display @Formula comments as comments

: Domino Designer
: @formula, comments
Harkpabst Meliantrop3248 - 17 2008 / (1)
... not as a keyword, followed by a text constant.

MaxResult parameter in @DbColumn

: Domino Designer
: @formula, @dbcolumn
Patrick Kwinten22018 - 08 2007 / (1)
The possibility to add an additional parameter to @DbColumn where I can define the maximum results I want to have returned:
@DbColumn( class : cache ; server : database ; view ; columnNumber ; maxResult )
In stead of getting the complete chunk of results back now I only ...

@IsDocEditor function

: Domino Designer
: domino designer, @formula
Lasse Jarvinen958 - 22 2010 / (3)
A formula that would return:

  • “1” if user has right to edit the currently open document 
  • “0” if user has only rights to read the document

This would be a very useful function when writing hide-when formulas or formulas to insert subforms especially when user has ...


Increase the amount of data formula can output

: Domino Designer
: formula, @formula, evaluate
Tommy Valand2746 - 17 2008 / (2)
As far as I know, formula can only output 64k of data.

This especially limits the usage of formula in Evaluate-statements.

Formula is --really fast-- compared to LotusScript. Formula has some inbuilt functionality that LS lacks. Two really powerful are @Tranform and @Sort. ...

formula field properties

: Domino Designer
: @formula
Paul Davies12381 - 21 2007 / (0)
I would like to see all properties of fields that use formulae to be moved to the IDE pane instead, i.e.
lookup formulas, hidewhens, captions etc
this allows the functionality of the IDE to applied to these formulas (colours, attribute help etc)

Use @Formula to change field font color

: Domino Designer
: @formula, fonts, color, field
Hendrik Jan van Meerveld729 - 01 2009 / (1)
Make it possible to change the font color or background color of a field using @Formula.
You could for example warn the user if a required field is empty by changing the backgroundcolor,
Color formula:
red := 255:150:150;
black := 0:0:0;
@If( fieldvalue=""; red:black )

@Formula functions

: Domino Designer
: @formula
Keith Strickland910 - 08 2007 / (2)
How about a way to include @Formula language functions in something like a LotusScript library. This should cut down on the amount of code written for validation formulas and commonly used formulas to determine the value of a variable, etc. I think this would be made even easier since the ...

computed text - lotusscript

: Domino Designer
: computed_text, @formula, lotusscript
Patrick Kwinten22018 - 19 2009 / (1)
since you can do more with LotusScript compared with formula, making LS available under computed text would create new opportunities.
for example db.alldocuments and dc.count would give me the number of documents in a database. how easily would i do this with formula?

Increase the number of functions/formulas in XPages

: Domino Designer
: xpage, @formula, @function, compatibility
Patrick Kwinten22018 - 26 2010 / (0)
In an ideal world formulas in @Formula language or @functions are also available in XPages:

New @Formula: list := @ResponseDocuments (..., ...)

: Domino Designer
: @formula
Slawek Rogulski8874 - 15 2008 / (0)
Provide a new function, @ResponseDocuments that can be run in the context of the currently opened/processed document and will return a list of UNIDs of all the responses or a list of field values from the response documents.
For example:
UNIDlist := @ResponseDocuments ([UNID], [NOCONFLICT]);
would return a list of ...

Have @GetDocField and @SetDocField access other databases

: Domino Designer
: @formula, fields
Hendrik Jan van Meerveld729 - 30 2009 / (1)
This would be great for updating fields. One could write:
@SetField("strStreetname"; @GetDocField( contact_replicaid; contact_unid; "strStreetName"));

Fix the bug of @BrowserInfo

: Domino Designer
: @formula
Rishi Sahi1687 - 24 2009 / (1)
BrowserInfo("BrowserType") doesn't work anymore with latest browser and newer versions. When verified on Mozila Firefox 3 , it returns Netscape instead of Mozila.
Also, @BrowserInfo("Version") returns 5 when verified on Mozila 3.0 and returns 5 for Safari 3.2 as well.
Note : Tested on R8.0.2

Make @DocChildren / @DocSiblings / @DocDescendants work in any other formula

: Domino Designer
: @formula, @function, @dblookup, @dbcolumn
Patrick Kwinten22018 - 09 2008 / (0)

this could be usefullfor example build tagclouds via @dbcolumn / @dblookup


Add server and database as optional parameters for @GetProfileField and @SetProfileField

: Domino Designer
: @formula
Vlad Sh10448 - 29 2013 / (1)
by analogy with @DbColumn and @DbLookup: (...; server: database; ...).

@Random for lists

: Domino Designer
: @formula, lists
Patrick Kwinten22018 - 21 2007 / (2)
if my text list look like:
textList:= "London" : "Stockholm" : "New York" :"Bagdad"
I would then like to be able to use


Welcome to IdeaJam

You can run IdeaJam™ in your company. It's easy to install, setup and customize. Your employees, partners and customers will immediately see results.

Use IdeaJam to:

  • Collect ideas from employees
  • Solicit feedback and suggestions from employees and customers
  • Run innovation contests and competitions
  • Validate concepts
  • Use the power of "crowd-sourcing" to rank ideas and allow the best ideas to rise to the top

IdeaJam™ works with:

  • IBM Connections
  • IBM Lotus Quickr
  • Blogs and Wikis
  • Websphere Portal
  • Microsoft Sharepoint
  • and other applications.

IdeaJam has an extensive set of widgets and API's that allow you to extend and integrate IdeaJam™ with other applications.

Learn more about IdeaJam >>

IdeaJam developed by

Elguji Software Logo