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?
Use calculated columns as separators for trees?
Use calculated columns as separators for trees?
v8.1 on Windows 10 / MySQL 5.6 (local), v8.1 on Windows Server 2016 / MySQL 5.6 (server)
Re: Use calculated columns as separators for trees?
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.
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.
v8.1 on Windows 10 / MySQL 5.6 (local), v8.1 on Windows Server 2016 / MySQL 5.6 (server)
Re: Use calculated columns as separators for trees?
Love it!WTF_Separator
Tom - V8.8 build 3137 - MySql / PostGres
Re: Use calculated columns as separators for trees?
WTF_Separator
You can tell John was frustrated by that point!
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL