stefano777777

Thanks Hyppothamus! I had to switch the handle for setrfield! Everything else worked already. I wrote some indicative criteria as I felt I could refine them once the script was working. I will try to add some IF in order to assign different field for different classes of the space. One for the GIA and one for the amenity. Thanks Again for your help. PS My IT provided a different version of the script as follow...

Thanks Pat and Hippothamus, I'm not trying to schedule rooms here. I'm working on a project with 3 blocks some 15 cores, 2 towers, some 800 flats from about 100 types. Eventually I might want to list the rooms (by flat type not for the entire project obviously) and create marketing schedules but for the moment I'm just dealing with some planning schedule. The flat symbols exist already and the have a space for the flat area and a space for the external amenity space... I've done some work on the script but it doesn't quite work, I think there might be more than 1 problem. I tried to follow your suggestions and had a look at other examples and the function reference, but as I said I'm not really good at code... I've been able to set record field with a variation of what follows, but i'm probably doing something wrong with my variables here. I tried changing the variable type for the flat area and thought I might have to use num2string or concat but I'm confused on the matter A stripped down file with 1 symbol example, the script and a schedule is attached (VW2014) Any help would be super welcome!

OK I found the error, it should be =IF(('MyRecord'.'No1'='1'), '1','0')

Is there a way to have the result of a boolean to display 0 or 1 rather than false or true? the formula i'm using is =('MyRecord'.'No1'='1') This return true if the record field is 1 or false if any other number. I tried with =IF(('MyRecord'.'No1'='1'), ‘1’,'No1')

Is there a way to isolate the area by class?I thought I could get areas for a specific class with =AREA(C='ClassName') but this returns a Boolean. I also tried =IF((C='ClassName'), '', AREA) this returns the sum of the areas regardless of the class. My symbols contains a Space, a few walls and a bathroom symbol which contains additional polygons that get summed with the space in the area calculation. If I could isolate the areas by class I could add more polygons and get areas for different purpose. Otherwise I could just do with the space area only avoiding the bathroom area being summed. Any idea/workaround?

Thanks Pat, I did no realise I could take the shortcut It works! For the moment that's all I need. I guess I can further refine the polygon/spaces selection using the class. Many Thanks

Is there a way to show the record field of an object contained into a listed symbol ? I have a schedule that lists symbols in a given class. Each symbol contains one Space. I would like to have a column that shows the area of the contained space for that symbol. What would be the formula for such record field? Many Thanks S

Hello, I'm trying to create a schedule of flats that shows the area of the Space inside each flat symbol instance listed on the schedule. I imagined various way to do so but the most effective for this purpose would be to have a script that get the area of the space inside the symbol and assign it to a custom record field attached to the symbol. I have been able to put together some basic script in the past but this one exceed my skills by far. Basically I need a script that retrieve a record field form an object contained in a symbol and assign it to a custom record field of the containing symbol, that should be done for every symbol in the drawing(with some sort of selection criteria es symbol definitions in a specific folder) Any help would be greatly appreciated!