We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

Filter Multiple Value Fields in View

rdd265
rdd265 asked
on
Medium Priority
256 Views
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?
Comment
Watch Question

Groupware Consultant
CERTIFIED EXPERT
Commented:
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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

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?

Author

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.
Sjef BosmanGroupware Consultant
CERTIFIED EXPERT

Commented:
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.
Sjef BosmanGroupware Consultant
CERTIFIED EXPERT

Commented:
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.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.