topic Re: Windows Schedules "double letter" how to indicate at the end? in Collaboration with other software

Window Schedules "double letter" how to sort to the end?

rob2218 — Wed, 17 Mar 2021 19:00:14 GMT

how do I get the 'double lettered' window tags to show up at the END of the list schedule?

Re: Windows Schedules "double letter" how to indicate at the end?

Barry Kelly — Thu, 18 Mar 2021 01:14:51 GMT

Try adding a space or underscore character (or maybe some other character) in front of the single letter.

It is the same with numbers
1,2,3,...9,10,11 needs to be 01,02,03,...09,10,11

Archicad simply orders based on the first character.

Barry.

Re: Windows Schedules "double letter" how to indicate at the end?

rob2218 — Fri, 19 Mar 2021 13:46:26 GMT

thanks Barry,
will give that a shot.

Re: Windows Schedules "double letter" how to indicate at the end?

rob2218 — Fri, 19 Mar 2021 13:52:33 GMT

ok Barry, I've tried to add a "period", a "space" an "aesterick" and nothing seems to push the double letters to the back. I'm stumped.

Re: Windows Schedules "double letter" how to indicate at the end?

Karl Ottenstein — Fri, 19 Mar 2021 18:21:16 GMT

rob2218 wrote:
ok Barry, I've tried to add a "period", a "space" an "aesterick" and nothing seems to push the double letters to the back. I'm stumped.

Just tested and a period or underscore (but not a space) in front of the single letters keeps them at the top, pushing the double letters to the bottom. Unfortunately, you have to look at the period or underscore in the schedule and any labels that contain the ID.

The other old, tried and true method is potentially error prone due to data entry error and changes and relies on manually entering a sorting code in an extra field of the library part. You use that sort code, perhaps combined with the ID, to sort the schedule, but change the column width so it doesn't show.

For your particular case ... single vs double (and maybe triple etc) letters ... the relatively new Property Expressions are the best solution. You get your cake (the ID's look the way you want everywhere with no funny extra symbols) and get to eat it too (the sorting is your way).

Will start a fresh post for the details - but the idea is you create a new property for openings - and the value of that property is the length, in characters, of the ID string: 1 for "A", 2 for "BB". Then, your schedule includes THAT new property as the first sort, and the ID is the second sort. Thus, all 1 character IDs will be grouped first, then 2 character IDs, etc.

Karl

Re: Windows Schedules "double letter" how to indicate at the end?

Karl Ottenstein — Fri, 19 Mar 2021 18:32:18 GMT

So, here's the solution for your specific case:

Open Property Manager and create a new property for elements of type Opening by clicking the "+" sign as shown below. I've called it ID_Length, but whatever. Very simple formula. After you click Expression, you can pull in the Element ID field name and from the list of available text expressions, find the LEN("text") function ... resulting in LEN(Element ID). Finally, make the property available to all Windows. (Maybe you want this with Doors too?)

In the schedule itself, you can now find the dynamic, calculated property that you just created (ID_Length) and add it to the schedule just prior to the ID field in the schedule. Sort ascending by that first... then the ID. Finally when you're happy with the result, shrink the column size for the Length field so that it doesn't display in the schedule.

Re: Window Schedules "double letter" how to sort to the end?

Laszlo Nagy — Fri, 19 Mar 2021 22:31:03 GMT

Just to add one thought to Karl's solution:
If you create this Schedule in a way that the "ID_Length" field is the first, then it will be at the left side (or top ) of the generated schedule.
Then, you can save a View of it and place that on a Layout as a Drawing.
Then, you can adjust the frame of the Drawing so the Schedule Column/Row showing the "ID_Length" field does not show.

Re: Window Schedules "double letter" how to sort to the end?

rob2218 — Sat, 20 Mar 2021 12:44:01 GMT

So...here's as far as I got?
I'm not sure how to go any further than here......

Re: Window Schedules "double letter" how to sort to the end?

rob2218 — Sat, 20 Mar 2021 12:50:03 GMT

Seems the "ID_Length" parameter is greyed out in my ability to add any numbers inside that field? I'm not sure what did wrong.

Re: Window Schedules "double letter" how to sort to the end?

rob2218 — Sat, 20 Mar 2021 12:57:42 GMT

here's where I'm getting stuck. Beyond this point...whenever I try to type LEN or anything...I get some sort of syntax or formula error.

Re: Window Schedules "double letter" how to sort to the end?

rob2218 — Sat, 20 Mar 2021 13:12:07 GMT

OK...so after a few trials...got it to work without having to type anything in the expressions field. Now...the thing is that I do NOT want the "ID Length" column to show up on my Window Schedule...I just want it to sort letters with single characters first, then letters with double characters second but.....actually "NOT" show the id field in column. How can I accomplish this?

Re: Window Schedules "double letter" how to sort to the end?

rob2218 — Sat, 20 Mar 2021 13:16:54 GMT

I guess as a quick sloppy fix...I could do this using "fills" as a masking tool in front of these fields?

Re: Window Schedules "double letter" how to sort to the end?

Laszlo Nagy — Sat, 20 Mar 2021 13:21:33 GMT

rob2218 wrote:
So...here's as far as I got?
I'm not sure how to go any further than here......

Karl's screenshot shows the exact expression you need to use for the "ID_Length" Property:

LEN( Element ID)

Currently, you define "ID_Length" to be equal to "ID_Length", which is itself, which of course cannot be evaluated as an expression. It has to be dependent on something else, and that something else is calculated by taking the "Element ID" text parameter of the element, and calculating its length (how many characters it is - this is what the "LEN" function does). The number of characters in the "Element ID" parameter is the value the "ID_Length" Property returns.

Re: Window Schedules "double letter" how to sort to the end?

Laszlo Nagy — Sat, 20 Mar 2021 13:25:45 GMT

rob2218 wrote:
I guess as a quick sloppy fix...I could do this using "fills" as a masking tool in front of these fields?

Rob, I answered that previously. Modify the frame of the placed Schedule on the Layout:

https://archicad-talk.graphisoft.com/viewtopic.php?f=34&t=72413#p323823

Re: Window Schedules "double letter" how to sort to the end?

rob2218 — Sat, 20 Mar 2021 14:59:24 GMT

I see....of course. Just grab the left side of the view window and stretch it (pull it over to the right) so's that you only see the NO. first....got it.
thanks.

Re: Window Schedules "double letter" how to sort to the end?

PEARLMAN — Wed, 15 Mar 2023 20:20:54 GMT

ALL:

There is a much easier way to get the AA, BB, CC...to the end of the schedule, All you have to do is enter the AA as "aa", i.e., not capital.