Filter Multiple Value Fields in View

Posted on 2006-03-28
Last Modified: 2013-12-18
Hi Experts:  I have a question regarding views with multiple value fields.  I have three fields on my form, Job1, Job2, Job3.   I have a computed multiple value field called Jobs with formula Job1: Job2: Job3.  I have created a view that has Jobs as a column, and have checked the "Show multiple values as separate entries", so I get an 3 entries on my view.

Problem is that it is possible for one or more jobs to be blank, in which case I do not want them to show up on the view.  How can I go about filtering out the blank ones?
Question by:rdd265
    LVL 46

    Accepted Solution

    Two solutions:
    1) in the form, use the following formula to compute Job:
    2) leave the form as it is, but in the view column, use

    The first solution is by far the best, as computations in views should be avoided.

    Author Comment

    Works good, with one problem.  If all three fields are blank, they will still show up in the view.  Job column is categorized, so there is now a "Not Categorized" entry, and all forms with no entries in all 3 fields are there.

    Is there any way to get rid of them?

    Author Comment

    Don't understand why, but when I add to view selection !@Contains(Jobs; "") the view returns no documents.  However, I created a computed field called Empty that is set to "Yes" if Job1, Job2, and Job3 are null, otherwise it is "No".  When I add (@Contains(Empty; "No")) it get the desired results.
    LVL 46

    Expert Comment

    by:Sjef Bosman
    The result of the formula
        !@Contains(Jobs; "")
    depends a little on what the value of Jobs is, with or without the @Trim. If you didn't use the @Trim when saving the document, the formula will yield True only if all three job-fields did contain a real value. Otherwise, one of them was "", resulting in Jobs containing a "", hence a False result.
        !@Contains(@Trim(Jobs); "")
    might have produced what you want.
    LVL 46

    Expert Comment

    by:Sjef Bosman
    Why a B? The problem with the !@Contains(Jobs; "") seems a separate question to me... Ah, you didn't want to see the whole document if there was no job at all?? Sorry, that wasn't clear to me from your question.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
    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.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    729 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

    19 Experts available now in Live!

    Get 1:1 Help Now