Microvellum Community

Material Formulas

How does everyone handle naming of their materials?  We have it where we have the Potential for PL-1 through PL-10, and are trying to figure the easiest way to name formula driven materials.  I am struggling a bit with how to go about naming things for PL-1 through PL-10 and only using one formula.

Currently I have something like this:

=PL_1_Core &IF(Formaldehyde_Free_NAUF_or_ULEF=1, " NAUF", "") &" - " &Mel_1 &IF(MEL_1_Has_Grain_Direction=1, " [GRAIN]", " [SOLID]") &" LINER UP - " &_PL_1 &IF(PL_1_Has_Grain_Direction=1, " [GRAIN]", " [SOLID]")

but would like to find a way for this formula to update for PL-1 through PL-10, so we only have a couple materials instead of one for each PL color.

Any help would be greatly appreciated,

Thanks
Aaron

    MVU eLearning



    Grow Your Knowledge
    Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.


      Follow us on:

               

        ERP for Millwork Shops


        Discover how Microvellum and INNERGY streamline operations for cabinet shops and millwork manufacturers.