Hobbsies Posted January 24, 2017 Share Posted January 24, 2017 Hi, I asked this question a day or two before the new forums went live and my previous post has vanished into the nether. I'm trying to make a work sheet that when I run a script will import certain information from record labels attached to symbols contained within a viewport on a sheet layer. I want to make a list of lighting fixtures that exist in a view port, basically. In the attached picture, the red box is what I'm trying to do automatically. Currently, I manually enter all of that information which is time consuming and error prone when things change often. I'm also trying to learn vectorscript and python, so I'm hoping someone can just point me in the right direction so I can learn how to do this. Thanks! Quote Link to comment
michaelk Posted January 25, 2017 Share Posted January 25, 2017 There are a couple of easy ways of doing this that require no scripting: 1. Check out the instrument summary tool. It can be filtered by position. 2. I usually make a little worksheet with one of the criteria being the position name. Then I replace that name in the criteria with a reference to a cell. Now, whatever position name you type in that cell will automatically be used in the criteria. (You don't have to do this, you could also do it manually). You will need to create a duplicate of the worksheet and change the position name in the cell or (in the criteria) for each position. I'll attach an example. Enter the name of the position into the top left cell and it counts all the instruments and accessories on that position. hth mk Position_Information.vwx Quote Link to comment
Hobbsies Posted January 25, 2017 Author Share Posted January 25, 2017 (edited) Thank you! I didn't know about the filter option in the instrument summary tool. Can you save that as a 2016 file? I'd love to see how that work sheet is set up. Edited January 25, 2017 by Hobbsies Quote Link to comment
michaelk Posted January 26, 2017 Share Posted January 26, 2017 Here it is… Position Information v2016.vwx Quote Link to comment
JBenghiat Posted January 30, 2017 Share Posted January 30, 2017 The Instrument Summary filter option has simple check marks for filtering by position, layer, and class. You can also insert a custom criteria. -Josh Quote Link to comment
Hobbsies Posted February 4, 2017 Author Share Posted February 4, 2017 On 1/30/2017 at 11:35 AM, JBenghiat said: The Instrument Summary filter option has simple check marks for filtering by position, layer, and class. You can also insert a custom criteria. -Josh Yeah, this has saved me 2+ hours of work. Thanks! 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.