How to prevent (Not Categorized) from being displayed?

I have created a view and in that view, the first column is displaying product names and the second column is displaying pc names and I have specified the formula to display only product names for the first column in this way-> product : product_1 : product_2 : product_3. The second column is displaying the pc names.
It display the product names but after all product names are displayed, (Not Categorized) is displayed with the pc names displayed in the second column.
What's wrong here with (Not Categorized) displayed?
How to prevent the (Not Categorized) from displayed?

Pls help.
Thank you.
Who is Participating?
zvonkoConnect With a Mentor Commented:
have you realy used my formula with @Trim and @Replace? This is to remove  all empty or only one or more blank chars containing product fields. Please check again (or best: cut'n paste my formula and place in it your product field names).



I assume that you're working in R4?

Those documents that appear under the "Not Categorized" column in your view probably do not contain information in the product, product_1, etc., fields that are being collected in the first column.

So, the column formula for the first column is the field: PRODUCT?

You have a FEW of choices here:

Set another value for "empty" fields in the categorized column formula:

@if(product="","**Other PC's, product)
so that documents where the field "PRODUCT" is null or empty will be displayed as "**OTHER PC'S"

Or, you can restrict the view collection to NOT  include documents where the field PRODUCTS is null or empty:

@Select(Form="thisformname") AND (products !="");@ALL

Or, you can edit the form so that the field "PRODUCT" has a default value, or a validation formula that sets the default value to SOME value that will show up in your categorized view as a viable category.

Let me know if this helps,

Hello  kopibean,

my proposal to you is to use @implode/@explode around the list of products.

This would work imediately if your product names does not contain blank chars. But I supose they do. So next thing you have to do is to implode the product names list with special chars, so you can remove empty product names for explode.

(This all make only sense for cetegorized columns; if not catagorized, that use simple @If replacement)

For categorized columns use this formula:

Try out and tell me where this formula can be improved.

So long,
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Jean Marie GeeraertsApplication EngineerCommented:
Another way to display the multiple categories, but not displaying the (Not Categorized) message is to concatenate all the categories seperated with a BackSlash character.
Notes will translate this in seperate subcategories.

So you would only have 2 columns:
1st : all products concatenated with a backslash seperator
2nd : the PC-name

The formula for the 1st column would look something like :
P2:=@if(Product_2=""; ""; "\\" + Product_2);
P3:=@if(Product_3=""; ""; "\\" + Product_3);
P1 + P2 + P3;

When you sort categorized on the first column you would get a view that looks something like this :
> P1A
 > P2A
  > P3A
 > P2B
  > P3A
  > P3B
kopibeanAuthor Commented:
Hi zvonko,
I try your solution but does not work for when my product names contain blank chars. Thus how do I correct this error?

Hi jerrith,
I try your solution too but I do not want all my product names to be in separate subcategories. Thanks for your solution.

Hi marilying,
I try your solution but fail as (Not Categorized) is still being displayed. Thanks for your solution too.

But if there are any more methods to my problem, pls do post it. Thanks.
Jean Marie GeeraertsApplication EngineerCommented:
How do you want your view to look ?
Just post a little example and I'll look into it.
Also, mention the version of notes you are using and if this is for web use or only for the client.
by the way: I noticed that my categorized view shows productnames with blanks, but reducing to one embeded blank. If there was four blanks betwean words in product name, than it shows one blank inbetwean. Also first time I noticed that categories are categorized under first string found. That means, if you have two products:
"Alfa     Centaury"
"alfa   centaury"
, than you get category "Alfa  Centaury" becaus it was first in document order. Funny...
kopibeanAuthor Commented:
Thanks for all your solutions.
Thank you for the points <|;-)
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.

All Courses

From novice to tech pro — start learning today.