Getting unchecked items from check box in Lotus Notes

3255 pts.
Tags:
Lotus Notes
How do I get unchecked items from checkbox in Lotus Notes using Lotus Notes formula, For ex - see below I am trying to get in List3, whatever is not selected in list1, and trying to see the first item of the checkbox which is not selected.
testlist:="A":"B":"C":"D":"E":"F";
j:=1;
lst:=@GetField("List1");
@For( i:=1;i<=@Elements(testlist);i:=i+1;
@If(@IsMember(testlist[i];lst);"";
@Do(List3[j]:=testlist[i];j:=j+1)));
@Prompt([Ok];"";@Text(List3[1]))
But it is not working, can anyone help?


Software/Hardware used:
lotus notes domino 8.5
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Try using @Replace, for example:

@Replace( testlist; lst; “” )

Then, you can consider using functions like @Unique or @Trim if needed.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • shivasanjay

    Thanks, but if A,B,C are selected it displays as:

    ;;;D;F

    So, I modified in this way:

    testlist:="A":"B":"C":"D":"E":"F";
    @Explode(@Implode(@Replace(testlist;List1;"")))

    it works.

    3,255 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: