My document has a field named as FieldA recording multiple values: “AAA”:“BBB”:“CCC”.I want to show it in two columns in a view with following result:
First column: Show FieldA as categorized and name this column as $99.
Second column: Show $99 directly
The result is:
AAA
AAA,BBB,CCC
BBB
AAA,BBB,CCC
CCC
AAA,BBB,CCC
Can I make result as following, how?
AAA
AAA
BBB
BBB
CCC
CCC
Subject: Separate multiple values in view cloumn
Sorry for more explanation.I set first column as “Show multiple values as separate entries”. And it works. The result is:
AAA
BBB
CCC
However, I set second column to get which category first column displaying in a relative entry. It’s failed. The result is:
AAA
AAA,BBB,CCC
BBB
AAA,BBB,CCC
CCC
AAA,BBB,CCC
What can I do?
Subject: RE: Separate multiple values in view cloumn
Nothing, I’m afraid. You can get the display to work the way you want if you don’t use categorization and only sort the first column, but it’s incompatible with categories.
If you need something that’s more of a report than a view, you can create a display table in rich text that looks the way you want it to. And on the web, it’s pretty simple to create something that works exactly like the view you want, but there’s no way to make a native Notes view work the way you want it to.
Subject: RE: Separate multiple values in view cloumn
Thanks for your response. Stan.I really use categorization and sort first column. But result isn’t what I want.
I guess that although I categorize, separately show values of FieldA in a view column and name this view column as $99. But in fact, column $99 just show values separately. It still exists multiple values. After I set second column=$99, properly, second column show all values. Right?