Search the Community

Hi @Vlado I want to be able to retrieve information from specific plants into various Cells in the Spreadsheet and not the Database inside my Worksheets. This can easily be done for several built-in objects in VW, not least for Materials. I am unable to find a solution for how to do this with information on specific plants. Information contained in the 'Plant Record'. I want to be able to retrieve various data from the 'Plant Record' into various cells in my Spreadsheet where I search for the plant's 'Latin Name'. An example is that I want to have a Spreadsheet in VW with similar layout as we have in UK Landscape Institute PDT Flora 6.1 - 28/06/2016(see image and attached excel file). Appreciate being guided on the right path. Image shows how I would like to be able to display data in the same way as PDT. Image shows my countless attempts to retrieve data from the plants' data located in the Plant Record. I know I'm not good at this, but I didn't think it would be so difficult 🙂(My file is attached) The reason I don't use Database for an entire row is that I want to be able to vary the layout of where the information should be in a Spreadsheet. Here are some other points that I have experienced when setting up many rows as a database; 1. On large files that the program takes a lot of time to calculate data when I have set up many rows as a database. 2. When I copy several database rows, I only get one row as database and the others are changed to Spreadsheet with text and numbers from the previous database. 3. When I copy a row, I have to go in and set up summation and sorting again for each and every column. This takes time so I had hoped the program remembered this when I copy. PDT_Flora6_1.xlsx Test Worksheet- Plant Record in Spreadsheet Cells 2024-01-04_v2024.vwx

I've recently uploaded 2021 version and now can't find the Plant lists - spreadsheet formats to collate all the plants on my planting plan. Any ideas where this is now in the Resource Manager?