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]

  On 2/12/2021 at 4:52 PM, solver said:

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

 

Expand  

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]

  On 2/12/2021 at 5:29 PM, robdyck said:

Is there  a simpler way than that?

Expand  

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

[robdyck]

  On 2/12/2021 at 5:34 PM, DzinEye said:

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

Expand  

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]

  On 2/12/2021 at 5:29 PM, robdyck said:

Is there  a simpler way than that?

Expand  

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

 

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

[DzinEye]

  On 2/12/2021 at 5:37 PM, robdyck said:

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

Expand  

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