Filter Multiple Value Fields in View

Posted on 2006-03-28
Medium Priority
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
  • 3
  • 2
LVL 46

Accepted Solution

Sjef Bosman earned 750 total points
ID: 16313852
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

ID: 16314221
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

ID: 16315622
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
ID: 16319109
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
ID: 16319121
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

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses
Course of the Month15 days, 6 hours left to enroll

840 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