Revit Schedule Boolean Yes/No

Revit Schedule Boolean Yes/No

Shared parameters are great for adding information to families that Revit simply does not contain. Consider a window manufacturer or supplier that either has or does not have items in stock. How does one schedule items that are available, and what if one wants to schedule items that are not available?

I created a shared parameter called availability under the grouping of Product Information. This allows me to use the parameter across a wide range of categories (Doors, Windows, Furniture, etc.).  As always, please manage your shared parameters carefully so that no duplicates come into being: http://www.mgfx.co.za/revit-shared-parameter-file-management/.

Next I insert the shared parameter into the applicable family as a type parameter.

1-300x146 Revit Schedule Boolean Yes/No

Then set the values for the shared type parameter accordingly.

2-300x195 Revit Schedule Boolean Yes/No

When this family is loaded into the project, the parameter automatically becomes available for scheduling.

3-300x294 Revit Schedule Boolean Yes/No

As can be seen the cells where the Yes/No parameter is “not checked” displays as empty instead of displaying “No”

4-300x72 Revit Schedule Boolean Yes/No

Scheduling items that are available is easy as the logical statement holds: “Is equal to yes”. In the Filter properties of the Schedule, create this logical statement as shown below:

5-300x76 Revit Schedule Boolean Yes/No

None of the blank fields are shown:

6-300x111 Revit Schedule Boolean Yes/No

However the inverse does not compute as the field is left blank.

7-300x72 Revit Schedule Boolean Yes/No

Resulting in an empty schedule:

8-300x53 Revit Schedule Boolean Yes/No

Instead use one of the following logical conditions:

“Does not equal yes“

9-300x69 Revit Schedule Boolean Yes/No

“Is less than no”

10-300x75 Revit Schedule Boolean Yes/No

Both of these statements return the desired result:

11-300x109 Revit Schedule Boolean Yes/No

It is possible to place a conditional format on the filed containing “Yes”.

12-300x105 Revit Schedule Boolean Yes/No

Resulting in

13-300x91 Revit Schedule Boolean Yes/No

However, there is no way to place conditional formatting on “No”.

14-300x113 Revit Schedule Boolean Yes/No

Or

15-300x112 Revit Schedule Boolean Yes/No

Resulting in:

16-300x105 Revit Schedule Boolean Yes/No

If you would like to be able to add conditional formatting to a “No” value on a Yes/No parameter in a Revit schedule in the future, please vote for the idea here: http://forums.autodesk.com/t5/revit-ideas/conditional-format-for-quot-no-quot-on-yes-no-parameter-on/idi-p/6848251

Alternatively, as a workaround, a dummy parameter can be used to populate a text parameter explicitly with either “Yes” or “No”. In this case, as the parameter will always have a value attached, the schedule would be able to conditionally format No. the topic is covered here: http://revitclinic.typepad.com/my_weblog/2010/04/modifying-a-yesno-parameter-appearance-in-schedules.html

By |2017-10-18T10:57:50+00:00February 2nd, 2017|

About the Author:

After concurrently manufacturing for the Radar EW industry and reading incompletely toward Mechanical Engineering at Stellenbosch University, I realigned toward the Architectural. Today I support the AEC professions in Cape Town as an Application Engineer for a Gold Autodesk Reseller in South Africa called Micrographics. I support and facilitate training on the following software platforms: Revit (Architectural, Structural and MEP); Civil3D; AutoCAD; SANSCalc and Lumion.