Jump to content
Bruce Kieffer

Worksheet Column of Part IDs? Is there a fill down function on some sort?

Recommended Posts

Is there some method to create an alphabetical column list of A, B, C, and so on in a worksheet? I did this in my worksheet (screenshot) using records, but that is tedious work. Can anyone suggest a possible simpler solution?

 

 

Screen Shot 2021-03-22 at 8.47.25 AM.png

Share this post


Link to post
1 hour ago, Hans-Olav said:

A workaround?

  • create excel file
  • fill down
  • import to VW
  • Copy Paste

OK, but not the solution I want.

 

I can create a separate worksheet in Vectorworks that shows the IDs and then butt it next to the cutting list worksheet, that works too, but again not the solution I want.

 

422030141_ScreenShot2021-03-22at10_11_20AM.thumb.png.0d58fc3bd4c02e0e925966580f5a8c89.png

Share this post


Link to post
Posted (edited)
3 minutes ago, Pat Stanford said:

Select a single cell and copy. Select a bunch of cells and Paste.

I don't follow what you are suggesting.

Edited by Bruce Kieffer

Share this post


Link to post

I deleted ti because I did not read your initial post closely enough.

 

The answer to your actual question, which is can I manually enter data into data base rows and have it stay fixed is NO.  ALL of the data in a database row MUST be associated with the object specified in that subrow.  You could attach a custom record and store the data there, but if you change the sort order of the database the custom record.field will sort with the objects.

 

The question I answered was the one you asked which is there an equivalent to Fill Down.  In worksheet rows in VW you can Copy a formula from one cell then select a range of cells and Past and it will act pretty much like Fill Down does in Excel.

  • Like 1

Share this post


Link to post

Interestingly I can attach my Part ID record to an object and define the ID and then go into the worksheet and changed the defined ID which changes it in the record ID too. That makes me think maybe I can drag and drop a "blank" or placeholder type record onto the drawing objects, and then type in the IDs into the worksheet. I'm going to play around with that a bit. (I see I need to spell Materials correctly!!!)

1426818039_ScreenShot2021-03-22at10_54_00AM.thumb.png.18618dee1e0641444bdcbc16c3a7573f.png

Share this post


Link to post

Yes that will work, but if you then resort the data, the manually typed in data will still be "stuck" to the object it was attached to, so it will not still be A, B, C, etc.

Share this post


Link to post
Posted (edited)

It works, and I understand that it may need to be redone if the sort order is changed, but even so, typing the changes in the worksheet column is infinitely faster than changing each object's record ID. Still not a fill down function, but it's much better than what I was doing.

1972842738_ScreenShot2021-03-22at11_31_54AM.thumb.png.7a01f594c3b1fc8675506f105134bb09.png

Edited by Bruce Kieffer
  • Like 1

Share this post


Link to post

Hi Bruce!

 

I do something like this all the time.  If you keep another worksheet with a column that is 

 

A

B

C

Z

 

You can select a range of those cells, copy, go back to the original worksheet with the database select exactly the same number of cells and paste.

 

If your objects are already in order it makes it very fast.  You can also accomplish minor reordering by changing something to C.5, C.6. etc. to get the correct order.  Then copy and paste again.

 

 

 

 

 

  • Like 1

Share this post


Link to post

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.


 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×
×
  • Create New...