It seems that there is no way to call directly an external API to a record on Airtable.
My goal is to be able to shorten URLs (using Bit.ly API) in my database.
I was wondering if there is a way that scripts might be able to help?
Here is Bit.ly API reference : https://dev.bitly.com/api-reference
I appreciate any help on this subject.
Thanks so much for your input.
I’m trying to stay inside Airtable as much as possible (thanks to the new button and automations features) and to be less dependent on third party integration (zapier, Integromat, etc…) unless absolutely necessary.
I don’t know how to write a script though, If anyone is interested to provide the script for the community that would be awesome :- :slightly_smiling_face:
I hope you’re doing well!
I am coming back on this subject as I am trying do to the same thing but couldn’t manage to set up the Airtable Automation with Zapier! Do you know if we are able to create this in-app now ?
To give you some context :
People have pre-registered to my service
Now is time for subscription and I would like to send a new form (linked to another table) that would be prefilled in order to ease the customer journey.
The prefilled link is however too long to work in my emails so I’d like to shorten it before sending it
Do you know how I can do that ?
I don’t know if I’m clear…Thanks a lot for your help
I don’t know scripting, but Bitly is a popular link shortening service, which you can automate in a no-code/low-code way using Make.com. I find Make more intuitive & more powerful than Zapier:
Also, not sure if this would work for your purposes or not, but another option instead of sending lengthy prefilled URLs would be to use a portal service like MiniExtensions.com. Then, people can log in to see their own record, and edit their own records directly in their web browser.
I tried the automation and realized that my issue is not linked to the length of the URL but rather to the fact that some of the fields I want to prefill (example : Type of use) have answer that are in more than one word, which breaks the formule when I want to turn it into an URL (cf picture)
I tried to add a substitute (“”, “+”) in my formula but it doesn’t seem work…
Do you have any idea on how I can process to avoid this?
I have tried to create a button and it works well but I need to put this link into an email…
Thanks a lot!