Adding a New Drawer Slide

Adding a New Drawer Slide

This article will show you how to add a new drawer slide to the Component Cabinet Library. 

Adding a new slide to your library will allow you to customize the drilling for the slide holes, the name of the hardware that appears on reports, and the 3D and 2D representation of the hardware in the drawing.

There are only two steps required to add a new drawer slide.

First, you need to create a lookup table table that stores the lengths of the slides, the drilling locations, and the hardware names.

Second, you need to add a row to the LookUpTableSystemDrawerSlide with the correct information for the slide entered into each column.

There is an optional third step where you can add 3D and 2D drawings for visual representation, but this is not required if you only need machining and reporting information. 

Create a New Table for the Drawer Slide   

First, we are going to create the new table that stores the lengths of the slides, the drilling locations, and the hardware names.

It is important to add the new table to the template so the change will be available in every new project.

It is also recommended that you copy one of the lookup tables for an existing slide and adjust the values to work for the new slide.

  1. From the Toolbox Setup Menu, select “Library Specification Groups.”

  2. Open Workbook Designer.

  3. Open the Global Variable Workbook.

  4. In the search field, select one of the tables that starts with “LookUpTableDrwSlide…”

  5. Copy the entire range, including the header.

  6. Go to the bottom of the worksheet and paste the range leaving one blank row.

  7. Change the header name to the name of the slide you are adding then update the data in this table. Each row represents a slide length. The first column is the length of all of the slides. Columns 2 - 6 represents the drilling location on the side of the cabinet. Column 7 is the name of the hardware that should be called out for each slide length. Column 8 is the last hole that is drilled for the slide holes. This is used by rollouts to determine where the rear spacer needs to be placed.
  8. Define the range by selecting all of the data, right-clicking, and selecting “Define a Range.” In the dialog, enter the name “LookUpTableDrwSlide” with the name of the slide at the end.

  9. Now that the information has been added for the new slide. Save the workbook and close workbook designer.

Extend LookupTableSystemDrawerSlide With the New Slide Data

Now we need to extend the LookUptableSystemDrawerSlideTable with the new slide. When adding a new row to an existing LookUpTable, it is best to use the Lookup table interface to ensure it updates all of the other tables ranges.

  1. In the template specification group interface, select the global variable icon.
  2. In the Global Variable interface, select “Show Look Up Tables” from the view menu. 

  3. At the bottom of the Look Up Tables Interface use the drop-down to browse to the LookUpTableSystemDrawerSlide.

  4. Select the row you want to add your slide above and select the “Insert Row Button” NOTE: It is recommended to keep the list in alphabetical order.

  5. Once the row is added, enter the name of the slide in the first column, then fill out the correct information for each column.

Below is a list of all of the columns in this table and a description of what the column calculates. For the most part, you can copy the formula from another row and change the LookUpTable reference to the new table that was created in the first step.

LookUpTableSystemDrawerSlide Column Information

  1. Slide - This is the name that you will select from the drop-down menu in the Global and prompt interfaces.
  2. Slide Height From Drawer Bottom - This is the distance from the bottom of the drawer side to the location of the slide holes that are associated to the side of the cabinet or division.
  3. Slide Clearance - This is the distance between the side of the drawer and the associated side or division. This is the total amount that will be deducted from the width of the drawer box.
  4. Bottom Gap at Bottom Drawer - This is the clearance from the bottom of the drawer box to the bottom of the cabinet. For the majority of the slides, this should read the global Bottom_Drawer_Space_From_Bottom, but some slides require a specific value.
  5. Bottom Gap and Mid & Top Drawers - Similar to the previous column, this is the clearance from the bottom of the drawer box to the bottom of the drawer front or the stretcher that is below the drawer box. For the majority of the slides, this should look to the global Drawer_Space_From_Bottom, but some slides require a specific value.
  6. Drawer Length - This column is a formula that calculates the length of the drawer. The formula looks up the maximum drawer length for the drawer that is being calculated and returns column 1 from the table that you created in the first step. It is recommended to copy the formula from another row and replace the reference to the LookUpTable with the table you created.
  7. First Slide Hole - This column is a formula that calculates the location of the first slide hole. It is recommended to copy the formula from another row and replace the reference to the LookUpTable with the table you created.
  8. Second Slide Hole - This column is a formula that calculates the location of the second slide hole. It is recommended to copy the formula from another row and replace the reference to the LookUpTable with the table you created.
  9. Third Slide Hole - This column is a formula that calculates the location of the third slide hole. It is recommended to copy the formula from another row and replace the reference to the LookUpTable with the table you created.
  10. Fourth Slide Hole - This column is a formula that calculates the location of the fourth slide hole. It is recommended to copy the formula from another row and replace the reference to the LookUpTable with the table you created.
  11. Fifth Slide Hole - This column is a formula that calculates the location of the fourth slide hole. It is recommended to copy the formula from another row and replace the reference to the LookUpTable with the table you created.
  12. Slide Name - This column is a formula that calculates the name of the slide that is currently being calculated. It is recommended to copy the formula from another row and replace the reference to the LookUpTable with the table you created.
  13. Drawer Length SA - This column is a formula that calculates the length of the drawer for nested subassemblies. The formula looks up the maximum drawer length for the drawer that is being calculated and returns column 1 from the table that you created in the first step. It is recommended to copy the formula from another row and replace the reference to the LookUpTable with the table you created.
  14. Rollout Length - This column is a formula that calculates the length of the rollout. The formula looks up the maximum rollout length for the rollout that is being calculated and returns column 1 from the table that you created in the first step. It is recommended to copy the formula from another row and replace the reference to the LookUpTable with the table you created.
  15. First Rollout Hole - This column is a formula that calculates the location of the first slide hole for rollouts. It is recommended to copy the formula from another row and replace the reference to the LookUpTable with the table you created.
  16. Second Rollout Hole - This column is a formula that calculates the location of the second slide hole for rollouts. It is recommended to copy the formula from another row and replace the reference to the LookUpTable with the table you created.
  17. Third Rollout Hole - This column is a formula that calculates the location of the third slide hole for rollouts. It is recommended to copy the formula from another row and replace the reference to the LookUpTable with the table you created.
  18. Fourth Rollout Hole - This column is a formula that calculates the location of the fourth slide hole for rollouts. It is recommended to copy the formula from another row and replace the reference to the LookUpTable with the table you created.
  19. Fifth Rollout Hole - This column is a formula that calculates the location of the fourth slide hole for rollouts. It is recommended to copy the formula from another row and replace the reference to the LookUpTable with the table you created.
  20. File Drawer Length - This column is a formula that calculates the length of the file drawer. The formula looks up the maximum file drawer length for the file drawer that is being calculated and returns column 1 from the table that you created in the first step. It is recommended to copy the formula from another row and replace the reference to the LookUpTable with the table you created.
  21. File Drawer Length SA - This column is a formula that calculates the length of the file drawer for nested subassemblies. The formula looks up the maximum file drawer length for the file drawer that is being calculated and returns column 1 from the table that you created in the first step. It is recommended to copy the formula from another row and replace the reference to the LookUpTable with the table you created.
  22. Undermount Notch Width - If a notch is required in the drawer back for an under-mount slide, enter the width of the notch that should be created. Otherwise, leave this column blank.
  23. Hole From Cabinet Side - Some undermount slides require a hole in the back of the drawer box. This is the distance the hole should be placed from the left and right edge.
  24. Undermount Hole Height from 0 - Some undermount slides require a hole in the back of the drawer box. This is the distance the hole should be placed from the bottom of the drawer back.
  25. Undermount Hole Diameter - Some undermount slides require a hole in the back of the drawer box. This is the diameter of the hole.
  26. Undermount Machine Notch - If a notch is required in the drawer back for an under-mount slide, enter a 1 in this column. Otherwise, leave this column blank.
  27. Undermount Clip Left - If undermount clips are required for this slide, enter the hardware name for the left clip. Otherwise, leave this column blank.
  28. Undermount Clip Right - If undermount clips are required for this slide, enter the hardware name for the right clip. Otherwise, leave this column blank.
  29. Rollout Slide Model - This column is a formula that calculates the name of the slide for rollouts.
  30. Rollout Rear Slide Hole Location - This column is a formula that calculates the location of the last drawer slide hole for rollouts. This is used to determine the location of where to place the spacers. 
  31. Full Extension and Single Extension Available - If single and Full Extension slides are available, enter a 1 in this column. If only one type is available, enter a 0.
  32. Regular Drawer Top Gap - The gap from the top of the drawer front or stretcher to the top of the drawer box.
  33. File Drawer Top Gap - The gap from the top of the drawer front or stretcher to the top of the file drawer box.
  34. 3D Hardware Graphics Folder - If you are going to have a 3D model to represent the drawer slide, enter in the path from the graphics folder to the folder where you placed the 3D model. 
  35. 2D Section Location - If you are going to have a 2D model to represent the drawer slide in cross-sections, enter in the path from the graphics folder to the folder where you placed the 3D model.  



    • Related Articles

    • Adding a New Pull in Toolbox

      Adding 3D and 2D Images for a Custom Pull To add a Custom Pull to a library, AND include a drawing, a drawing needs to be created or downloaded from an outside source, and saved in the Factory Database > Graphics > Hardware folder. To locate the ...
    • Adding Hardware in 3D with Subassemblies

      To add Hardware in 3D with Subassemblies, select Product Prompts and select the Product to be modified.  Fig. 01 - Product Prompts From the Product Prompts window, right-click and select Subassemblies.  Fig. 02 - Select Subassemblies from the Product ...
    • Overview of Hardware Spreadsheet Synchronization

      Our goal at Microvellum is to produce software that runs as efficiently as possible. We are continuously looking for ways to streamline the process and reduce the time it takes to load spec groups and save valuable performance resources. One example ...
    • Hardware from Machine Tokens (Overview)

      Microvellum software can now accumulate and populate hardware to the work order database based on specific machine tokens. It is one of the useful new Microvellum features supported in build 15.6.2201 or greater. This new ability works only with the ...
    • Office Drawer Cabinets

      Drawer Cabinet Description: Drawer stack cabinet with up to seven drawers. Main Options: Parametric Sizing Drawer Qty/Type Toe Kick Height Adjustable Feet Height/Type Left/Right/Back/Top/Bottom Finished Choices Rails/Inset Top/Full Top All ...

    Remote Assistance


      • Recent Articles

      • DXF Template Configuration

        A DXF Template file has been added for DXF files created during work order processing that includes the Dim Styles established in Options as well as a new viewport.  Now, when DXFs are created the Dim Styles and viewport are pulled from this ...
      • SQL Server System Requirements

        The article lists the minimum hardware requirements to install and run SQL Server 2019 (15.x) on the Windows operating system. This article lists system requirements for SQL Server 2019. However, earlier versions of SQL Server will also run with this ...
      • Foundation Library Update Process

        This article details steps for updating the Microvellum Foundation Library.  There are two ways to go about updating your existing library.  This document will list out the basic steps for each of the two scenarios.  Several factors will need to be ...
      • Associate Parts to Processing Stations (Part Mapping)

        Create New Part Mapping Toolbox provides the ability to associate parts to processing stations, often referred to as Part Mapping.  In this article, we'll look at Mapping Parts one at a time using the "Associate Parts to Processing Stations" ...
      • Report Training Tutorial 5: Configuring a Master-Detail Report

        This is the last in a series of five Report Training Tutorial videos.  In this video, we'll develop a new Master-Detail report and introduce new concepts, including using Sub-Reports to better organize your report and make report development a little ...