topic Re: How do I properly sort this door schedule? in Project data & BIM

How do I properly sort this door schedule?

Brad Elliott — Tue, 28 Jan 2025 15:36:55 GMT

Please see the attached door schedule & settings. I would really like A to come before B in this schedule and have been unable to do it. If you have a way please let me know.

Re: How do I properly sort this door schedule?

Brad Elliott — Fri, 29 Jun 2007 01:03:44 GMT

And the settings.

By the way, if someone can explain how to do two attachments or have the images show on the page I would appreciate it. I previewed the submittal and used the additional choose file window but it would not load anything.

Re: How do I properly sort this door schedule?

Karl Ottenstein — Fri, 29 Jun 2007 03:18:47 GMT

Brad wrote:
Please see the attached door schedule & settings. I would really like A to come before B in this schedule and have been unable to do it. If you have a way please let me know.

Hi Brad,

In your settings shot, it shows that you only have sorting enabled for the zone number field/column. if you want all 'A' ID values to appear first, simply click the sort flag for the ID in the Schedule Fields box so that it has a down arrow (descending) similar to that shown for the zone number.

By the way, you can also change the Zone Name header so that it displays "Room" as the column header even though it is still reading the zone name content... Similarly, I suspect what you are using the ID for is the unit in a duplex, so you might change the column heading for the A/B.... (An alternate if you decide to display markers and schedules that identify each window/door either uniquely or by size/type is to use the ID field for the door/window ID in that scheme, and use another User Defined field to specify the A/B unit...)

Cheers,
Karl

PS This post belonged in the Schedules and Data Extraction forum...but I understand the confusion as to where to ask...

Re: How do I properly sort this door schedule?

Brad Elliott — Fri, 29 Jun 2007 16:48:21 GMT

Karl,
Thanks for the response. That doesn't quite get me where I need to be. The doors are to the same room (by the way thanks for the Zone Name catch I missed that when I set it up). So if when I have 3 doors in the Master Bath there will be doors A, B & C Rm#112.

So I don't want ALL the A values to appear first I just want them to appear in order at each room. If you look at the schedule you will see that it sorts by Room # first which is good but then by Door width next which is bad. I want it to sort by ID letter next instead. Hope this makes more sense.

And yes you are right this should be in the schedules. I just came to Documentation out of habit.

Re: How do I properly sort this door schedule?

Karl Ottenstein — Fri, 29 Jun 2007 18:22:44 GMT

The sorting is left to right (as viewed), top down (as seen in field list).

So, if you want doors grouped by room, you need to place the room number first (drag it up to the top of the list), then ID.

Since you already have the 'flag' set for room number, that means that the room number will not be repeated on each row, as doors A, B, and C are listed...but only on the line with the first door (A). If you want it on every line, then clear the title flag (looks like a flag in your setting screenshot).

There is no way to have them sorted the way you want and yet to have the door ID appear first.

Cheers,
Karl

Re: How do I properly sort this door schedule?

Brad Elliott — Fri, 29 Jun 2007 18:36:07 GMT

I was afraid that was the case. Another 20 year old way of doing things getting changed for ArchiCAD.

But now that I change the Room Name & Number to the front and sort the doors in the next column it seems to make it easier to find a specific door so maybe that isn't so bad after all.

Thanks Karl

Re: How do I properly sort this door schedule?

Karl Ottenstein — Fri, 29 Jun 2007 21:25:29 GMT

You're welcome.