wellebracht Posted January 11 Share Posted January 11 Is there a way for me to add a filter to a worksheet or equipment summary key that will only count the symbols that exist within a Space Object? I have about 34 separate rooms with a slightly different layout in each room, and would like to have a worksheet or equipment summary key filter out all the gear I have within each room independently. Quote Link to comment
michaelk Posted January 11 Share Posted January 11 Yes. The criteria is LOCATION. When you use Location the choices are "is within" and "is not within" and then you will see a list of possibilities. By default the space objects will have a UUID # that is I think 16 hexadecimals inside curly brackets. If you click on a space object that same UUID will be in the Name field at the very very bottom of the OIP. You can change that to something more human readable and that new name will appear in the criteria list. If you want to go the other way and your space objects have names in the Space Name field, then you can use the call =GetSpaceNameforObj in the database header row and it will return the room name for all the spaces that object is contained within, separated by a comma. 3 Quote Link to comment
wellebracht Posted January 17 Author Share Posted January 17 So, I'm not sure if I just am filling out the formula incorrectly, or if I'm running into a bug. I cannot seem to get the =GetSpaceNameforOBJ function to work within a report. I can filter a report with that criteria, and it works just fine, but I cannot seem to get that same data to appear within the spreadsheet itself. Am I just using the wrong context within the spreadsheet? Quote Link to comment
michaelk Posted January 17 Share Posted January 17 Can you send me the file? Make sure you have a name in the room name field of the OIP. 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.