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

    Toolbox BSB Survey



    Have you been using Toolbox BSB? We'd love to hear what you think!

    Take the Survey

      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.