Use View Dialogue for choices options

Posted on 2006-04-18
Last Modified: 2013-12-18


I've got a Dialog List field which uses a View Dialog for choices options.  The View is displayed and the value in column 1 of the selected document is returned to field 1.  How can I add to this so that the values from column 2 and column 3 are added to fields 2 and 3?  

The issue is in the View Dialog there could be several options with the same name (for example there are 10 John Smith) and when I compute fields 2 and 3 using a standard @DbLookup it pulls in the value from all 10 John Smiths into fields 2 and 3

I'm convinced this should be easy but today is not my day.  Too many easter eggs.
Question by:RichardStarkey
    LVL 14

    Expert Comment

    try @Unique(@DbLookup(.........))  
    LVL 13

    Accepted Solution

    I often tend to use a @Picklist in a button or hotspot instead and rerieve either concatenated data or the chosen document's unique id (@Text(@DocumentUniqueID)).
    Field 1, 2 and 3 would be editable and hidden and each of them would be accompanied by a similar computed for display field.

    If the value you retrieve is a UNID:
    UNID := @Picklist(.....);
    Field field1:=@GetDocField(UNID, "Field1Source");
    Field field2:=@GetDocField(UNID, "Field2Source");

    If the value you retrieve is concatenated data (using e.g. "~" as separator):
    concData := @Picklist(.....);
    Field field1:=@Word(concData; "~"; 1);
    Field field1:=@Word(concData; "~"; 2);


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Suggested Solutions

    I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
    Article by: Rob
    Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now