Use calculated columns as separators for trees?

JonP

Ever since I started playing with the tree widget, I've been frustrated by the fact that there is no way to include a separator between attributes, making multiple attributes per level an unrealistic option. But then I noticed with the new dynamically calculated columns feature that there is an option to output the result as plain text. What if you could add a separator that way? I tried it 2 ways...

1) Attribute1 provided normally with second attribute as a calculated column: '| ' + BO.Attribute2.
2) Both attributes provided normally with calculated column as '|' in between attributes.

No luck. Any ideas?

JonP

WARNING: UGLY HACK AHEAD!

Have your air sickness bags at the ready...

I decided to create a fake plain text attribute in the SystemSettings BO called FauxSeparator with a character count of 1 and an initial value of |. It didn't work because you can't reference SystemSettings in either a calculated column or a shortcut.

So I created a fake plain text attribute in Account (uppermost parent BO) called WTF_Separator with the same settings as above and created a shortcut to it. That worked. You would need to create a different shortcut for each separator at each level of the tree.

tford

WTF_Separator

Love it!

Jaymer

WTF_Separator

You can tell John was frustrated by that point!