Draft File Property....link to Spreadsheet Cell? Possible?

[av8errr]

Hello all,

I have a quick question.
Is it possible to link a spreadsheet cell to a propert within a draft file?
For example, I want the "Title" field link to a cell in a spredsheet that has a part number in it.
This would cause any callout referencing what is in the title field to show the part number.
I use callouts on my background draft sheet that reference title, subject, and category.
The generate a part number, tool number, and a description.

Thanks in advance,

Av8errr

 

[av8errr]

ST3 if it matters.

 

[beachcomber]

No, I don't think its possible.
You can link a numeric value in a spreadsheet cell to a variable in the model or draft file, and have that display in a callout, but not text strings. I suppose if the part number is entirely numeric, then it would work.
Put the part number in a property of the model or the draft.
I wouldn't use the 'Title' property either, I would use Document Number or create a custom property called PartNumber.

bc.
2.4GHz Core2 Quad, 4GB RAM,
Quadro FX4600.

Where would we be without sat-nav?

 

[av8errr]

Beach, thanks for the reply.
The part number is entirely numeric.
In the background of my draft, resides my title block.
I have callouts referencing title, subject, and category fields from the draft file.
I can do a paste link to the draft "title" property from a part variable link.
This requires me to insert a variable within the part file, and to assign it a value equal to the part number.
For this I meerly used a sketch, and assigned a line a lenth equal to my part number.
However, this generates a part number with two decimal places after it, and it also adds the units of measure at the end.
I have tried to modify the dimension within the part file by way of styles, but to no avail.

Maybe this is not possible?

Thanks for your insight...


Av8errr

-av8errrST3
xw46003GB
RAM2Quad CPU
3.00GHz

 

[beachcomber]

You dont need to use a sketch - you can just create the variable in the variable table, but make sure you check the 'expose' box.
Decimal places display is driven by the draft file settings but you can over-ride them in your property text - add /@0 after the variable name for no decimal places.

You should have something like %{V1234/@0}

You should be able to add another qualifier /@NU to get rid of the units, but I can't get that to work.
You would end up with %{V1234/@0/@NU}

Normally I would just turn them off in the draft file, but that might affect other things for you.

By the way, these work for any property text, so if you have a mass property text that comes from the first draft view you might use
%{Mass/@0/@NU|R1}

Hope this helps, but I still don't think its the right thing to do.

bc.
2.4GHz Core2 Quad, 4GB RAM,
Quadro FX4600.

Where would we be without sat-nav?