Skip to main content

Hey all,



I’d love your feedback on a tool we’re working on, called Scripts.



What is it? An extension that embeds an onsite code editor into your bases.



Why would I need that? If you’ve ever used Google Scripts or VBA for automating spreadsheets, this is the same for Airtable.



It makes it easy to build custom alerts, automations, workflows, reports, and integrations for your bases, using short Python scripts. The extension handles API calls behind the scenes (even as the Airtable API is quite limiting), OAuth with other apps you’re integrating with, hosting, and more.



Who is it for? It’s designed for power users with a bit of Python experience, automation geeks, or API developers.



What’s the ask? Take the extension for a spin, reply back with your feedback, and don’t share too broadly just yet… we haven’t yet launched!



Paul



PS - here are some cool use-cases



Build an Google Sheets Export/Import integration in 60 seconds





Setup mail merge in Airtable



Pretty cool stuff! 🙂


Hello Paul. This looks great. I just installed it as a chrome extension and then made a request for Airtable scripting access. Is that what I am supposed to do?


Hello Paul. This looks great. I just installed it as a chrome extension and then made a request for Airtable scripting access. Is that what I am supposed to do?


Hey @David_Skinner, yup - you got it.



Then to open the editor, go to any base and click click the green leaf in the bottom left (may need to restart if you just installed).



Once in, import a template to see how it works, or check out some of the vids. Message me if you have any q’s!


Hey @David_Skinner, yup - you got it.



Then to open the editor, go to any base and click click the green leaf in the bottom left (may need to restart if you just installed).



Once in, import a template to see how it works, or check out some of the vids. Message me if you have any q’s!


Nice one. It says my account can’t add triggers. Is this a feature that isn’t ready yet? Or one I would have to pay for? What triggers are/will be available?


Nice one. It says my account can’t add triggers. Is this a feature that isn’t ready yet? Or one I would have to pay for? What triggers are/will be available?


Good catch.



At least according to the Airtable API docs, it doesn’t seem like Airtable officially supports webhooks. I’m guessing they have a special “on new record” webhook for Zapier, but aren’t ready to enable that for anyone else.



As soon as they launch webhooks - hopefully both ‘on new record’ and ‘on changed record’ - we can enable triggers in the scripting editor. Maybe comment on this feature request in the meantime?


Good catch.



At least according to the Airtable API docs, it doesn’t seem like Airtable officially supports webhooks. I’m guessing they have a special “on new record” webhook for Zapier, but aren’t ready to enable that for anyone else.



As soon as they launch webhooks - hopefully both ‘on new record’ and ‘on changed record’ - we can enable triggers in the scripting editor. Maybe comment on this feature request in the meantime?


OK cool. I’ll have a play around with it and let you know how I get on.


OK cool. I’ll have a play around with it and let you know how I get on.


Sounds great :thumbs_up: @David_Skinner


HI @Paul_K,


I added extension to chrome, I created the api key, but I do not see the green leaf in the bottom left.


What is wrong? Can you help me?


Many thanks


Alessandra


HI @Paul_K,


I added extension to chrome, I created the api key, but I do not see the green leaf in the bottom left.


What is wrong? Can you help me?


Many thanks


Alessandra


Hey @Alessandra_Carlevaro - you may need to refresh the base page that you’re on for the button to pop up the first time.


Thank you @Paul_K!


I have closed the browser and then re-opened, but I not have reloaded the page … I am sorry for the previous request!


Now I can try the automations!


Many thanks!


This is quite exciting - but for those looking for a more approachable solution there are ‘push’ Zaps in Zapier.



Also a Chrome extension, this feature adds a small button to the Chrome tool bar from which specific Zaps can be directly triggered. This is what it looks like:





The example push zap will update the specific employee’s record being displayed in the Expanded view.



I’ll write a blog post about this in the next few days…


Just a heads-up: this service is neither officially endorsed nor vetted by Airtable. Airtable cannot vouch for the security credentials of this third-party service, and if you choose to make use of this service, you do so at your own risk. Please be careful when potentially exposing your Airtable data to third-party services, especially if you are using Airtable to store sensitive information.


The lack of an official scripting system is what prevents our company to use Airtable instead of Google Sheets 😦



Good luck with this extension! If it has success hopefully Airtable will develop a similar feature.


Hey @Paul_K, I’ve added the chrome extension, refreshed the browser, clicked the green leaf and hit allow scripts for base but nothing happens after that (no pop-up window etc). I’ve disabled uBlock and Ghostery and still nothing. I wonder if you are able to help?



Thanks,


Oli


Hey @Oliver_Robson happy to help. Do you have any other extensions that might be interfering?


Hey @Oliver_Robson happy to help. Do you have any other extensions that might be interfering?


I’m not sure - I thought it might be uBlock Origin or Ghostery as they both generally stop pop-up windows but I’ve disabled them both with no success. Also tried it on a work machine with less/little extensions (only uBlock active) with no success.


Hey @Oliver_Robson happy to help. Do you have any other extensions that might be interfering?


Had just removed both extensions (Ghostery, uBlock Origin) and still no success, I’ve inlcuded a screengrab of the other extentions below:



https://postimg.cc/image/cy2lyi7vr/



Whatfont? The great suspender, metamask, ethereum network, grammerly, honey, tradingview, google calendar, bitmex and blockspring


Hey @Oliver_Robson happy to help. Do you have any other extensions that might be interfering?


Hey Paul - I’ve just noticed that a couple of other users are having issues with it working in Airtable also after looking at the app reviews, hopefully this may be of some help to you. I’ve removed all extensions and still no success.



“Not working with Airtable. After clicking icon in bottom left and clicking ok on popup nothing happens. Checking the console shows a uncaught typeerror. Community site down. Slack channel is pretty dead. Please help. Would love to get give the Airtable Mail Merge a try. Thanks.”


Hey Paul - I’ve just noticed that a couple of other users are having issues with it working in Airtable also after looking at the app reviews, hopefully this may be of some help to you. I’ve removed all extensions and still no success.



“Not working with Airtable. After clicking icon in bottom left and clicking ok on popup nothing happens. Checking the console shows a uncaught typeerror. Community site down. Slack channel is pretty dead. Please help. Would love to get give the Airtable Mail Merge a try. Thanks.”


Totally missed this message. I took a look again today and all seems to work well. But it might’ve been recent pushes between a few weeks ago and now. Can you try again?


Totally missed this message. I took a look again today and all seems to work well. But it might’ve been recent pushes between a few weeks ago and now. Can you try again?


Hey Paul - the extension is loading up great now! I plan to use this for crypto and as such have changed the ‘function’ to the crypto reference provided by Alpha Vantage. I’m currently receiving the following error, I wonder if you are able to help me? (I also receive this error whilst trying to run the template script).



Pastebin of error



I’m not a dev and only have limited coding knowledge but it looks like it’s having trouble finding the table to pull the data into? Any help would be appreciated!



Thanks,



Oli



Oliver Robson



+44 (0)7403 476 425


Totally missed this message. I took a look again today and all seems to work well. But it might’ve been recent pushes between a few weeks ago and now. Can you try again?


Strange. It’s not identifying the current table in the base. What happens if you refresh the airtable page, then click the leaf again?


Hey Paul,



I just installed blockspring but the greenleaf does not appear on airtable whereas it’s working on trello. I restarted but still nothing. I certainly missed something. Do you have any idea?



Thanks,



Charley Damont


Hey Paul,



I just installed blockspring but the greenleaf does not appear on airtable whereas it’s working on trello. I restarted but still nothing. I certainly missed something. Do you have any idea?



Thanks,



Charley Damont


Can you try refreshing?


Can you try refreshing?


Can I ask how ‘real’ a product is Blockspring? It’s quite an interesting approach, and I can see some immediate uses for it — but your community pages are dead, there are no live links to press coverage, the most recent blog entry was posted August 2016, and there’s nothing I can find identifying who the people or companies are behind Blockspring.



I would be greatly interested in trying to incorporate it into my solutions — if it was definitely going to be around. (I am much heartened by there being a recent update on github, but that’s not the same as having a fully committed line of business in place to support and promote Blockspring.


Can you try refreshing?


Ok Paul it’s working, thanks!


I feel a bit stupid.


Reply