Skip to main content

Automatic linking of tables based on any field

Show first post

29 replies

A
Forum|alt.badge.img+5
  • aaron_bell
  • Inspiring
  • 8 replies
  • November 7, 2022
ScottWorld wrote:

This thread is now somewhat outdated.

While linking records is still done manually in Airtable (instead of automatically like VLOOKUPS in spreadsheets), Airtable’s built-in automations and automation services like Make essentially solves this problem.

You just need an automation to kick in and create the link for you. So it’s not 100% perfection, but it’s good enough.

(Note: Airtable did not have automations when this thread was originally created.)


It’s wild that this can’t be done automatically and you have to manually select the link.

Maybe I could do it in Zapier.

Is there any good posts on how this can be done?

Appreciate your help, Scott.

EDIT:

Found this post on Zapier but you will have to pay for the monthly service. I think I can have this automated in Python though, which I will try first.

ScottWorld
Forum|alt.badge.img+33
  • ScottWorld
  • Author
  • Brainy
  • 8814 replies
  • November 7, 2022
aaron_bell wrote:

It’s wild that this can’t be done automatically and you have to manually select the link.

Maybe I could do it in Zapier.

Is there any good posts on how this can be done?

Appreciate your help, Scott.

EDIT:

Found this post on Zapier but you will have to pay for the monthly service. I think I can have this automated in Python though, which I will try first.


You don’t need to use 3rd-party tools — you can use Airtable’s native automations, which also enable you to write your own custom Javascripts.

If you’re looking at 3rd-party tools like Zapier, note that I don’t personally recommend Zapier. I personally recommend Make.com, which is significantly less expensive, significantly more powerful, and significantly more customizable than Zapier. Note that Make does have a little bit of a learning curve, but once you understand it, you’ve got the entire world at your fingertips. :winking_face:

Also, another 3rd-party tool is datafetcher.com, which lets you make standard API calls from within Airtable.

Also, if you’re having specific problems with your base:

For maximum visibility, be sure to post your question as a brand new thread, because this thread is 2.5 years old. Be sure to post screenshots and/or videos of any problems you’re having, to enable the best replies.

A
1 person likes this
  • A
    aaron_bell
S
  • supersparks
  • New Participant
  • 2 replies
  • November 9, 2022

Hello :wave: . This problem has caused me some headache on multiple projects over the past few years. So we are working on an extension that should allow you to accomplish an sql style join in minutes:

We would love to hear any feedback or questions in the meantime at hello@supersparks.io :muscle: .

Y
  • ycasias
  • New Participant
  • 1 reply
  • November 11, 2022
supersparks wrote:

Hello :wave: . This problem has caused me some headache on multiple projects over the past few years. So we are working on an extension that should allow you to accomplish an sql style join in minutes:

We would love to hear any feedback or questions in the meantime at hello@supersparks.io :muscle: .


This really frustrates me as well. I really wonder why dont people use Coda more. But my clients use AirTable so i have to use airtable… oh well :grinning_face_with_sweat:

Reply


Most helpful members this week

Terms & Conditions