You can use the "Edit bill of materials table" command to add/remove rows or columns in the table, and add balloons to your drawing table data:
Once you press this command, "Select table" will appear next to your mouse cursor. This may take a few sections the first time it is run on a drawing. After "Select table" appears, click on a Bommer table to launch the command:
If you have already run a Bommer Drawing command for this drawing instance, you can also double click on a table to edit it.
If you click outside of the table (or click on a non-Bommer drawing entity), nothing will happen; you can click a second time. This can happen if you click inside of a table cell, so to ensure the table is selected make sure the table is highlighted as illustrated above. If you want to abort this process, you can press the Escape key or run another Fusion 360 command.
Once a table is selected, Bommer will load the table for the table and then open the command window:
Live preview
When editing a bill of materials table, Bommer will update the table on the drawing sheet live to show what the table will look like if you save your edits. There is also some limited interaction such as resizing columns or moving the table that you can perform with the table on the sheet while the editor is open.
Navigating and selecting rows
The bill of materials in this command is organized hierarchically. You can use the arrows on the left to expand or contract rows. The checkboxes in the second column let you select a row to include in your table.
You can quickly select or unselect all rows in your BOM by clicking the … button in the “Selected” column header:
If you want to select all parts in an assembly or all subcomponents for a row in the table, you can click the ... button:
- Select children will select all of the immediate children under that row. This will not select the row itself. You can use this to easily create "top level" BOMs by performing this operation on the root row.
- Select all descendants will select the row and every row that falls under that row. This can be used to create all-items BOMs.
- Unselect children will unselect the immediate children underneath a row. It will not unselect the row itself.
- Unselect all descendants will unselect the row and every row that falls under the row.
Selecting columns
To add or change columns, and change other column-related settings, hover over a column in the table to make the wrench icon appear next to the column name.:
This menu has the following options:
- Insert column before - click on this option and select a property name from the sub-menu to add that property as a column immediately before this column.
- Insert column after - click on this option and select a property name from the sub-menu to add that property as a column immediately after this column.
- Change property - click on this option and select a property name from the sub-menu to replace this property with the selected property.
- Remove column - click on this option to remove this column from the table. This shifts the columns to the right over to fill the space.
- Combine rows by ... - click on this option to tell Bommer to combine rows by the selected property. This enables workflows where separate rows (e.g. mirrored components, copied components) share the same part number and should be combined into the same table row.
Editing your column names
You can change the name of a column in a table by opening the editor for that table and changing the text in the box at the top of that column of your table's columns by editing the name at the top of the columns in the Edit bill of materials table command. Note that changing the property for a column or removing a column will reset the name change (if you add that property back in).
The "Item # (editable)" column
Bommer bill of materials tables can contain a special property called "Item # (editable)"; this is the only editable column currently available in the Edit bill of materials table screen (from this/the Drawing workspace). At the moment, Bommer is not able to read the balloon numbers from your drawing but you can use this column to enter the numbers assigned to the parts in your BOM.
To add this column, use either of the insert column commands or the change property commands from the Wrench menu. Item # (editable) will be at the top of the list.
Click on Item # (editable) to add that property to your table:
You can then use the text box to rename it as needed.
Resizing columns
You can resize your data columns by hovering over the line separating each column until the cursor changes:
Then click, and drag to resize.
You can also resize your data columns by clicking and dragging directly on your drawing sheet. See Modifying a table outside of Bommer for more information. If you do this while the "Edit bill of materials table" command is up, these edits will be saved when you press Ok and reverted if you click Cancel.
Sorting rows
You can sort the rows in your table by clicking the arrow button next to each column name (in the column header). After clicking once, the table will be sorted by the values in that column, in ascending order. Click again to sort in descending order, and then once more to clear the sort and return the natural order. Sorting is performed "in-level"; each subassembly's children are sorted, and then the subassembly's parent's children are sorted, up to the root component. This sort will also be reflected in the drawing table.
You can use this feature along with the Item # (editable) column to create any sort order you want (irrespective of your BOM data). To do this, add/select the Item # (editable) column, add numbers in whatever order you would like, and then sort your table by Item # (editable).
Filtering Rows
Bommer allows you to filter your BOM data as you are selecting your properties to edit. By pressing the funnel icon in the top left section of the table you can expand the table to give you a filtering menu.
You can filter on any property either by typing in the value you want to filter on or scrolling down to the selected value. You can also pick Empty Cells — which will show rows where the cell in that column is empty — or Any Value — which will show rows where the cell in that column is not empty.
You can toggle whether this filter is applied by clicking on the funnel icon to hide the filter row. The filter will only be active when the filter row is visible.
To clear this filter just press the the icon of a funnel with an X next to it.
When a filter is applied, the … menu in the selection column header changes: instead of selecting or unselecting all rows, now you can select or unselect all visible rows (i.e. all rows that pass the filter).
Scaling the text in your table
The Bommer table will, by default, use the font and font size defined in your drawing's document settings. If you need to make the bill of materials font smaller (to fit more data, or to fit it into a certain area of your drawing) you can scale the font up or down using a slider underneath the Edit bill of materials table.
This will also change the row height to match, but will not automatically adjust column widths or overall table size.
Flattening your drawing BOM
The toggle to Flatten your BOM table in drawings will allow you to get a parts only BOM in your table. Note that while selecting the components in this mode the hierarchical view will still appear in the selection window but when you look at the table itself it will be a parts only selection. This will roll up part names and numbers into a single column.
Ballooning parts from your table
You can place custom Bommer balloon data directly from the edit table. Hover over a cell to show the Add balloon button, then click on it and then on a model edge on your drawing sheet to place a balloon that will be in sync with this table's row and property value.
For more information on this please check out our full custom balloons guide.
Saving changes
Once you are done editing the table, press OK to save your changes and update your new table configuration (the set of columns, names, and widths to use when creating a new table). This will create an undoable event in Fusion 360, so that you can undo your edits using the standard Fusion controls.
Discarding changes
Press Cancel to discard your changes. This will revert the table on the drawing to the last saved configuration, and will not update the configuration used for new bill of materials tables.
Comments
0 comments
Article is closed for comments.