Multiple values using aliases

HCL Domino Domino Forum
1

Hi, I know this is easy, but I’ve long since forgotten how it is done:In a form, I have a dialog box (DialogBox) allowing multiple values, with aliases for values:

one | 1

two | 2

three | 3

etc…

Let’s say I save a document with values “one” and “three” checked. DialogBox = 1,3 now in that document.

When I create a view and select DialogBox as one of the columns, I get “1,3” for that record. I can’t figure out how to show “one,three” as the result though.

I used the column formula:

@If(DialogBox=“1”;“One”;DialogBox=“2”;“Two”;DialogBox=“3”;“Three”;“No Number Specified”)

The result is just “One” in the new view. It grabs the first condition apparently and quits. Is this a glitch or what am I missing? Thanks!!

Todd

2

Subject: Try:

DVals := @Explode(“one,two,three”, “,”);RVals := @Explode(“1,2,3”, “,”);

@Replace(DialogBox; RVals; DVals)

3

Subject: multiple values using aliases

Try:

@Replace(DialogBox; “1”:“2”:“3”; “one”:“two”:“three”).

I think that should work in a column formula.

Hope that helps

4

Subject: RE: multiple values using aliases

Awesome!!! Worked like a charm.You guys are the best!!!

Thanks,

Todd