Topic Options
Rate This Topic
#145096 - 09/17/10 03:57 AM Formula in Record Field value
tui_k Offline
Greenhorn

Registered: 10/25/06
Posts: 7
Hello everyone,

Is it possible to create a formula in a field value?

I am wanting to attach a text to a field in a door record, that automatically updates when the door size is changed.

Is this possible?

I can call up the door width in a worksheet using: paste criteria, and paste function. And this shows up in the worksheet.

I'd like to display this value on the drawing.

Basically I am creating a door symbol which has a text object which is attached to a record that displays the door width.

Attached is a example.

Cheers in Advance


Attachments
Door_text.JPG (108 downloads)


Top
#145134 - 09/17/10 07:30 PM Re: Formula in Record Field value [Re: tui_k]
Pat Stanford Offline

Vectorworks Addict

Registered: 01/28/04
Posts: 3279
Loc: El Segundo, CA, USA
Are you using the Door Plugin Object? If so, I don't think there is a way to do what you want.

If you are manually making the door symbol and create your own record format then you can use the Link Text to Record command to get text on the drawing that can be changed in a worksheet.

If this is something you really really need, a possible work around would be to use Vectorscript to copy the data from the PIO Door record and paste it into a custom record format. You would need a second script if you wanted to go backwards. And you would probably want a third script that would run through all the objects and make sure the data in the custom record was up to date.

Ask if you need more information.
_________________________
Pat Stanford

The PodCAD Podcast www.podcad.tv
New Episode Released 4-22-09
==============
Los Angeles VectorWorks Users Group lavectorworks@coviana.com
==============
Vectortasks Vectorworks Training www.vectortasks.com

Top
#145149 - 09/18/10 04:40 AM Re: Formula in Record Field value [Re: Pat Stanford]
islandmon Offline
Vectorworks Addict

Registered: 02/02/04
Posts: 3375
Loc: California
So often it appears that ideal parametric Symbol objects should be able to
display a dynamic text field listing the size. Then when the size of the object changes ... so too the text field. Viola !
However, specifying Doors within the planset requires schedules ... that's where all the action is; because each Door Symbol can have different characteristics and still be the same size as all the others.
What matters is that each unique Door Symbol contains a unique ID keyed to the Door Schedule.
As Pat indicates the Door Plugin Object contains fields & values which are readable via worksheet schedules.
_________________________
Architect, Civil & Geodesic Engineer ( retired )
User since Minicad v1.0
Bunch of stuff...iMac27,2.66 Core i5,8GB RAM

Top
#145299 - 09/21/10 12:23 AM Re: Formula in Record Field value [Re: islandmon]
tui_k Offline
Greenhorn

Registered: 10/25/06
Posts: 7
Thanks for the info guys.

So Pat, youre saying to write a vectorscript to copy the data from the Door PIO to a custom record.

Then in the symbol, link a text to that a field in that newly created custom record.

Is it possible to create a script to copy that data to a field in an existing record?

Where/how can I start. I have a fair understanding of the vectorscript language.

Cheers in advance

Top
#145354 - 09/21/10 07:12 PM Re: Formula in Record Field value [Re: tui_k]
Pat Stanford Offline

Vectorworks Addict

Registered: 01/28/04
Posts: 3279
Loc: El Segundo, CA, USA
Yes, that is what I am suggesting.

I would see if I could figure a way to use ForEachObject to get each door. If the custom record is already attached, then just copy the field from the Door PIO and store it in the custom record. If the custom record is not attached, then attach the record and copy/store the field.

You would copy and store the fields using the GetRField and SetRField commands.

You can use the script in the thread below to see what the record and field names for the Door PIO record need to be.

http://techboard.vectorworks.net/ubbthreads.php?ubb=showflat&Number=108487#Post108487


If you want to do all the doors in the file, it will be pretty easy. If you only want to do some doors, you will need to figure out a criteria to identify the ones you want. Maybe manually attach the custom record and then only process the doors with the custom record.

Ask again if you need more information.
_________________________
Pat Stanford

The PodCAD Podcast www.podcad.tv
New Episode Released 4-22-09
==============
Los Angeles VectorWorks Users Group lavectorworks@coviana.com
==============
Vectortasks Vectorworks Training www.vectortasks.com

Top

Vectorworks Community Links
Knowledgebase
Bug Submit
Tech Support Request
Downloads-Updates
Vectorworks Gallery
User Groups
Training Resources
Job Board
Services Directory
Plotting Services
BIM in Practice
April
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30
Forum Stats
16879 Members
36 Forums
41314 Topics
207096 Posts

Max Online: 200 @ 03/09/13 01:23 PM
Who's Online
1 registered (Benson Shaw), 0 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Newest Members
Alexpad, eu-genius, MBerton, begamaquinaria82, Michelle M
16879 Registered Users
Top Posters
Christiaan 6111
CipesDesign 4723
mike m oz 3894
JimW 3807
islandmon 3375