Discussions
Pivot in Saved Searches???
Hello community,
So this is the situation:
I have an Item where in the Description Tab, we created a Translation "Custom Record Type".
So in the saved search, we want to show the results like this:
ID Name (English) Name (French) Description (English) Description (French)
=============================================================
1 Hello Bonjour Bye Au revoir
However, when i put say the translation.name in the Results -> Columns, I get this result...
ID Name
===========
1 Hello
2 Bonjour
Now i tried doing a Formula (Text) and use a Case statement, but that doesn't work since it is going through each record in the Custom Record Type list.....