Jump to content
  • 1
lgoodkind

Worksheet criteria field value selection menu

Question

Is this supposed to be this way?  When we want to edit the worksheet criteria -> Field Value -> X = " "  We have to scroll through a thousand items in the hope that we might find what we are looking for?  If I want to add Plant Type to the Field value there is currently no way for me to find in in this list as it is simply too long.  Am I missing something here?  Is there a better way to do this? 

WTF.PNG

Share this post


Link to post

5 answers to this question

Recommended Posts

  • 0

That is the way the Criteria Builder works.

 

You can alternatively click into the formula bar and manually edit the criteria and type in whatever you need. But you will have to be exact in what you type.

Share this post


Link to post
  • 0

I have been wondering the same as @lgoodkind. There is a dire need for usability improvement here. Something like in the report creation window is much needed at the Criteria Builder, please see attached.

 

We have numerous and rather long custom records, these mixed and added to the stock ones are quite a task to navigate by scrolling.

 

 

004 Record selection.PNG

Edited by JMR

Share this post


Link to post
  • 0

Pat thanks for your reply but we are not referring to the database row criteria but the other menu when you select the left database column.  You cann't type what you want there the only option is to use the drop down menu and scroll throuhg 1000+ items

Share this post


Link to post
  • 0

You can still do what I suggested, you just have to know the Field Name you are want.

 

Right Click on the Database (i.e. 3, not 3.1, etc) and choose Edit Criteria.  Click Cancel. In the Formula Bar you will now have a text representation of the Criteria for the database.

 

Click into the Formula Bar and find the 'Record'.'Field' portion of the criteria and edit those values to be what you want. Hit Return to lock in the edited criteria.

 

I THINK that as long as what you edit them to is something the criteria builder can display you can still edit the criteria the next time using the Criteria Builder dialog box. I know it is possible to create criteria that are valid for a worksheet that can't be edited with the criteria builder, but I think these are mostly cases of adding extra ANDs and ORs to the criteria.

 

I am not saying there there should not be improvements in the Criteria Builder, just trying to offer a workaround until the functionality improves

Share this post


Link to post
  • 0

That cancel tip is a good one, thanks Pat!

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

 

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.

×