Would selecting a button to run a macro to transfer the BOM material work?
Possible but not easy. You will have to create an equation triggered macro (ETM). This will allow the macro to run to your specified solidworks event.
Here is a link to a Cad-sharp video on equation triggered macros