You can use the "Edit bill of materials table" command to add/remove rows or columns in the table:
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:
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.
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.
To add or change columns, and change other column-related settings, you can click the wrench icon 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.
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.
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).
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.
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.
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.