Cdevo7 Posted July 27, 2020 Share Posted July 27, 2020 (edited) Hello all, I was wondering if anyone knew how to make a two way worksheet? I want to be able to Edit my record from the work sheet just like how I can edit the Worksheet from my record. Attached is an example of my file with the description field being the only field I want to be able to do this to. The text is already linked to the record I just cannot figure out how to edit the worksheet and type directly into it thank you in advance for the feedback. Best Regards, Colin Devenish Practice Help.vwx Edited July 27, 2020 by Cdevo7 Quote Link to comment
Pat Stanford Posted July 27, 2020 Share Posted July 27, 2020 Hi Colin, Any field in a worksheet that is of the =Record.Field variety is automatically two way. This can be for either a PIO Parameter Record or for a custom record that you have attached to an object. For PIO Parameter Records you would edit the data on the Shape pane of the OIP. For custom records you would edit the data on the Data pane of the OIP. You don't have to to do anything special to set this up, but put in the =record.field formula in the worksheet. Quote Link to comment
Cdevo7 Posted July 27, 2020 Author Share Posted July 27, 2020 Even when I type =record.field in the formula bar it just selects all the contents in the column of the database when I click a cell. It doesn't allow me to input my own values into the worksheet and edit the text that is linked to the record. Is there a setting I need to change to stop this from happening? Quote Link to comment
Pat Stanford Posted July 27, 2020 Share Posted July 27, 2020 Your screen shots are too small to read, but I downloaded your practice file. When I change the values in the worksheet the values in the OIP change. When I change the Discription field, the text linked to the record change. I am using =record.field as shorthand to mean use your record name and field name like you have. So what you have in your database headers is correct. Click in cell A2.1 and type something other than the letter A and the text on the object described by that subrow will change. What are you seeing? Quote Link to comment
Cdevo7 Posted July 28, 2020 Author Share Posted July 28, 2020 The formulas are the same as in the sheet but here's what I see when I try to click and Edit the cells. It just selects all the cells each time and won't allow me to click in and edit them in the worksheet Quote Link to comment
Pat Stanford Posted July 28, 2020 Share Posted July 28, 2020 This is your example file opened directly from the download in VW2020 SP. As you can see in the movie, I can change the values in the worksheet and have the text automatically change on the object. While I clicked into the edit bar to make the changes, you can also just select the cell and start typing and it will overwrite everything in the cell. If you want to edit what is in the cell you will have to click into the edit bar. ScreenFlow.mp4 Quote Link to comment
Cdevo7 Posted July 29, 2020 Author Share Posted July 29, 2020 I see maybe my package doesn't include this because this is what happens when I use this in my document. IMG_3005.MOV Quote Link to comment
Pat Stanford Posted July 29, 2020 Share Posted July 29, 2020 Have you changes the criteria or worksheet functions from the test file you sent? I don't know why you are not able to select a single database cell. I am relatively certain that is available in all VW versions. Can you right click in the data base subrow row header (2.1, 2.2, 2.3) and if so do you get Select Item as an option? Quote Link to comment
Cdevo7 Posted July 29, 2020 Author Share Posted July 29, 2020 No The criteria is all the same I just added a couple more A Items I can right click on the rows 2.1 ect. and select the whole row and right click and I see select the item Quote Link to comment
Pat Stanford Posted July 29, 2020 Share Posted July 29, 2020 I am stumped. I don't know what is causing you to not be able to select an individual cell. Is this VW2020? Are you on a Mac? If so, maybe as a test you can create a new user (system preferences:Users and Groups) and log into there and see if VW does the same. If it does then it might suggest that you uninstall and reinstall VW. If it works OK in the new users then that suggests that you have corruption in your user folder. You can move it to your desktop and restart VW and see if that fixes the problem. @michaelk. Can you take a look at the movies above and tell us if you can think of any reason to not be able to select a cell in a subrow? 1 Quote Link to comment
Cdevo7 Posted July 30, 2020 Author Share Posted July 30, 2020 Yes I'm on a Mac with Vectorworks 2020 and I will send it to a co-worker and see if they have the ability to edit the database. I will also try to change which user I'm on or reinstall the program. Quote Link to comment
Vectorworks, Inc Employee Hugues Posted July 31, 2020 Vectorworks, Inc Employee Share Posted July 31, 2020 Are you running Vectorworks Fundamentals? The two way worksheet feature is not available for Vectorworks Fundamentals. Quote Link to comment
Cdevo7 Posted August 3, 2020 Author Share Posted August 3, 2020 What package would I need to gain this feature? Quote Link to comment
Pat Stanford Posted August 3, 2020 Share Posted August 3, 2020 Any of the Design version packages should be fine. Architect, Spotlight, Landmark. Or if you need features of more than one get Designer. Based on the sample symbols you have shown, I think Architect might be your best bet. You will get improved Wall/Door/Window handling that might help you workflow compared to Fundamentals. 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.