Text in BOM quantity column

Is it possible to put text in the bom quantity column?  I need it to say A/N instead of a quantity.  I can make a custom column but I would rather have it come up automatically.

SolidworksBill Of Materials
Answers 9
SF
SF 2012-01-05 Best Answer

John,

I don't play around enough with BOMs to tell you what the answer is. Try it and see. Edit the cell to say what you want, then save it as your BOM Template. Open up a new drawing, insert the BOM, and see what comes up.

Jerry Steiger

SF
SF 2012-01-09

I've tried entering text to be placed in the BOM but it only ever gives the numerical quantity.  I can change the number but I am unable to get it to automatically display text.  I've had to work around it and hide the column and create a separate column.

SM
SM 2012-01-09

John,

You can double click on the cell and overwrite the existing quantity, but you will be prompted to

tell you that you will lose the parametricness of the cell.  Short of writing an API routine to possibly do this

I am not aware of a way.

SF
SF 2012-01-09

John,

Sorry, I misinterpreted and was answering (sort of) a question that you didn't ask. I think you are probably stuck with having a separate column where you show either the quantity or some text, unless you want to just overwrite the existing quantity as Scott suggested. It seems like his suggestion is the easiest solution.

Jerry Steiger

SF
SF 2012-01-09

I figured those were my only options but I though I would ask anyway.

Thanks for the help!

John Z

EB
EB 2012-01-09

John,

I think what you want to do is link the Qty. to a custom property.  Click on Help in the File Properties... dialog box, and you will find this.

You can see here I have selected the "UsedOn1" custom property.

There is just one small problem I see. I tried it just now and it no longer works for me.  I know it used to work, because I've seen it happen by accident.  I've never used it intentionally so there may be settings that I have wrong at the moment.  We just jumped from SW2010 to 2012, so I won't even try to guess about just when this stopped working (I've still got 2010 at home and will see how it works tonight, anyone running 2011?) or when/what got changed.

Anyway you might want to check into this (call your VAR maybe?) and see if you can get it to work for you since, according to Help, it looks like it should work even if I can't figure it out.

Good luck.

Erik

comment imagecomment image
SF
SF 2012-01-10

I have tried that but it never displays text.  I can put in a number and it always comes up.  If there is a setting I can change then I haven't found it yet.

Thanks

John Z

JB
JB 2012-01-10

John, I've run into this also.  the answer is tthat you can't get the QTY column to display text.  However, at my last job, I was able to set up another column linked to quantity with a formula and use that to report the values.

I tried to set up an example, but getting the table to display the result instead of the formula is proving difficult.

EB
EB 2012-01-10

John,

I was coming to that conclusion myself.  It's quite possible that the occasions when I have seen it happen by accident have all involved numbers, even though all the custom properties we use here are checked "Text" in the Type column.  I've never stopped to really look into it before, just changed "BOM quantity" back to -none- and moved along.

I was just thinking that it might be possible to use a formula to work around, and then I noticed John Burrill's reply.  I haven't put a formula in a BOM for a while, so I'm happy to leave figuring it out it to him.  You can do a lot with formulas but they can take some perseverance to get them formatted.  Usually worth the trouble.

Erik,