Multivalue fields split in a categorized view

HCL Domino Domino Forum
1

Hi,

I have a form, with a multi-value field called category. There are a long list of categories available for selection, here is a subset:

Accounting

Business Controls

Geo-Americas

Geo-Asia

Geo-Europe

If the customer creates a document with the title “test”, and selects categories Accounting, Geo-Asia, and Geo-Europe, the view currently looks like this:

Accounting

___test

Geo-Asia

___test

Geo-Europe

___test

The customer is requesting that, instead, the view look like this:

Accounting

___Accounting ← Can be anything, I figured repeating the cat would be easiest

______test

Geo

___Asia

______test

___Europe

______test

Is there any way to do that? Everything I try ends up putting the Asia and Europe categories under the Accounting category as well.

Thanks!

2

Subject: Multivalue fields split in a categorized view

In the view’s column formula, use @ReplaceSubstring to replace the “-” in the category with a “\” … that will create a Cascading Category, and you’ll end up with …

Accounting

______test

Geo

___Asia

______test

___Europe

______test

Something like @ReplaceSubstring(Category;“-”;“\”)

3

Subject: RE: Multivalue fields split in a categorized view

Awesome! That was perfect! Thanks!

4

Subject: Multivalue fields split in a categorized view

use javascript…