Collaborate forum
cancel
Showing results for 
Search instead for 
Did you mean: 

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

rob2218
Contributor
how do I get the 'double lettered' window tags to show up at the END of the list schedule?
...Bobby Hollywood live from...

i>u

Edgewater, FL!

SOFTWARE VERSION:

Archicad 22, Archicad 23

Windows7 -OS, MAC Maverick OS
1 ACCEPTED SOLUTION

Solution
Karl Ottenstein
Moderator
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.



One of the forum moderators   •   AC 25 USA and earlier   •   MacOS 11.6.1, iMac Pro

View solution in original post

14 REPLIES 14

Barry Kelly
Moderator
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.

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

rob2218
Contributor
thanks Barry,
will give that a shot.
...Bobby Hollywood live from...

i>u

Edgewater, FL!

SOFTWARE VERSION:

Archicad 22, Archicad 23

Windows7 -OS, MAC Maverick OS

rob2218
Contributor
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.
...Bobby Hollywood live from...

i>u

Edgewater, FL!

SOFTWARE VERSION:

Archicad 22, Archicad 23

Windows7 -OS, MAC Maverick OS

Karl Ottenstein
Moderator
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
One of the forum moderators   •   AC 25 USA and earlier   •   MacOS 11.6.1, iMac Pro

Solution
Karl Ottenstein
Moderator
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.



One of the forum moderators   •   AC 25 USA and earlier   •   MacOS 11.6.1, iMac Pro

View solution in original post

Laszlo Nagy
Community Admin
Community Admin
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.

....................................................................................................
Laszlo Nagy, Lead Moderator, Community Admin
Get Archicad Tips at https://twitter.com/laszlonagy
AMD Ryzen 1700X CPU, 48 GB RAM, NVidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), WIN10 PRO ENG, AC20-AC25
Loving Archicad since 1995

rob2218
Contributor
So...here's as far as I got?
I'm not sure how to go any further than here......
...Bobby Hollywood live from...

i>u

Edgewater, FL!

SOFTWARE VERSION:

Archicad 22, Archicad 23

Windows7 -OS, MAC Maverick OS

rob2218
Contributor
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.
...Bobby Hollywood live from...

i>u

Edgewater, FL!

SOFTWARE VERSION:

Archicad 22, Archicad 23

Windows7 -OS, MAC Maverick OS

rob2218
Contributor
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.
...Bobby Hollywood live from...

i>u

Edgewater, FL!

SOFTWARE VERSION:

Archicad 22, Archicad 23

Windows7 -OS, MAC Maverick OS

rob2218
Contributor
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?
...Bobby Hollywood live from...

i>u

Edgewater, FL!

SOFTWARE VERSION:

Archicad 22, Archicad 23

Windows7 -OS, MAC Maverick OS

rob2218
Contributor
I guess as a quick sloppy fix...I could do this using "fills" as a masking tool in front of these fields?
...Bobby Hollywood live from...

i>u

Edgewater, FL!

SOFTWARE VERSION:

Archicad 22, Archicad 23

Windows7 -OS, MAC Maverick OS

Laszlo Nagy
Community Admin
Community Admin
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.
....................................................................................................
Laszlo Nagy, Lead Moderator, Community Admin
Get Archicad Tips at https://twitter.com/laszlonagy
AMD Ryzen 1700X CPU, 48 GB RAM, NVidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), WIN10 PRO ENG, AC20-AC25
Loving Archicad since 1995

Laszlo Nagy
Community Admin
Community Admin
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
....................................................................................................
Laszlo Nagy, Lead Moderator, Community Admin
Get Archicad Tips at https://twitter.com/laszlonagy
AMD Ryzen 1700X CPU, 48 GB RAM, NVidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), WIN10 PRO ENG, AC20-AC25
Loving Archicad since 1995

rob2218
Contributor
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.
...Bobby Hollywood live from...

i>u

Edgewater, FL!

SOFTWARE VERSION:

Archicad 22, Archicad 23

Windows7 -OS, MAC Maverick OS

Still looking?

Browse more topics

Back to forum

See latest solutions

Accepted solutions

Start a new discussion!