Airtable to Grasshopper using Mallard

Nick_Cassab · March 16, 2020, 10:28pm

gist.github.com

https://gist.github.com/MarcDiethelm/7303312

Contributing.md


This text now lives at https://github.com/MarcDiethelm/contributing/blob/master/README.md.
I turned it into a Github repo so you can, you know, contribute to it by making pull requests.

---

## Contributing

If you want to contribute to a project and make it better, your help is very welcome. Contributing is also a great way to learn more about social coding on Github, new technologies and and their ecosystems and how to make constructive, helpful bug reports, feature requests and the noblest of all contributions: a good, clean pull request.

This file has been truncated. show original

use the directions in this link, and once you submit the pull request, i’ll go in and review it and hopefully approve it!

let me know if you need help with any of these steps! github can be quite confusing

susannn.wu · March 17, 2020, 2:38pm

Hi Nick,

I did the pull requests, please check.
Thank you.

Nick_Cassab · March 17, 2020, 10:24pm

i just merged your edits, and credited you! congrats!

susannn.wu · March 18, 2020, 5:30am

Great, thank you!

Nick_Cassab · April 3, 2020, 12:48pm

How to use Mallard, for connecting grasshopper to airtable, in 10 min:

susannn.wu · September 19, 2020, 3:48pm

Hi @Nick,

I was trying to have Mallard upload attachments to Airtable, and I failed at the first time. So I did some study on Airtable API documentation and Airtable.NET source code, finally I updated Create/Update components to have the feature upload attachments worked.

So, about the update, it was based on following references:

To create new attachments in attachment fields, from Airtable API documentation

image773×146 8.53 KB
Error message

image881×214 18.1 KB
Source code of AirtableRecords.cs from Airtable.NET

image1320×826 48.9 KB

Finally I modified this part:

Below is a sample that used Mallard to create records with multipel fields, different field types including string and attachment, to Airtable. In this sample, plugin jSwan was used to create attachment objects from urls.

You may want to take a look of this, I had made a pull request on GitHub.

Nick_Cassab · September 19, 2020, 4:34pm

Wow

You’re incredible!

I was trying to figure this out but haven’t had the time! Thank you so much.

-Nick

Remy_Konings · September 20, 2020, 9:55am

Would love to use the plugin in Rhino for Mac too!
Would you by any change look into this?

Thank you!

labdgrafo · May 5, 2021, 1:12am

Hello Nick! I am really grateful for your plug-in. but I have a problem with the fields component, I have this message and I don’t know why… I have double-checked the table on airtable, please can you help???

reo.oshiyama · July 5, 2021, 2:39am

@Nick_Cassab
Hi.
I am trying Update Airtable Record component, but it does not work well.
Can you give me a sample file of this component?

Nick_Cassab · July 5, 2021, 1:35pm

It looks like you need to provide the Airtable Record you are looking to update as the input to the “R” field. This means you need to provide the Record itself. Do not convert it to string or text.

I hope this explanation makes sense.

Nick_Cassab · July 5, 2021, 2:20pm

I would upload a sample file but it wouldn’t work without a base ID and an app Key

reo.oshiyama · July 6, 2021, 1:44am

@Nick_Cassab
Thanks for the reply.
I was able to solve about it.
However, when I update Airtable with Update or Replace, the data is duplicated.
What should I do about this?

thanks

test.gh (9.1 KB)

Nick_Cassab · July 7, 2021, 6:16pm

I just tried it myself, and it wouldn’t update. something is definitely messed up with the component itself. it’s not your fault.

I may not have time this week to get around to fixing it but I will try.

Here is the github repo for the project if you want to try digging into the code yourself. please let everyone know here on the forum if you manage to improve the plugin in anyway.

Remy_Konings · September 13, 2021, 4:08pm

Any change that this is already solved? I have duplication problems as well. I would really like to use your plugin.
Thank you

nc284 · December 22, 2021, 8:17pm

Hi all,

Just updated the List component to be able to pull more than 100 records from a table.

Thanks for everyone’s support!

Nick_Cassab · September 12, 2022, 4:49pm

Major update for Mallard to 2.0!

duplication issues resolved
async update allows script to be used while mallard fetches new data
fields issues have been resolved
clearer instruction demo file with a sample database
icons redrawn to be more readable
plugin simplified to just 5 components

Get Mallard 2.0 here: https://www.nickcassab.com/

rrrrrrrrush · November 15, 2023, 8:48pm

I try to create a layers from airtable using Elefront Bake Layers but there is some problem (two plugins are getting confused at load time?). Do you have any idea how to fix this?

and is it possible somehow to auto update List component for example?

osuire · February 6, 2024, 5:28pm

Hi Nick,

I have an Airtable base with links between tables.
The thing is : Mallard reads the links as IDs and does not resolve them as values.
Can we only use Mallard with static tables (no links) or am I missing something here ?

Also, I see that numbers come out as “goo”. The only way to retreive actual numbers is to pass them through a panel component. Could this be improved ?

Thanks

michael.broderick · February 8, 2024, 12:15am

In airtable, you’ll need to add a lookup field to get the data in text format. Then reference the new column in grasshopper.