Ben Wingrove Posted November 26, 2017 Share Posted November 26, 2017 I use a worksheet on my front page to inventory all used fixtures, video elements, truss and soft goods. Sometimes we have to create multiple versions of an object to show different positions, I tried to attach a record to the extra objects called "Hide from Inventory" thinking that if I include a criteria in the worksheet for the record "Hide from Inventory" not being present it would be a quick way of excluding extra objects without having to constantly re edit the worksheet. Alas it did not work, is there another way to accomplish this or am I going about this the wrong way? I have included a screen grab of my worksheet Criteria, there are 12 screen objects, 6 have the "Hide from Inventory" record attached, 6 do not! Thanks B Quote Link to comment
michaelk Posted November 27, 2017 Share Posted November 27, 2017 It seems to work for me. Have you tried unchecking Design Layer Viewports in the criteria? Quote Link to comment
Pat Stanford Posted November 30, 2017 Share Posted November 30, 2017 @Ben WingroveDid you get this to work? If not, you may need to manually edit the criteria instead of using the criteria builder. My understanding is that by default the same types of criteria are OR'd together. It appears you need an AND instead. This can be done manually, but not with the criteria builder. Quote Link to comment
Ben Wingrove Posted November 30, 2017 Author Share Posted November 30, 2017 @Pat StanfordI still have had no luck, I thought it might have something to do with the “or” “and” syntax. I tried editing it manually but it kept defaulting to the criteria builder settings, I will try clearing out the builder and just doing it manually in the header. Quote Link to comment
Pat Stanford Posted November 30, 2017 Share Posted November 30, 2017 Can you post the file so we can take a look? Or at least post the database row criteria formula. Right click on the header row and choose Edit Criteria. Click into the Forumula bar, select everything and copy and paste here. Quote Link to comment
Ben Wingrove Posted November 30, 2017 Author Share Posted November 30, 2017 The header is =DATABASE((INOBJECT & INSYMBOL & (R IN ['VS4-LED']) & (('VS4-LED'.'ConfRef'='Overall Dimensions and Spacing') | ('Hide From Inventory'.'Hidden'=FALSE)) & (L<>'*UNUSED*'))) Quote Link to comment
michaelk Posted November 30, 2017 Share Posted November 30, 2017 Pat is better at parsing these things than I am. But I think it currently reads something like this. An object meets the criteria if it meets all of the following conditions. 1. Record VS40-LED is attached 2. The field 'VS4-LED'.'ConfRef' = ' Overall Dimensions and Spacing OR the field 'Hide From Inventory'.'Hidden' = FALSE 3. Layer is not *UNUSED* I think if you change the '|' to '&' it will do what you want. To change it get to the edit criteria like where you took your screen shot. Hit Cancel. Now you can edit the criteria directly in the data bar. Quote Link to comment
Ben Wingrove Posted November 30, 2017 Author Share Posted November 30, 2017 Changing the "|" to "&" didn't help! The problem may be that I am only attaching the "Hide From Inventory" Record to things I want to hide, so if it is set to only show HIDDEN as FALSE it may be confusing it!! Quote Link to comment
Ben Wingrove Posted November 30, 2017 Author Share Posted November 30, 2017 OK So I took @michaelk's idea of changing the '|' to '&' but instead i told it to search for the "Hide from Inventory' record to not be present instead of the actual field value. That worked Only problem now is if someone unchecked the "HIDDEN" field value instead of removing the record all together it won't work At least it will get me off to a start. It is a shame you can't add user fields to built in objects, I added a Show In Inventory checkbox to the Lighting Device Objects (Spotlight) and that works like a charm. Quote Link to comment
michaelk Posted November 30, 2017 Share Posted November 30, 2017 There are 10 "User Fields in the Lighting device record format that you can use for things like that. Quote Link to comment
Ben Wingrove Posted November 30, 2017 Author Share Posted November 30, 2017 2 minutes ago, michaelk said: There are 10 "User Fields in the Lighting device record format that you can use for things like that. @michaelk I Know, thats what I used for the Lighting Devices but alas there is no such functionality for Truss, Soft Goods, Video elements etc. 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.