Q & AItems Linked to Products
Looking to see if there is a way that product get linked to custom properties, so for example I change conduit sizes and types, I'd like to product to automatically change with the item property. Its looking like I would have to build a takeoff item for every type of product we put which would be quite combersome.
You mean the description name?
If so, you have to configure it as "Text with Tags" in the configure button that appears when you pass the cursor near it.
Once you have it configured this way you will have to introduce the following per the case you show: "[Conduit Size] [Conduit Type]".
In summary you can make automatic the change of this description linked to the custom properties you choose. Just make sure to follow the format of the name of the custom property inside the brackets [].
If this is not the case, you might need to use formulas, ut let me know, so I can go further on this.
I can do the name, that only make the name, but the price will not change based on what I have in the main list
In that case, so yes, the formula is the solution. At least I think so. First you'll need to configure "Cost Each" as a formula input.
Once that is done, you will have to prepare the formula that will reflect a pricing per your selection of the custom properties.
I haven't tested this on "Cost Each" yet, but I assume it might work for your case too.
I have this "Coverage" value which automatically updates per my selection of the selection from another custom property.
The formula I used is the following:"[Coat Thickness]"=="3/8 in"? 72:"[Coat Thickness]"=="1/2 in"? 54:0
This is just an "if" case formula. The logic if the following: "[Custom Property]"=="Value Selected"? (Here introduce the pricing that corresponds to the "Value Selected":(Value if the condition isn't true. In my case I contunie adding more conditions in chain for the rest of the options, logic is the same, you can see it in the example above).
Hope this helps.
Defeats the purpose from having a pull down list of materials that we can create.