Hi,
This is my problem. I should get DriveWorks name table legs differently based on their shape and length. How to do it?
40 is height of the leg in the rule under this. N means configuration/type of the leg. This naming code works for one leg type at the time. Is it possible to get work on every config?
Idea 40 cm leg skinny confiq would be named as "table leg 40S"
45 cm leg heavy confiq "table leg 45H"
Many thanks
Ville Kahelin
I got it work now. You need double IF-rule.
Here's the solution:
=”*”&”Table leg”&(Table height/10)&
IF(Model:”Skinny”, ”S”, IF(Model:”Normal”, ”N”, ”H”))
Explained:
”*” = eliminates all text
& = Between all different "objects" (text, rules, etc)
”Table leg” = Text (needs ""-marks around to work)
(Table height/10)= Rule (Makes Table height mm to cm)
IF(Model:”Skinny”, ”S”, IF(Model:”Normal”, ”N”, ”H”))
= Rule IF Model is ”Skinny” it marks "S" in the end of name, If "Normal" "N" and otherwise "H"