Hi Airtable Community,

Although I figured out a lot and learned to do amazing things in airtable [we use it as our CMS for our online magazine] I need some help with this situation:

Here is a screenshot of parts of our database:

We need an easy way to find where we can add interlinking to our articles [so like in wikipedia that keywords link to other articles]. Think this way:


Article XYZ is about ‘emotional self-care’. �e.g. line 5 in the screenshot].


Now we want to find where in all our other articles we mention ‘emotional self-care’.


If we find this keyword/anchor text in an article, we know we can insert a link to the article xyz there.

I would approach it like this, but don’t know if this makes sense and is possible:


The main text of the article is in column ARTICLE_BODY.


And we have a column with the keywords/anchor texts we are looking for ocolumn int-link-anchor].

Is it possible to build a function/or script that would:


go through each main text and look FOR ALL the keywords in column int-link-anchor] from all articles - and then output a list of all the keywords that were found in one article?

In other words:


in line 1 the feature would first try to find ‘chakra healing’ in the ARTICLE_BODY, then if nothing found - output nothing.


then look for ‘crown chakra’ - if found, output ‘crown chakra’,


then look for ‘crystal singing bowl’, if found, add ‘crystal singing bowl’ to the existing ‘crown chakra’ … and so on.


in the end we would have a column where for each article, it would show all the keywords that were found.

then we can either add the links manually, or even build a replace/substitute function.


but the first part is crucial: to find all the keywords.


that would be a huge help as the articles get more and more.

I hope I explained it well enough … and it would be so great to hear your ideas!


Thanks & with kind regards,


Benedikt