Wall opening data in worksheet

[koenr]

Hello,

 

Is there a way to get de name of the wall where my door is inserted into a worksheet?

In the example below my opening should return "BW0.1" so i can easily count the openings in all concrete walls.

 

If not posible with a normal function i am a bit familiar with worksheetfunctions so that could maybe be an solution but this makes the worksheets realy slow so i try to avoid them as much as possible. 

Thanks a lot! 😄 

[michaelk]

Here's one way:

 

You can get the wall into a worksheet with a simple script.  Import the script palette in this file into your file.  Use the database call =RUNSCRIPT('Get Wall Name')

 

You will get a warning that a worksheet script is trying to run.  Always allow.

Wall Name in Worksheet.vwx

[koenr]

Thanks a lot this works perfectly!
Such a simple script 😄 

[michaelk]

It could be even simpler!

 

I find it less readable this way but you could make this literally a 1 liner:

 

WSScript_SetResStr(GetName(GetParent(WSScript_GetObject)));

 

 

[Matt Panzer]

This may help as well.  The worksheets in the file (in the linked post) use an embedded script to return the name of the parent wall style.

 

 

[koenr]

Hello,
I'm back with another question.

I'm almost there but there is only 1 problem left.
I select the opening and run this simple script but instead of naming the opening it names the wall it is in.

This was just for testing what was going wrong but the idea is that i can read some values out off the wall and write those to a record attached to the opening.

[Pat Stanford]

Take a look at GetPickObjectInfo.  Use the opening name to get the location and pass that to GetPickObjectInfo to get a handle to the wall and the sub-object.

 

If you add GetType to your code above, I would bet there Opening is actually the wall and the GetParent is rerunning the group or Layer the wall is in.  If the OIP says that a Door in Wall (or anything In Wall) is selected, then it is actually the Wall that is selected.

[Vectorworks drafter Shiv]

Hi Pat,

 

 

Edited October 16, 2023 by Vectorworks drafter Shiv