Document & Visualize forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Enlisting Rooms in a single cell in a Schedule

JCCARLOS91
Booster

Hi,

 

I'm doing a window and door schedule. In some cases, a single door type is used in different rooms and in my schedule I have to show room names to which the each door type is applied. I'm trying to add "Related Room Name" as a field in the schedule but this then differentiates the doors and lists them into to separate doors. I'd like to be able to keep that one door type into one column and the Related Room Names to be enlisted within one cell. So far, my work around is to just type in the rooms in a Custom Text Field. Please see attached.

 

Thanks in advance!

 

Screen Shot 2022-01-26 at 3.21.33 PM.png

John Carlos
AC25 | iMac 2019
1 ACCEPTED SOLUTION

Solution
Barry Kelly
Moderator

In version 25 there is a new option to merge cells in a schedule.

Add the 'Related Room Name' field and then make sure that you tick the box to 'Merge Items'.

Now in your column or row headings (depends how you have set your schedule up) the will be a 'Merge Options' button.

If you select 'Uniform or various' then the unique items in that row/column will be ignored and will simply list all the values in one field.

If you want you can add a count for the number of items as well.

 

BarryKelly_0-1643269834122.png

 

Barry.

 


One of the forum moderators.
Versions 6.5 to 25
Dell XPS- i7-6700 @ 3.4Ghz, 16GB ram, GeForce GTX 960 (2GB), Windows 10
Dell Precision 3510 - i7 6820HQ @ 2.70GHz, 16GB RAM, AMD FirePro W5130M, Windows 10

View solution in original post

4 REPLIES 4

Rajesh Patil
Advocate

Try to use Zones to each room and later in schedule use the Flag option for Zone field in listing

Zone Flag.png

Rajesh Patil
AC 09-25 | INT | WIN11 64
Dell Inspiron 7591, Core i9, 9880H 2.30GHz, 16.0GB, NVidia GeForce GTX1650, 4.0GB, SSD Internal 500GB, Dell SSD External 250GB

Hi Rajesh,

 

Thank for the response. One request, can you show me the end result? I tried creating the schedule as per your setting but it didn't combined the Zone Names.

John Carlos
AC25 | iMac 2019

Solution
Barry Kelly
Moderator

In version 25 there is a new option to merge cells in a schedule.

Add the 'Related Room Name' field and then make sure that you tick the box to 'Merge Items'.

Now in your column or row headings (depends how you have set your schedule up) the will be a 'Merge Options' button.

If you select 'Uniform or various' then the unique items in that row/column will be ignored and will simply list all the values in one field.

If you want you can add a count for the number of items as well.

 

BarryKelly_0-1643269834122.png

 

Barry.

 


One of the forum moderators.
Versions 6.5 to 25
Dell XPS- i7-6700 @ 3.4Ghz, 16GB ram, GeForce GTX 960 (2GB), Windows 10
Dell Precision 3510 - i7 6820HQ @ 2.70GHz, 16GB RAM, AMD FirePro W5130M, Windows 10

You're a life saver!!

 

Thanks, Barry!!

John Carlos
AC25 | iMac 2019

Start a new conversation!

Labels

Still looking?

Browse more topics

Back to forum

See latest solutions

Accepted solutions

Start a new discussion!