topic Enlisting Rooms in a single cell in a Schedule in Documentation

Enlisting Rooms in a single cell in a Schedule

JCCARLOS91 — Wed, 26 Jan 2022 11:23:23 GMT

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!

Re: Enlisting Rooms in a single cell in a Schedule

Rajesh Patil — Wed, 26 Jan 2022 14:14:38 GMT

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

Re: Enlisting Rooms in a single cell in a Schedule

JCCARLOS91 — Thu, 27 Jan 2022 05:13:55 GMT

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.

Re: Enlisting Rooms in a single cell in a Schedule

Barry Kelly — Thu, 27 Jan 2022 07:52:26 GMT

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.

Barry.

Re: Enlisting Rooms in a single cell in a Schedule

JCCARLOS91 — Thu, 27 Jan 2022 08:16:07 GMT

You're a life saver!!

Thanks, Barry!!