• Home
  • Training Books
  • Subscribe to Our Email Newsletter
  • About
    • Contributors
    • Feedback
    • Contact
    • Privacy policy
    • Cookie Policy

CADnotes

CAD Tutorials and Best Practices for professionals and students

  • Featured
  • AutoCAD
    • AutoLISP
  • Revit
    • Revit Architecture Basic
    • Revit MEP Basic Tutorial
  • Inventor
  • MicroStation
    • MicroStation Basic Tutorial
  • CADnotes on YouTube
You are here: Home / Revit / Revit Schedule: Using conditional IF in custom field

Revit Schedule: Using conditional IF in custom field

January 14, 2011 by Edwin Prakoso 2 Comments

In this Article...

  • Assumption
  • Renaming header
  • Add Custom Field
  • Add Description Field

Have you ever examined Revit door schedule, and the door width field? If you see the double door family, you will see that the reported schedule is not the actual door width, but it is the total opening width.

Opening_Width

In this case, I want to report the actual door width. And the total opening width. There are several workaround to do this, in the family level or simply add custom field in the schedule.

I have posted a tutorial about custom field before, for similar problem with unit cost. Read the Revit Schedule custom field here.

Assumption

This post will use the later one. It may not be suitable in all condition, but it is the easiest. There are some assumption we make here:

  1. We assume that single door has maximum width of 3’. More than that, we will assume it will be double door.
  2. The door width are equal.

Renaming header

As I mentioned before, the width reported by Revit currently is total width. So I will rename the header. Open your schedule view, and click edit right next to formatting property.

schedule_formatting

In schedule properties, formatting tab, find width field. If you can’t find it, you have to add it in fields tab first. Rename the heading to total width.

Rename_header

Add Custom Field

Now go to Fields tab. Click calculated value.

calculated_value

In opened dialog box, input these following data:

  1. Name: door width.
  2. Field Type: formula.
  3. Discipline: common.
  4. Data Type: Length.
  5. Formula: if(not(Width > 3′), Width, Width / 2)
    *field name is case sensitive!

Single_Door_Width

In formula, we use conditional if. We tell Revit to use Width if the door width is less than 3’. Remember that we assume if the width is 3’ or less, then it is a single door. If the condition is not met (more than 3’), we tell Revit to use Width/2.

Add Description Field

The custom field should work. But I want to add more description or comment to tell people who read the schedule what kind of door they are.

Like what we did previously, I add one more custom field:

  1. Name: door description.
  2. Field Type: formula.
  3. Discipline: common.
  4. Data Type: Text.
  5. Formula: if(not(Width > 3′), “Single”, “Pair”)

Now I have my schedule like this:

door_data

Now I know each door width, total width, and show description of the door using IF conditional.

Conditional IF can be very useful. I was trying to use family type for conditional. If the door name contains “single” then I will use it in my conditional statement. But I can’t find how to do it, or use wildcard in formula. If you know how to do it, please share it here.

I will try to write how solve this problem by editing the family and report it in door schedule.

Are you using custom fields in your schedule? What data is using custom fields the most?

About Edwin Prakoso

I work as a Solution Consultant in Datech Solutions, Tech Data Indonesia. I've been using AutoCAD since R14 and Revit since Revit Building 9. I occasionally write for AUGIWorld magazine and I am also active in Autodesk discussion forum. I'm a member of Autodesk Expert Elite, an appreciation for individuals who give contributions to the Autodesk community.
Connect with me on twitter or LinkedIn. If you want to have my new articles sent to your email inbox, you can subscribe to the newsletter.

Filed Under: Revit Tagged With: calculated value, custom fields, revit schedule

0 0 votes
Article Rating
Subscribe
Login
Notify of
guest

guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

2 Comments
Inline Feedbacks
View all comments
Ibu
Ibu
10 years ago

Thank you… It was very useful for me to create schedule for the number of bricks used and their unit cost for different wall with different types of brick material…

0
Reply
Tamdethai
Tamdethai
11 years ago

"In formula, we use conditional if. We tell Revit to use Width if the
door width is less than 3’. Remember that we assume if the width is 3’
or less, then it is a single door. If the condition is not met (more
than 3’), we tell Revit to use Width/2."
That's right only on the schedule, but there's still a double door on the plan ( in the project ) ?

0
Reply
wpdiscuz   wpDiscuz
Join Our Free Email Newsletter
  Thank you for Signing Up
Please correct the marked field(s) below.
1,true,6,Contact Email,2 1,false,1,First Name,2 1,false,1,Last Name,2

Featured

Sharing files and designs with Autodesk 360

If you have Autodesk account, you can have free 5GB online storage. You can use it to share large files or provide 3D viewers. You can showcase your design on your company website or your personal portfolio!

Recent Articles

  • Revit 2024.1 Update is Released
  • What’s New in Revit 2024: Bending Detail
  • What’s New in Revit 2024: The Dark Theme

Advertisement

New on CADnotes

  • Revit 2024.1 Update is Released
  • What’s New in Revit 2024: Bending Detail
  • What’s New in Revit 2024: The Dark Theme
  • Autodesk Build: Using Assets for Progress Tracking
  • My Home on the ACC Unified Platform

Meet the Authors

avatar for
avatar for
avatar for
avatar for
avatar for
avatar for

Get Connected

CADnotes on FacebookCADnotes on InstagramCADnotes on TwitterCADnotes on YouTube

© 2009 – 2023 CADnotes · Feedback · Privacy Policy · Become an affiliate

wpDiscuz