Jump to content

trevorgooch

Member
  • Posts

    41
  • Joined

  • Last visited

Everything posted by trevorgooch

  1. I really appreciate the “like a view perspective”. It helps it make sense. I don’t think it’s worth the effort to me this month to dig deeper- it’s most important to be nimble. Thanks, Josh!
  2. Hello, my very clever friends! TLDR: Is there a way for the clip cube to inform the result of the criteria "is visible"? I have specifically tested it in the context of a worksheet database criteria, though not yet in a script. Backstory: I have a worksheet that is populated by the criteria "is visible" to give me a quick report of the current on screen elements in table form. (I have a script to recalculate active worksheet that's triggered by my stream deck) I often click on a row and "select item" -> fit to obj -> select similar -> clip cube ->... ??? -> profit wildly -> recalculate active worksheet to see what's around the elements I'm investigating. Anyway - I *think* I'd like to be able to use the clip cube as part of a worksheet criteria. Have a great day.
  3. @michaelk "I have a bunch of old worksheets" Probably shortly after I found all of your posts about worksheets, and scripts to improve formatting, I started adding three columns in almost every worksheet: Symbol/type, layer, and class. Always in a kinda grey as a house keeping note. "=FIRSTNONEMPTY(SYMBOLNAME, OBJECTTYPENAME)" for the symbol list - all in a way to reveal where we went wrong! Thanks for the script! This will save some time for sure!
  4. @michaelk- I will never stop loving posts about these scripts- and sharing this gospel far and wide. This and fast flats. And cabby. And…. Thanks for your contributions!
  5. This was a helpful demo to get my head around data linking in data tags. Best of luck!
  6. One thing that may help is to attach a record to the data tag, and use a link field. Essentially, you can shuttle data from the source object into a record associated with a data tag. This allows for all sorts of interesting opportunities, like applying a data visualization to a data tag!
  7. So, after talking to @Mark Aceto about this, my alternative solution is to move the calculation to the data manager (populating a field in an added record). Then the data tag can associate with the new data record. It’s a work around, but I was able to use “=IFS()” with multiple logical tests and returns.
  8. So, I've taken this a little farther: collecting the channels of lighting devices that share a dimmer (useful for labeling breakouts or breakers). The script looks for the match field and field to concat and return. Lots of options here - and no criteria. This does seem friendlier.
  9. @Pat Stanford Thank you for the advice, that is surely born out of experience. I've been considering the best way to address it, looking forward. I suspect simply not posting the scripts directly is the most prudent move. One of the big picture challenges I'm looking at currently, is how to make the drawings and solutions as resilient as possible. The opposite of "fragile" or easily broken. 😉. I will be on the look out for more danger zones!
  10. Fun stuff! You can simply paste the criteria into a parameter, and add an additional single quote to get around sting literal issues. Working this way, leaves me with a flexible method for commands that I wish were criteria aware, but are not! Here's a quick example: PROCEDURE WSSum; { This is a group effort, born out of Michael Klaers education draft! mucked around with by Trevor Gooch.} VAR s : DYNARRAY[] of CHAR; RecName : string; FieldName : string; Criteria : string; r,r1 : REAL; PROCEDURE SumReals(h1:HANDLE); BEGIN s := GetRField(h1,RecName,FieldName); r := Str2Num(s); r1 := r1 + r; END; { This now takes three parameters: the record name, the field name, and the critera. To get around single quotes in the parameter string, simply use two consequetive single quotes.} BEGIN RecName:=WSScript_GetPrmStr(0); FieldName:=WSScript_GetPrmStr(1); Criteria:=WSScript_GetPrmStr(2); ForEachObject(SumReals,Criteria); WSScript_SetResInt(r1); END; RUN(WSSum); Definitely solved my problem! Thanks! Counting Stanchions.vwx
  11. @Pat Stanford - you're speaking my language! It seems that parameters are zero indexed. Round one - working on a script to sum field values based on a criteria, where the records and fields and criteria are passed. Sort of a generic "sum field values by criteria" Also, I had no idea that we can pass a string as a criteria. This is very cool. Off to the races! Thanks, Pat!
  12. @Pat Stanford Is there a way to apply a critera to SUM in a worksheet cell, and specify the data field? I keep thinking I've missed something obvious! Thanks!
  13. @michaelk/ @Pat Stanford / @Fuge Thanks for the help! I didn't think of a worksheet cell script! It would be great to have criteria aware math functions or versions of functions - for example, Area and Count can be used in a cell as '=Area(**Critera**)'. or '=Count(**Critera**)'. A bit like sumifs or lookup in excel. I was sure that I had missed something obvious - but maybe what I had actually missed was another opportunity to home-brew the solution I needed. Thanks for the assist!
  14. Thanks, @Pat Stanford- it’s been an interesting exercise mashing up database criteria and database header functions into a single cell. It would SEEM that this is also pretty relevant to data manager expert mappings, and really leveraging data tags. I have success with “count” and objects. What I’d like to do is get a total of all the ‘Rope and Stanchion’.’TTLStanchions’ that meet a given criteria. Sort of a sum of field given a specific criteria.
  15. Hi, wizzards! ( @michaelk, @Sam Jones) I'm experimenting with single cell calculations in a worksheet, and getting tripped up. I would like to have a single cell count, say, the total amount of stanchions meeting a set criteria. I can get the total area of objects ie: =AREA(((C='Queue Lines-Reserved') & (LOC=A1))) In a database, I can get there with a database that looks like this: =DATABASE(INSYMBOL & (INVIEWPORT) & ((L<>'zzQUICK HIDE') & (LOC=A1) & (PON='Rope and Stanchion'))) and a column header like this: =VALUE('Rope and Stanchion'.'TTLStanchions') It seems like the function "objectdata" is part of the answer, but, I'm a little stuck. Any guidance would be super appreciated! -Trevor Gooch
  16. 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
  17. Re Top 2d/3d - that's exactly the use i have for it. I double tap there all there time. Swapping the icon is an awesome idea. Maybe there is value in adding a double tap function giving the other views an ortho/perspective toggle. I might play with that...
  18. @Pat Stanford Thanks for that! I have done that - complete with a clumsy script that names all of the crop objects! What I would really love to do is to leverage the Graphic Legends ability to only be aware of the *visible elements* in the viewport. I can count within a named object as LOC, but I still need to build in the layer and class criteria in the worksheet. Since the criteria exists in the worksheet independent of the viewport, if the viewport visibilities are changed, the worksheet would not follow along. Are there functions to reference the viewport's visibilities? Is this a pursuit best advanced with some scripting? I'm not adverse to it, i just want to make sure I'm not missing an easy win! Thanks!
  19. Hi - I'd like to display the text dynamic text associated with the Graphic Legend cells - but without any images. In essence, I'd like to benefit from the ability to filter by a selected viewport to create simple item counts. Am I missing something simple? Thanks, wizard friends! -Trevor Gooch
  20. FWIW, I keep needing to count things by breakout room, with loads of plug in objects, and want to make little equipment lists/BOM's. Something different than a graphic legend, and more than a data tag. So, i revisited my unfrozen-caveman-gaffer/neanderthal solution, and discovered a few neat things in the process. My existing, manual solution: Create a worksheet that looks and counts one space (or named object) as you'd like. Use LOCATION in the criteria. This gives a chance to present symbols and plug in objects in a way that's useful for you, or perhaps match a vendors quote layout Update the worksheet's database formula to change the LOC= to LOC=A1 Make a bunch of copies of this worksheet, and edit the first cell to match the name of the space you need to count. Place an image of the worksheet on each sheet. So, I tried to dip my toe into scripting. First, i wrote a script to make sure that each space object had a name, and if there was a custom space name, copy that into the OIP Name. Then I wrote a script to make a copy a the top open worksheet for each space object, incorporating the name of the object into the name of the worksheet. And I figured out how to take that space name, and put it into the first cell of the newly created work sheet, so all of the lookups were correct. At this point, it occurred to me that I wasn't really using spaces in any meaningful way. I was back to just needing a named "thing" that I could use as a location, unique to each sheet layer. Or.. unique to each viewport! So, here's what I have come up with: Use @michaelk's neat-o script to rename viewports! Now they all have a somewhat meaningful name! Run a script so that, for each viewport: Name the viewport crop object relative to the viewport name. Make a copy of the selected worksheet, named to match the viewport, with the A1 cell updated to our viewport crop object name. Find the layer the viewport is on, and create a worksheet image there. I can make a single worksheet that looks the way that I want it, and quickly have one unique copy per viewport, landed on the appropriate sheet layer. Also, I and a complete vectorscript noob - this is missing much error checking, and dialog event handling, and probably introduces some risk of catastrophic data loss. It does give an alternative to a graphic legend. I've attached a file with the script in it. Worksheet per Viewport.vwx
  21. @DianaK I have it working! I used data source linking in the data tag field definition. This is also the key to applying a data visualization to a data tag! I plopped your data tag on your template layers fast and loose. LMK if you'd like to discuss! -TG 1648724319_TBreplacementissueTG.vwx
  22. I don't have a Data Tag solve. I did face a similar, albeit small situation where I had 40ish breakout rooms. Sharing my workflow, and maybe one of the wizards above might see a scripting opportunity! On my ground plan layer, I added named polygons on a layer called "zHide Floor Plan Boundaries". I found that we had digital signage and queue lines that extended beyond the drawn floor plan, so separate poly's were necessary. I made a worksheet that looked how I wanted of Spotlight elements (and square footage of queue lines). I edited the database formula to include "LOC=A1". Lastly I made a worksheet that listed the named objects on the ground plan boundary layer. With 40 rooms, I could place a re-named copy of the worksheet on the drawing, and edit A1 to match the named polygon. The upside is that you make one worksheet, and edit one cell, and that's all the work to make it specific for each space. We also explored making the worksheet look alot like the vendor's estimate format, for easier error correction. I do think that sounds terrible to do by hand at 300 rooms. Following this thread, because I have this show again this fall- and any improved workflow would be wonderful!
  23. @Lunar Waneshaft Here's today's version: with meeting friendly play/pause and system wide "Mute Microphone". CPU usage is an attempt at: did vwx crash, or is it "working"? Clever! I think leave the button looking like "selection" and change what it does under the hood... I understand Panic Panic Panic... I have questions about at least one other key.. 😉
  24. @Lunar Waneshaft I don't know if I share it: I got my streamdeck xl, added a mechanical keyboard (minus 10), and my space mouse on the left. I played with two vwx profiles that I found on the web, while many have been pretty great, I tend to keep it to two layers: Views and Navigation (which links directly to..) Temp set of useful today tools: ie, move by points, rotate, select (so I don't move to the keyboard), duplicate along path, to name a few. I found that is was not very functional to have every menu and tool option replicated in the deck (looks cool, tho!), but rather, I think about it like a moving light programmer, who quickly moves the dozen or so buttons or views that are really imports *right now* to a place that I can leverage the value of a hard button without looking. I can't wait to see the wizardly you land on...
  25. My Stream Deck XL arrived as I was leaving town for the last show, and I'm in the busy, all-too-brief in between time before the next show, filled with things I have neglected whilst on the road (bills, relationships, etc). I'm ashamed (and entertained) to share that it currently shows me the current CPU load in the top left button, and that's all. Updates when I have a minuted to dive in! @Mark Aceto, let me know if there is anything that you're curious to have play tested, and I may move that up the list...
×
×
  • Create New...