Taproot Posted June 8, 2019 Share Posted June 8, 2019 Vectorworks doesn't incorporate hyperlinks very well. So much of the BIM universe is web-based now, but I have yet to find a way to easily link that information into my VW documents. For example: In my plumbing fixtures schedule I would like to include a hyperlink to the product cut sheet. For my lighting schedule I would like to link to the fixture, lamp, etc. It should be feasible to include hyperlinks as a format in symbol data and then report that to worksheets, but I haven't been able to do it ... So, I looked to other tools and after a lot of experimentation settled on Airtable.com Airtable is a web based application that looks like a spreadsheet, but functions like a database. If your "table" contains less than 1200 items, then it is free for you and an unlimited number of collaborators. I find this amount to be more than ample for my residential projects. I have found the interface to be extremely fast and intuitive to use. Because it's web based (with controls built in for who has read-only or editing permissions), it allows for instant updates across the team. During construction I find this to be MUCH simpler than the constant re-issuing of sets. It also allows for crowd sourcing data from the entire team. For example, I provide my clients with a generic list of appliances and they fill in the ones they want. This shares the load of data management and ensures that my clients get exactly what they want. Here's an example of how it can be used: Lighting Schedule This link is to a basic template for light fixtures. We call out the symbols i.e. LX-101 on the lighting plan, but instead of including a worksheet / schedule in the drawing set, we provide a link to this table. One challenge of digital publishing is making sure that everyone is tracking changes. You can do this by disabling links to the database and re-issuing new ones with an updated issue date. That helps contractors etc. stay aware of updates, but since it's a database, you can rearrange sorting, display, etc. in any number of configurations. For our typical projects, we include product schedules for appliances, plumbing, fixtures, millwork, lighting and equipment. This tool has been a great resource for us and may be of use to you. 3 Quote Link to comment
tdebicki Posted July 13, 2019 Share Posted July 13, 2019 Great idea! Is there a place where one can find some basic templates or did you make your own for each schedule? Quote Link to comment
Taproot Posted July 13, 2019 Author Share Posted July 13, 2019 Airtable has a whole list of templates that you can access. Here's a link to the 'Real Estate' section: https://airtable.com/universe/category/real-estate They are good for seeing what is possible, but once you get the hang of it, building a customized database that fits your needs is REALLY fast. Quote Link to comment
Chris Busch Posted August 25, 2019 Share Posted August 25, 2019 Hi Taproot, I’m just starting to explore how Vectorworks data can be moved to Airtable. Automated scheduled or real-time syncing would be ideal, but I know that can get messy. I’ve found it’s easy to move worksheet data to Airtable with a csv export (save for images), but need to look into ODBC for automation. Have you found any smooth workflows for this? Thanks! Quote Link to comment
Taproot Posted August 26, 2019 Author Share Posted August 26, 2019 Hello Chris, For our purposes, we schedule directly in airtable rather than export data from VW objects. Airtable holds our core information, so we can use it as a template when moving from project to project. The only synch we need to make is the ID # from the drawings relative to the database - which we do manually. So, we don't use an automated export method in our workflow. Quote Link to comment
Iain R Posted December 4, 2020 Share Posted December 4, 2020 Hi I'm also trying to link airtable and vectorworks. C-data has an ODBC driver for airtable, and vectorworks is odbc compatible. If I can get this to work it would speed up my workflows massively. Ive got as far as installing the driver, and iODBC which uses the driver, vectorworks recognises the database but I cant get it to connect at present. Anyone got any further than this? Cheers Iain 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.