Electric Schedule - Exterior Room

[robdyck]

In an electrical schedule, (or any other for that matter), is there a way to get a room name attribute to show up in the schedule for items place on the exterior of the house?

Right now, when I include the Room Name column, items on the exterior have a blank space in that column. I'd like that to fill in as 'Exterior'...without going to text of course.

[robdyck]

25 minutes ago, solver said:

You can do it with a macro using a Custom Field.

 

Good idea. That's pretty quick...I already have a Custom field for My Room Names. And it's easy to select all the electrical items on the exterior using the Match Properties tool. Then I'll manually enter 'Exterior' for those items in that field...the rest will be automatic.

Is there  a simpler way than that?

[DzinEye]

3 minutes ago, robdyck said:

Is there  a simpler way than that?

Note at top of schedule that says "blank room name = 'exterior'  "  

[robdyck]

1 minute ago, DzinEye said:

Note at top of schedule that says "blank room name = 'exterior'  "  

Interestingly enough, if the room name is the first field, then it organizes them alphabetically and all the blanks are first, so that's a really easy way to add it in with text.

[robdyck]

Do I dare even start with a legend calling out my own deficiencies?

[Alaskan_Son]

44 minutes ago, robdyck said:

Is there  a simpler way than that?

Yes.  Using a custom macro.  In this particular case, a simple ternary operator should suffice.  Something like this...

 

room == nil ? "Exterior" : room.name

[DzinEye]

2 hours ago, robdyck said:

Do I dare even start with a legend calling out my own deficiencies?

I know I wouldn't !
Michaels 'ternary operator' looks simple enough.... or you could fall back on my 'smooth operator' suggestion.