Back to zzTakeoff Community Channel LogoQ & A

Drop Down Custom Properties, what am I missing in my forumla

Hello,


I am building an assembly for formwork for a vertical curb, and I created 5 options to build a curb which is a 2x4 all the way to a 2x12,


in the Formwork Assembly, I have a custom property that calls out Board Size, (I made 2 because it always requires at least 2 boards) I went with the drop down box method because I felt it was easier than putting a 1 down in each questions using the number method. within the drop down options I have both board sizes hidden and set to inherit







My main goal is that I have 5 options to choose and the two I choose on the assembly level, I want it to inhert down to the item level

0

Hey Fernando! I think the correct formula is "if("[Board Size]" == "2x12",[Linear:FT]/[Length of Boards]*[# of Faces/Sides], 0)". The main difference is using lower case 'if', 2 "=" instead of 1, and using "" around the board size tag.

Thank you for the assist!!, wow really impressive stuff !! Is there a guide or brochure that goes over all those technicalities for zztakeoff forumlas?

Hey Fernando, this article will probably help. We are planning to get a more complete guide soon.

also to add the other Board Size (the second one has a space at the end) it would be as follows?



(if("[Board Size]"=="2x12"+if("[Board Size ]"=="2x12"),[Linear:FT]/[Length of Boards]*[# of Faces/Sides], 0)

Are you trying to add the other board sizes to the same item, or to build out the other items? If you are trying to build out the other items, you would switch out the "2x12" for '2x10", "2x8", etc., for this formula and use that in each item.

I get that part I want the forumula to pick up the other board size since to form a curb it always take two types of boards




I want to be able to make 2x12 in either board size question

Ah gotcha. I would recommend using a different name for the custom property - like Board Size 2


In that example if you wanted to add up board size and board size 2, your formula would be "if("[Board Size]" == "2x12",[Linear:FT]/[Lenght of Boards]*[# of Faces/Sides], 0) + if("[Board Size 2]" == "2x12",[Linear:FT]/[Lenght of Boards]*[# of Faces/Sides], 0)"

Okay that works! but I am having trouble with the inheritance. Does it need to be applied on Board Size on the assembly level or item level? Because the board length and # of faces/sides do inherit but not the drop down answers


You must be logged in to post replies. If you don't have an account you can signup here.