Problem @Unique and @Trim in a view based on a field value of a form

Posted on 2004-11-17
Last Modified: 2013-12-18
Hi, here's my problem...

Got a form...  2 different kind of fields:

1- Editable Dialog list (multiple values) containing the names of some people: "Some Body/something/something"
2- Editable Dialog list (single value) containing the status of a task: "Assigned", "Completed"...

Also got a view... The first column is Multi-value (semi-colon separator) with this formula:


Second colum of the view lists the different tasks assigned to these people.  There may be more than 1 task per person.

Here's what I want to do...  If the value of the STATUS field is "Completed", I don't want the task to be listed in the view, under the person's name (twistie)...  I only want the "Assigned" tasks to be shown under each people's row in the view...

Is it any possible??
Question by:barbotte
    LVL 14

    Accepted Solution

    In the view selection formula , add something like :

    select form = <formname> & status !="Completed"

    replace <formname> with your formname

    Author Comment

    Perfect !  Thank you...

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
    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.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    754 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

    20 Experts available now in Live!

    Get 1:1 Help Now