It would be great If you could convince someone at Airtable (that I also love but NOT as much as Speckle) to embed live Speckle streams/commits (another icing on the cake)
I would second this request. An Airtable connector would be highly desirable.
Hey @Kai_Zhu ,
Welcome to the community. Can you explain your use case for an airtable connector? How would you use it and what kind of workflows youād enable with it?
Thanks for the response.
The way I see Airtable connector functioning would be very similar to the Excel connector. I.e. pushing data back and forth from speckle via tables.
Having that in Airtable allows for more powerful workflows compared to Excel due to its relational database capabilities.
+10000!
I was kinda sad for the industry to see an excel connector. Excel is the Sketchup of tabular data tools.
We are actively moving excel users to airtable, stitching databases together, as well as building out fully functioning web apps backed by airtable for its database. It is ver powerful and should be a no brainer to build a connector.
Iād use airtable to
- edit/add values to speckle object parameters
- attach & query additional metadata and databases for speckle streams, branches, commits, & objects.
- sync activity and events from speckle to airtable to trigger other workflows/notifications.
Itās really an accessible path for non technical users to connect tables, build workflows, and visualize data.
Itās the entry-level relational database that people have been shoehorning into Excel for decades.
So Iām hearing:
- read & write (like new parameter updater more than the vanilla Excel connector)
- automation
Hey there,
some use cases from my side. Weāre using airtable as a room-database and starting to use it as āelement-baseā, so we add properties in airtable instead of adding them direct into the model (different disciplines adding information and with airtable we give them the access to a part of the data). At the moment we canāt live update the base and the connection is done in powerBI, with a direct connection we could update our lists direct and create all kind of reports.
Are there already any prototypes of a connection from someone?
some thoughts againā¦ maybe the connection shouldnāt be airtableā¦ it should be make or automate, then we can create connections to any base and tool we need and speckle get the first ānocoding-solutionā in AECā¦ of course some of us like codingš. and of course we need then the āupdateā button in the archicad-plugin tooš.
Which Automate are you referring to @Manuel_Emmenegger ?
Are you already using Make for aec data?
@jonathon thank you for asking
zapier, make, microsoft power automate
no, weāre using airtable / softr at the moment and import then some properties back to archicad with an excel. solutions on the market like drofus are maybe a good example to understand, what Iām thinking about. Weāre creating room-tables in airtable (before a model is existing) and classify then the room with all the information we got from the building owner. 2nd step is generating the rooms in CAD and now we can connect the database with powerBI/ speckle/ airtable (similar to ifcTracer, but maybe in the future faster, easier and webbased;).
Problem: What happens when someone delete a room in the CAD or in the databaseā¦ with a connection we could update the database.
2nd case: There is a lot of information in the room, which comes not from the architect, when we can import all this information much easier to the modelā¦ we donāt need again excel-imports.
Whatās your opinion about these thoughts? Are there better ways to achieve that?
Not to deviate this request for an Airtable connection too far, but some of what you are describe fits a lot of what we are looking to achieve with Speckle Automate.
We announced this in November at SpeckleCon23 and have been in closed beta since with Specklers adding functions and building automations with them.
Interfacing with external solutions has been a strong component of the submissions and suggestions so far.
I totally support the Airtable request! We have been using Airtable in a similar manner to @Manuel_Emmenegger (By the way, Iād love to exchange some ideas with you Manuel) connecting several databases in Airtable with our Archicad models and custom-scripted GDL objects to automate the geometry generation and documentation process.
You can check this article from our blog: GDL, CSV & Automation ā A case study on signage package creation ā Enzyme APD Blog
Airtable Rocks! Speckle Rocks! Its like seeing two friends you like dating
Hey @j.beneitez and others here,
I was just checking the Airtable API, and I canāt seem to find a way to create custom Data Integrations.
They do offer an API Sync integration, but only in the Business & Enterprise plans.
This means the integration should instead exist as a Speckle App that pushes/pulls data from Airtableā¦
Alternatively, please use this form to suggest Speckle as an official integration:
You are right @teocomi - which is why I am working on a demos with Speckle Automate as a push / pull with Airtable.