-
Posts
88 -
Joined
-
Last visited
Reputation
34 GreatPersonal Information
-
Homepage
www.luciddesigns.nl
-
Location
Netherlands
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
-
Thanks, i did test this as well. Placing all on same layer: no difference. Placing only the symbols on layer below: no difference. I think it remains a mystery... But having this working now, an automated display is a huge gain for me.
-
Good point @Pat Stanford , I checked this, but in this case that wasn't the problem. But I just found the solution.: for unknown reason, the formula doesn't see the SpaceObject.. now I've drawn a polygon around the border of the room and given it a name in OIP this polygon: 'Entree_LOC'. I have now succeeded with the following formula: =IF(COUNT(INOBJECT & INSYMBOL & (S='P1') & (L='00 Layout') & (LOC='Toilet_LOC'))>0; 'X'; '') So no I have “X” in a worksheet when at least one instance of symbol (i.e. V1) lies inside the room (i.e. Entree). 🥰 So thanks @Tom W. (for the tip on the 3D locus)!
-
"It’s driving me nuts🤣! I opened your file and tried copying the exact formula to the cell next to it, but it gave me a '#CVAL?' error. Even inserting a fresh column makes all the cells corrupt."
-
See what you mean, I found it strange it's not working cause it's just a formula....anyway thanks for the effort @Tom W. hopefully @michaelk still can have al look.. 🙏🏼
-
Tried it in your file as well So in other word I copies your formula and pasted it in your file and also copies the file with your formula and pasted it in the cell next to it.
-
-
@Tom W. I just adapted your formula to the data in my document (=IF((GETSPACENUMFOROBJ(SYMBOLNAME='V1')='Entree'),'X','') and it gives no results unfortunately...
-
@michaelk I know I previously said to sum all the symbols, but that was only because it was the only way to make it work at the time. This is the report I want to complete. There is no need to total the symbols (or texts, if that makes it easier) — for example, “V1” — for this report. Instead, I need a mark — an “X” — for each symbol or text present in the room. For example, “V1” represents a specific floor finish, and “P1” a specific ceiling finish. This way, the contractor knows exactly which materials to apply in each room. Ideally, when a symbol or text is added or removed, the corresponding “X” in the report should update automatically. Sample file attached. afwerkstaat test VWX forum.vwx Screenshot of rooms and and the accompanying report: Screenshot of (Tom's) Simple version :
-
Maybe @michaelk can you help me out please?
-
See here all the names of the objects I used i.e. SpaceObject, symbol and a printscreen of the record and the formular =COUNT((S='W1') & (LOC='Kitchen')) Can Anyone help me out please?
-
It should be straight forward according to chatgpt, but I do not get it working I am afraid. I did find out how to make Spaceobject : but the default had too many function so I deleted some (ie m2), maybe I made it corrupt? count symbol in Space object.docx
-
Interesting! I am doing some research now (with the help of ai and some tutorials). Keep you posted!
-
It's not like I don't want to use Spaces, I'm not familiar with this feature of what this means.. I did find the GetSpaceNameForObj function in the 'record schedule' cell. But I have no idea what to do with it and whether this would work for what I'm trying to achieve.
-
Ok thanks @Tom W. I do indeed mean to count the symbols in a room (as in living room/ living room). I do not know if marionette is the way to go... Just looking for a way to make it work. @Pat Stanford can you help please?
-
@Pat Stanford I see your point and wish I could afford, or my boss could be more generous. Unfortunately both not the case.
