Kazemester Posted November 24, 2017 Share Posted November 24, 2017 I'm still looking for the formula to list wall surface areas (with wall IDs and different wall components listed) within one space (when the data is not in the space north,east...etc. wall finishes, because that can't handle that when i have more than 4 walls around a space). It would be nice to list wall component areas that a space boundary touches or contains. I could only list all my wall component areas, but that doesn't tell me which is in which space. Quote Link to comment
Boh Posted August 30, 2018 Share Posted August 30, 2018 The latest version of this script doesn't seem to be working for me. I copied & pasted the text into a new script. When I run it I just get an error file. is there something I'm doing wrong? An earlier version of this script I have seems to work on most objects. However didn't get much back for space objects: Quote Link to comment
MullinRJ Posted August 30, 2018 Share Posted August 30, 2018 Boh, It's possible you unintentionally copied some extra characters from the browser to the script editor. This has been a problem in the recent past. Try again. It worked for me this morning. If it still doesn't work, try this ZIP file: Pat's PIO Field Script.zip HTH, Raymond Quote Link to comment
Boh Posted August 30, 2018 Share Posted August 30, 2018 You're right. I used your zip file that worked. Thanks! Quote Link to comment
lucioing Posted June 13, 2019 Share Posted June 13, 2019 Thank you, Pat! Great !!! L. Quote Link to comment
Christiaan Posted May 16, 2022 Share Posted May 16, 2022 Thanks Pat, this is great. Quote Link to comment
trevorgooch Posted July 10, 2023 Share Posted July 10, 2023 Hey, @Pat Stanford This has been a super useful script, both for the data it reveals, and as my introduction to creating worksheets! There's one unimportant tiny typo: SetWSCellFormula(WSH,1,1,1,1,Concat('Parameter Fields for PIO: ',S1)); SetWSCellFormula(WSH,3,1,3,1,'Display Name'); SetWSCellFormula(WSH,3,2,3,2,'Cell Formula'); SetWSCellFormula(WSH,3,2,3,2,'Field Type'); <--- Should be column 3 I only offer this up, as this has been such a useful script, and I'd like the next person to see it in all of it's glory. 🙂 Thanks a ton for all the help you provide on here - I know that I've benefited a ton from answers and help that you've given ages ago! -Trevor Gooch 1 Quote Link to comment
Pat Stanford Posted July 27, 2023 Author Share Posted July 27, 2023 Thanks @trevorgooch, I can't post an updated version right now due to a bug in the Forum software. Hopefully this will get fixed soon and I can post. Quote Link to comment
E|FA Posted August 9, 2023 Share Posted August 9, 2023 (edited) The script is perfect (after fixing a couple of typos and corrected (WSH,3,3,3,3,'Field Type') per @trevorgooch - ZIP file attached). If it's not too much to ask to go beyond perfection, is it possible to add a fourth column that shows the actual values in each field for the selected PIO? Also, what does "__NNA_DO_NOT_CHANGE" mean? Clearly it's something I shouldn't change. And for forum cross referencing, a related thread is HERE Pat's PIO Field Script - TYPO FIX 2.zip Edited August 9, 2023 by E|FA Fixed the fixed uploaded file 1 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.