Filter Multiple Value Fields in View

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?
rdd265Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sjef BosmanGroupware ConsultantCommented:
Two solutions:
1) in the form, use the following formula to compute Job:
    @Trim(Job1:Job2:Job3)
2) leave the form as it is, but in the view column, use
    @Trim(Job)

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rdd265Author Commented:
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?
0
rdd265Author Commented:
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.
0
Sjef BosmanGroupware ConsultantCommented:
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.
0
Sjef BosmanGroupware ConsultantCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.