Back to zzTakeoff Community Channel LogoQ & A
45d 3h

Select a material or product dynamically?

Hi, is there a way to select a product based on a custom property selection? For example, If I choose an 8' wall height I want it to list 92 5/8" precut studs or if I choose a 9' wall height I want to list 104 5/8" studs. As of now I am creating two different takeoffs based on wall heights.


Thank you in advance for any advice/suggestions.


TJ

0

I think it should be doable using conditional logic in the formula.

Basically add both products to the takeoff and use if statements with conditions such as less than, greater than, or else tied to the wall height property.

For example:

If wall height ≤ 8' → use 92 5/8" studs

Else if wall height > 8' → use 104 5/8" studs

So both products exist in the takeoff, but the condition determines which one gets counted.


This is something I haven't messed with myself, but there's others on here that can confirm.

TJ 45d 1h

This worked. Great easy fix. Thank you.


The only remaining issue is that my items report (Material List) shows both but one with zero. Its ok, but not ideal to have unused items.

Hi TJ, I'm not sure on how you export, but you could filter our 0 qty items there to get rid of the unused items.

TJ 44d 5h

That could be a good workaround. Thanks Stephen.

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