Search the Community

ODBC and SQlite remote databases is a beautiful feature in VW. In BIM Software in reference to Architectural Drawings and the entire AEC Industry has possibly become more about referencing information than just simply drafting plans etc... This is proprietary or generic information about building products, light fixtures, furniture, etc... Managing all of this information from a single source (VW) is extremely difficult. This is why ODBC and SQLITE in VW is so useful! If information can be referenced externally, it can also be Managed externally. Additionally, it can give VW an upper leg on competition with Autodesk Revit given that much of the informational libraries for Revit have been created by Manufacturers themselves. This however can apply record information to generic symbol library and expedite the process of creating massive symbol libraries. These databases can become quite large given the number of proprietary and standard building products. This information can include a lot of information including but not limited to specifications! Currently there is not sorting feature in ODBC and SQlite window. My request is to simply at a sorting function for record information, possibly similar to the way record information is sorted in worksheets database connection. I'm not sure if this is a big ask, but I think this could start the implementation of standardization in offices large and small that use VW

Hi, Is there an easy way to change the "sort order - order" in a worksheet? In Excel ,Microsoft refers to sort order "levels" which can be moved up and down (e.g. sort by Column A first, then by column B and then by column C) You have a relatively friendly dialogue box where you can move those levels up and down. I can see the little numbers within the worksheet column header icons that show the order levels, so I can see the order in which they are applied, but the only way I can change the 'levels' is to remove all the sorting completely and start again. I looked here - but nothing mentioned - notably bullet option 5 doesn't work (perhaps this is an older feature now removed (I'm using 2021) https://app-help.vectorworks.net/2016/eng/VW2016_Guide/Worksheets/Database_Row_Sort_and_Summary_Functions.htm I know there are movements afoot to update worksheets significantly for the next release - so here's hoping 🙂 R

I have a worksheet which is a plant legend made up of records for a number of different plants. I'd like to separate the legends by category ie Tree, Shrub, Vine, Groundcover etc. I have the category in the worksheet and can sort, but is there a way to make entirely separate legends for each so I can sort alphabetically within the category?