Separate worksheets for separate areas?

[Ramon PG]

I am working on a building furniture layout that has four distinct departments. Can I make a space worksheet for each department? Maybe have the worksheet report separately on each design layer? I know I can give each space a prefix, but I am trying not to yet. Thanks.

[Pat Stanford]

Several ways to do this but all involve Criteria for the database.

 

You can use Layer as a criteria and specify only objects on a specific (or multiple) layers.

You can use Class as a criteria and specify only object in a specific (or multiple) layers.

 

You could also draw a polygon around the different spaces and give it a name in the OIP. You can then use a LOC (Location) criteria to force the database to only report on objects that are "contained" (surrounded) by the named object. But that operates across Layers, so if you had objects on a different (possibly not visible) layer, they could be shown in the database.

 

So you might need to use a combination of all three types of criteria to get what you need.

 

Ask again if you need more help.

[Ramon PG]

1 hour ago, Pat Stanford said:

Several ways to do this but all involve Criteria for the database.

 

You can use Layer as a criteria and specify only objects on a specific (or multiple) layers.

You can use Class as a criteria and specify only object in a specific (or multiple) layers.

 

You could also draw a polygon around the different spaces and give it a name in the OIP. You can then use a LOC (Location) criteria to force the database to only report on objects that are "contained" (surrounded) by the named object. But that operates across Layers, so if you had objects on a different (possibly not visible) layer, they could be shown in the database.

 

So you might need to use a combination of all three types of criteria to get what you need.

 

Ask again if you need more help.

 

Thanks for the super fast answer. I'll need some time to digest it and do some testing. Not sure I've used criteria before for Worksheets, but layer criteria sounds the easiest. Do I add it to the formulas?

 

Edited September 9, 2022 by Ramon PG

[Pat Stanford]

Right Click on the Database Header Row header (3 in your image above).  Choose Edit Criteria. It will let you specify exactly what objects should be included in the database.

 

 

[Ramon PG]

Pat,

 

It worked perfectly, but then I changed the layer name and completely lost the reference. It would by nicer if a simple layer name change would not do that.

 

[Pat Stanford]

What do you mean "lost the reference"?   I don't understand.

[michaelk]

I think he's talking about changing the name of a layer that is also a criterion in a database.

 

If you have a Criteria for a database that includes L='Old Layer Name'

 

and then change the name of the layer to 'New Layer Name' in Organization, then the Criteria for the database will still have 'Old Layer Name' and the number of objects that meet the criteria will be 0.

 

I think that's what @Ramon PG was talking about.

[Ramon PG]

On 9/25/2022 at 5:59 PM, Pat Stanford said:

What do you mean "lost the reference"?   I don't understand.

 

Can I have a column with just one of the three names I used in the Custom Occupant Organization (of the Space Object Info)? I cant find the settings for it.

Edited November 3, 2022 by Ramon PG

[Pat Stanford]

As part of the Database Criteria, it should be

 

Field Value   Custom Occupant Organization (of Space Object info) IS and then the name you are looking for. 

 

That should return only the spaces that have that occupant.

 

The Field name is actually a pulldown, so it should be relatively easy to find once you find Space Object Info in the list.

[Ramon PG]

20 minutes ago, Pat Stanford said:

As part of the Database Criteria, it should be

 

Field Value   Custom Occupant Organization (of Space Object info) IS and then the name you are looking for. 

 

That should return only the spaces that have that occupant.

 

The Field name is actually a pulldown, so it should be relatively easy to find once you find Space Object Info in the list.

 

I'm getting zero items. What should I chose in this field?

 

I seem to have two kinds of Spaces. One does not have the Custom Occupant Organization field.

 

Edited November 3, 2022 by Ramon PG

[Pat Stanford]

The green field should be the name of the field in the Space Object Info record that you are using for the Occupant Organization.

 

The pulldown shows every field of every PIO in the document, so you probably want to use the disclosure "triangles" on the left edge to close all of the PIOs except for the Space Object Info. Then pick the correct field from the field options shown.

[Ramon PG]

2 hours ago, Pat Stanford said:

The green field should be the name of the field in the Space Object Info record that you are using for the Occupant Organization.

 

The pulldown shows every field of every PIO in the document, so you probably want to use the disclosure "triangles" on the left edge to close all of the PIOs except for the Space Object Info. Then pick the correct field from the field options shown.

 

It doesn't work with Custom Occupant Organization is chosen in the criteria, no items appear in the Worksheet.

 

When I select Occup. Organization in all the Spaces, the Worksheet will work.

 

 

Thanks, always!!

 

 

 

 

 

 

Edited November 3, 2022 by Ramon PG