Jump to content
Sign in to follow this  

Softgoods worksheet couting

Recommended Posts

I'll try to explain what I am looking to do.  I am trying to create a worksheet that will count my pipe and drape cross pipe, uprights, and drape counts, which after a bit of googling I can do on a basic level.


However, I have two sizes of pipe and drape, 12' and 16' high uprights.  I also have multiple types of drape, different colours of supervel and velour.  I am using the material, material colour, and note records in the Softgoods PIO Object Info to track the info.  The note record has either a 12' or 16' value.  Where I am running in to an issue is when I try to limit the database row in the worksheet to only target subdivisions.  Ex, I only want a drape panel count of 12' Black Velour.


But if I try to set multiple criteria I do not get the result I want.  If I try the following criteria on the database row:

Record>Soft Goods>is present

Field Value>Note>=12'

Field Value>Material Type>=Velour

Field Value>Material Color>=Black

instead of looking at only the objects that are all three, it returns all of the 12', all of the velour, and all of the Black pipe and drape.  Am I missing something in how Criteria works?  I'd like to be able to have multiple criteria that allows me to really narrow down on a selection.


Thanks :)

Share this post

Link to post

I think I found the solution.  After I edit the criteria the "formula" shows up in the formula bar, and I can change the | marks to ampersands, so I think my issues is solved.  I find it odd that in the edit criteria window I don't have the option of choosing how the criterias nest though.

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.

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.

Sign in to follow this  


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...