Fixture Schedule: Multiple Instances, Different Rooms = Blank Fields

[Anonymous]

Case: I am creating a plumbing fixture schedule for a home with multiple guest bathrooms. The same toilet, faucet, etc. will be used in each of these bathrooms. I have tagged these items using Type Mark: WC-01, PF-04, etc.. 

Issue: the moment an item with the same type mark (PF-04 for example) appears in two different rooms, the Room and Room # fields go blank. Singular instances of an item, (one fancy powder room faucet),  have no problems and all fields populate as expected. Multiple instances of the same faucet in the same room (master bath double vanity) also have no issues – quantity shows 2, fields populate normally.

I have looked everywhere for a solution (apologies if this has been addressed - please link to thread), any help would be appreciated. 

Thanks!

[RDAOU]

@Anonymous 

That is because that same item is in multiple rooms and those multiple rooms have different names and different numbers so it is either blank or in 2022 it would read <varies>...Do the following:

• Open schedule
• GO to Sorting and Grouping
• make sure that the box Itemize every instance is checked

[lucdoucet_msdl]

@Anonymous 

---

Issue: the moment an item with the same type mark (PF-04 for example) appears in two different rooms, the Room and Room # fields go blank. Singular instances of an item, (one fancy powder room faucet),  have no problems and all fields populate as expected. Multiple instances of the same faucet in the same room (master bath double vanity) also have no issues – quantity shows 2, fields populate normally.

If your schedule has "itemize every instance" unchecked, each line will show the a summary of the the multiple instances which will have difference values for an instance parameter or in your case a room or room number. Since revit cannot reasonably show all the different values in the cell, it will blank out the cell.

In the exceptional case of all instances of a family are in the same room for the projet, revit should show the room name or number as there aren't any contradicting values.

Hope this helps,

-luc

[Anonymous]

Thanks for your reply! 

I had encountered this solution – forgot to mention it.

Unfortunately, this does not work because the schedule would become too long. For instance, 11 separate rows just for the repeated instances of toilets (yes, this project has 10 bathrooms). 

I am looking for a way to have the different room names populate in the same field, ideally separated by a comma & space. 

Any ideas?

[RDAOU]

@Anonymous 

In Revit there is no built in option to transpose Columns/Rows therefore you cannot combine the values of the cells in the same field/column (in this case rooms)

1. You either have to do it manually by typing in All the rooms in one parameter
2. OR use Dynamo to extract the list of rooms in which each type of fixture is placed in >>> combine in a string and set that value to a parameter in the Plumbing Fixture

[lucdoucet_msdl]

@Anonymous 

---

I am looking for a way to have the different room names populate in the same field, ideally separated by a comma & space. 

Having more than one value in a revit schedule cell is not currently possible in the OOTB software.

I would question why you would want to have a list of all rooms a plumbing fixture can be found in the way you describe. If you take and example project with 100 rooms having the plumbing fixture in question and apply your solution, that one cell will be enormous!

When scheduling equipment, one often would like to report the location parameters (such as linked project file, level, room) and the technical parameters (dimensions, specifications, options and/or other instance values). I typically will have the location parameters as a sorting parameter with the name appearing in subtitles then the technical parameters in columns.

For example: Sort your plumbing fixtures by level then by room. Hide the columns for level and room but include them in sub-totals. Then for each room you will have a listing of the equipment within.

Also consider having two schedules, one giving quantities by level (useful for quantity take-offs) and the other by room (useful for construction management and sign-off for client/owner).

To help you further, it would be useful for you to give us a list of all the columns and subtotals your schedule require.

-luc