Microvellum Community

MV Development - Subassembly name references in product prompts

Some product prompts reference subassemblies by name, which is a problem when we save new subassemblies with a unique name to avoid overwriting with updates. The unique subassemblies are not recognized.


Example: OR portion of the formula in the value & control type column of Amount_To_Extend_Left_Toe_Kick & Amount_To_Extend_Right_Toe_Kick


Existing OR portion of the formula:


OR(Toe_Kick_Assembly="Adjustable Legs",Toe_Kick_Assembly="Notched Toe Kick",Toe_Kick_Assembly="Toe Kick Assembly Box")


Solution: Replace subassembly references with LEFT function.


OR(IF(LEFT(Toe_Kick_Assembly,15)="Adjustable Legs","True","False"),IF(LEFT(Toe_Kick_Assembly,16)="Notched Toe Kick","True","False"),IF(LEFT(Toe_Kick_Assembly,21)="Toe Kick Assembly Box","True","False"))


With this solution we can amend the toe kick subassemblies with our unique name: Example: Adjustable Legs ABC Company


I'm sure there are other places this will solve issues, this is one for me since we have a unique Adjustable Legs subassembly.

    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.