JoarL Posted August 24, 2022 Share Posted August 24, 2022 I'm trying to get text from the User Defined Info field (and some other info) for a specific room number into a Worksheet cell. I can accomplish this by generating a report, but I also want to make a small worksheet to display along with a smaller part of the floor plan (an apartment). I'm able to do this with areas but not with this type of text. I'm not sure if this is impossible, if I just haven't found the right worksheet function, or if the syntax is wrong. Any ideas of how to accomplish this? Quote Link to comment
markdd Posted August 24, 2022 Share Posted August 24, 2022 Can you upload the object and the workseet in a file? Quote Link to comment
JoarL Posted August 24, 2022 Author Share Posted August 24, 2022 Here is my test file. worksheet_testfile_VW2022.vwx Quote Link to comment
markdd Posted August 24, 2022 Share Posted August 24, 2022 I'm not sure you can do this using Spreadsheet method that you are trying. However, there may be others who can point you in the right direction. Quote Link to comment
Pat Stanford Posted August 24, 2022 Share Posted August 24, 2022 You SHOULD be able to do this using the Worksheet function OBJECTDATA('universal data'), but so far I have not been able to make it work. But I think a Data Tag is actually a better option for this than a microworksheet as you can just attach it to the space and not have to manually enter the space number into each worksheet. I have added a Data Tag that looks somewhat like the worksheet version in this file so you can have a starting point. worksheet_testfile_Pat.vwx Quote Link to comment
markdd Posted August 24, 2022 Share Posted August 24, 2022 @Pat Stanfordyes I tried the OBJECTDATA function but couldn’t get it to work either. However, not confident enough with spreadsheets to declare a bug! Quote Link to comment
Pat Stanford Posted August 24, 2022 Share Posted August 24, 2022 I can get ObjectData to work on Door objects, but I can't (yet) make it work with Spaces. Letting my subconscious work on the problem. Quote Link to comment
JoarL Posted August 25, 2022 Author Share Posted August 25, 2022 (edited) The Data Tag method I have found adds extra steps, with the possibility for user error, I need hundreds of tags so this is an important concern. The table I want to create also shouldn't be linked to drawing objects like Data Tags are. What I want to accomplish is also a bit more complex than shown in the example. I'm currently working on a housing project with over 100 apartments. For each apartment there will be a separate drawing, along with a table of areas and other information. The table needs to contain gross area, net area, balcony area, internal storage area, extrenal storage area, and some other information stored in the User Defined Info fields. The area part works but not the other information. So far I also haven't been able to get OBJECTDATA (or other functions) to work. I think I read somewhere that spreadsheet commands are now possible in Data Tags. This actually seems like a good option (with the apartment number as the link), but I still need to collect the User Defined Info from the Space object in some way. Edited August 25, 2022 by JoarL Quote Link to comment
JoarL Posted August 25, 2022 Author Share Posted August 25, 2022 I have tested Data Tags some more and spreadsheet functions doesn't work as I had hoped, so I'm back to worksheets. Quote Link to comment
markdd Posted August 25, 2022 Share Posted August 25, 2022 Here is the drawing back with a working Data Tag. I hope that gives you what you need. worksheet_testfile_VW2022.vwx Quote Link to comment
JoarL Posted August 25, 2022 Author Share Posted August 25, 2022 Thank you for your effort, but I already know how to do this. As far as I can tell the Data Tag will not be able to display any more information than the label for the Space object anyway. Quote Link to comment
Pat Stanford Posted August 25, 2022 Share Posted August 25, 2022 Quote The Data Tag method I have found adds extra steps, with the possibility for user error, I need hundreds of tags so this is an important concern. The table I want to create also shouldn't be linked to drawing objects like Data Tags are. So it is less error prone for you to have to type an identifier into hundreds of tags than to click on the correct object to link the tag? You want to have hundreds of separate worksheets that have to be edited individually instead of a single data tag style? What happens when you have to change the label on a field from "extrenal storage area," to "external storage area" after you have created all of the worksheet labels? Data tags can most definitely pull all of the information from the space object. And it can do far more. Glad to help you figure it out, but if you are fixed on using WS, then good luck. Quote Link to comment
JoarL Posted August 25, 2022 Author Share Posted August 25, 2022 Unfortunately, what I want to do is not as easy as adding a tag to an object. I need to pull information from multiple Space objects, across multiple floors (layers) of the building, and display the information in a table next to the drawing on a Sheet layer. So far the only method I have found that mostly works is worksheets, do you have a suggestion for how this can be accomplished with Data Tags? Quote Link to comment
Pat Stanford Posted August 25, 2022 Share Posted August 25, 2022 The multiple objects part is what you had not explained clearly before. No, Data Tags are not going to work well in that case. But unless you can accept the standard horizontal Database layout of the worksheet, neither is the worksheet option. Perhaps you actually need a custom Plug-in Object or a script that will collect the information you need and put it into a text block. If you are interested in something custom, let's take this to DMs and see what can happen. 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.