Hello,
I have two fields category A, Category B.
and 2 fields for products: CategoryAProduct and categoryBproduct.
CategoryAproduct field contains multiple values with each value in newline
CategoryBproduct field contains multiple values with each value in newline
The values in CategoryAProduct falls under CategoryA
The values in CategoryBProduct falls under CategoryB
I want to show the categoryproduct values under each category in a view like
category column is sorted and categorized
Category A
Tennis Ball
cricket Ball
Basket ball
Category B
Tennis Bat
Cricket Bat
other product
I tried but the results are not coming properly
If I have only one category its populating fine but multi categories, its not coming
Can you please give me an idea on how to do this in a view.
Thanks
srini
Subject: RE: HoW to categorize?
You have the following fields: CategoryA (multivalued), CategoryAProducts (multivalued), CategoryB (multivalued), CategoryBProducts (multivalued). If neither CategoryA and CategoryAProducts is blank, you want to display every CategoryAProduct value under every CategoryA value, and ditto with the other two fields. E.g. if
CategoryA = “Zoo” : “Art”
CategoryAProducts = “Chimp” : “Bird”
CategoryB = “Food” : “Auto”
CategoryBProducts = “Cupholder” : “Key”
Then you would expect to see:
Art
Bird
(document row)
Chimp
(document row)
Auto
Cupholder
(document row)
Key
(document row)
Food
Cupholder
(document row)
Key
(document row)
Zoo
Bird
(document row)
Chimp
(document row)
If this is what you want, you could write a formula such as:
@Trim(
@If(CategoryA != “” & CategoryAProducts != “”; CategoryA *+ “\” *+ CategoryAProducts; “”)
@If(CategoryB != “” & CategoryBProducts != “”; CategoryB *+ “\” *+ CategoryBProducts; “”)
)
If this is not what you want, could you please describe your requirement more precisely, the way I did above?