Manage Learn to apply best practices and optimize your operations.

Smart combo lists

Here's how to get more popular items to appear at the top of a list.

In list fields where a formula is used to obtain values from a view column, etc, you can make some values appear at the top by using the following formula. The example below shows a formula that extracts a A - Z list of country names from a view but puts UK, US and a dashed line at the top of the list. Because I used @unique, UK and US are not repeated in their normal alphabetic position down the list. Hope someone finds this helpful. It saved my day once.

@Unique("United Kingdom":"United States":"---------------------":@DbColumn("":"";"":"";"Countries";1 ))

Dig Deeper on Lotus Notes Domino Administration Tools

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...