Jump to content

Pulling Data from Title Block Borders into Worksheets


Recommended Posts

Ever since Title Blocks were revamped a couple years ago, I've been unable to create a simple Drawing Schedule (list of sheets) as a worksheet that's linked to my Sheet Layers / Title Blocks. It used to be as simple as pulling record fields from the Title Blocks, but that doesn't seem to work anymore, so I'm obviously missing something.

 

Note that I DO NOT want to use Tools < Reports < Create Sheet List, as this creates an unlinked worksheet (an idea with I completely loathe). In my workflow I constantly re-name and re-number sheets throughout a project, so I need a worksheet that is always up to date without having to manually do anything.

 

I see that it's possible to pull some data from TBBs, as seen in the screenshot of my test below:

TBBdata.thumb.jpg.e278c2c1da8ba471f08de01e348de225.jpg

 

All I really need is 'Sheet Data'.'Sheet Title' but that doesn't seem to work?

 

For my first column I just used =L in the column header which works fine to pull the sheet layer number.

 

Here's an image of my simple goal, which I had in VW2017:

359123684_ScreenShot2019-09-12at4_53_15PM.thumb.png.de1158f065ee329d0f7fbe5316970b29.png

 

 

 

@Nikolay Zhelyazkov @Pat Stanford

 

 

  • Like 1
Link to comment
  • 2 months later...

BTW I don't personally use this method to select which sheets go in the drawing list as I like to leave all Title Blocks active. (Deactivating them also turns of auto-drawing configuration.

 

Instead I have added a custom field to the already extg vw Sheet Data record. It is a boolean field called "Include in Drawing List. I have a text object hidden in my titleblock border which is linked to this field. Linking the record to text in the TBB means this record will appear as a setting in my TBB settings dialogue.

 

image.thumb.png.5ec89ccf2717ded6e610429646dcde3e.png

 

Here's a thread that describes how I did it if you are interested.

 

 

Link to comment
  • 1 month later...

Take a look at my post just about Andy's.  Yes you create a worksheet with a Database row with a Criteria of Type is Title Block. Then you should be able to use the pull downs to select the Record and Field. It will display as Sheet Data in the pull down, but will generate a formula something like:  ='Title Block Sheet Data'.'Sheet Number'

 

Ask again if you need more specifics.

Link to comment
  • 4 weeks later...

@Nikolay Zhelyazkov @Pat Stanford 

 

I´m trying to include a column in my drawing schedule to report the drawing stamp

='Title Block Border'.'Display Drawing Stamp'

I only manage to display true or false 

I want to report my custom drawing stamp text 

 

='Title Block Border'.'Custom Text'

gives me my custom text in every row, not the ones that actually have a drawing stamp.

 

What am I doing wrong or do you think this is a bug?

 

 

 VW.thumb.png.85d931223e9e0c83dd1b4c352c0d188d.png

Link to comment
  • Vectorworks, Inc Employee

Hello @Hans-Olav,

 

The Custom Text param is not cleared when you are not using Drawing Stamp. In order to get the custom text for objects using the Drawing Stamp only try using the IF formula like this:

 

=IF( 'Title Block Border'.'Display Drawing Stamp'; 'Title Block Border'.'Custom Text'; '' )

 

Best Regards,

Nikolay Zhelyazkov

  • Love 1
Link to comment

Display Drawing Stamp is a boolean field (True or False) that tells the PIO to use the drawing stamp or not. That is why you are only getting True or False. Custom Text is the actual text of the stamp.

 

If you use the stamp on all of your title blocks, then you can skip the IF and just use ='Title Block Border'.'Custom Text'

 

Also for reference purposes, the delimiter used in the formulas is language/country dependent.  Since Hans-Olaf and Nickoly are both in Europe (I am assuming) the separator is a semi-colon [ ; ].  In the US the separator is a comma [ , ].

  • Like 2
Link to comment
  • 1 year later...

I too am trying to add a Drawing Index to my cover sheet, which I'd like to automate from data VW already has stored somewhere... I have sheet name and sheet number already linking to text in my Title Block... I want simply to have ALL sheet names and numbers appear as a list in a section I'm titling Drawing Index. I've created a text box within the Edit Title Block Layout interface (click on Title Block > 'Edit Style' from dropdown in Obj Info Palette), and when I go down to Data Type > Link Value: there is no option for sheet name.list or something that looks like it would work. There is a custom config option, but I can't puzzle my way through the interface. I'm looking for tutorials on this but can't find something for this specific task.

 

Like Andy, I don't like the idea of having an external document to reference, since I'd want the list and sheet names to update as I inserted new ones or changed the names of them.

 

Your detail above—and throughout this forum—is great, Pat, and very helpful, thanks.

 

I'm running VW2019 SP6 (Fundamentals, Spotlight, Renderworks) on a mac OS 10.15.7 if that helps. 

 

Thank you,

 

Bill Swartz

Link to comment

OK, I found a Drawing List worksheet in VW Libraries > Reports_Schedules, and I'm able to put it in the title block area. It comes in looking like an image, so I had to open the worksheet and format the cells so the layout, font and alignment kind of work. But I can't see how to link it as text, which I feel might be cleaner. This works for now though, since there appears to be a toggle defaulted ON to autoupdate.

Link to comment
On 4/22/2021 at 1:41 PM, Bill Swartz said:

OK, I found a Drawing List worksheet in VW Libraries > Reports_Schedules, and I'm able to put it in the title block area. It comes in looking like an image, so I had to open the worksheet and format the cells so the layout, font and alignment kind of work. But I can't see how to link it as text, which I feel might be cleaner. This works for now though, since there appears to be a toggle defaulted ON to autoupdate.

 

Try downloading the worksheet from the third post in this thread, then put the worksheet into your TBB.

(The built in Drawing List worksheet is useless)

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...