Null value for combo box --- Solved

HCL Domino Domino Forum
1

I have made a combo box with multiple dbcolumns as the selection formula. This code works great; however some of the values are null and cause confusion to the user if they are not aware that a piece of information is missing. With that being said, I want to display a word in place of the null value notifying the user that the specific value is missing. Here is the code I am using now behind the combo box.

product := @DbColumn(“”;“”:“”;“pro_allbyproduct”; 1);

version := @DbColumn(“”;“”:“”;“pro_allbyproduct”; 2);

CSD := @DbColumn(“”;“”:“”;“pro_allbyproduct”; 3);

platform := @DbColumn(“”;“”:“”;“pro_allbyproduct”; 4);

bundle := @DbColumn(“”;“”:“”;“pro_allbyproduct”; 6);

product + " " + version + " " + CSD + " " + platform + " " + bundle

This is an example of what I would want displayed.

Lotus v6.5 No CSD Server 2000 No Bundle

AIX No Version 3.4RT Server 2000 No Bundle

etc.

I am thinking this can be done by an @if statement, but I’m not sure. If anyone has any examples of this or know where I can find some or have any ideas as how to start this, I would appreciate it.

2

Subject: Null value for combo box

couldn’t you just put…

product := @DbColumn(“”;“”:“”;“pro_allbyproduct”; 1);

version := @DbColumn(“”;“”:“”;“pro_allbyproduct”; 2);

CSD := @DbColumn(“”;“”:“”;“pro_allbyproduct”; 3);

platform := @DbColumn(“”;“”:“”;“pro_allbyproduct”; 4);

bundle := @DbColumn(“”;“”:“”;“pro_allbyproduct”; 6);

product := @if(product = “”; “No product”; product)

version := @if(version = “”; “No version”; version)

CSD := @if(CSD = “”; “No CSD”; CSD)

platform := @if(platform = “”; “No platform”; platform)

bundle := @if(bundle = “”; “No bundle”; bundle)

product + " " + version + " " + CSD + " " + platform + " " + bundle

Something like those @If statements would work…although I’m not sure if i have the exact syntax…check out the domino help by hitting F1 in the designer.

hope that helps

julie

3

Subject: RE: Null value for combo box

That does work. Thanks a lot!

4

Subject: Null value for combo box

Try something like this:

product := @DbColumn(“”;“”:“”;“pro_allbyproduct”; 1);

version := @DbColumn(“”;“”:“”;“pro_allbyproduct”; 2);

CSD := @DbColumn(“”;“”:“”;“pro_allbyproduct”; 3);

platform := @DbColumn(“”;“”:“”;“pro_allbyproduct”; 4);

bundleLU := @DbColumn(“”;“”:“”;“pro_allbyproduct”; 6);

bundle:=@if(@iserror(bundleLU) | @trim(bundleLU) =“”;“No Bundle”;bundle);

product + " " + version + " " + CSD + " " + platform + " " + bundle

hth,

wmoze

5

Subject: RE: Null value for combo box

Just to reply to your suggestion, it gave me blank space where bundle was suppose to be.