Find and replace words

Airtable Logo Airtable ExtensionFree!

Applicable to:

All Airtable plans

Example use case

Substituting words

Find and replace words in your Airtable easily with this free extension.

In the example below, I've created a new table to act as a dictionary. It contains two columns—(i) the "Old Text" column has the words I would like replaced, and the (ii) "New Text" column with the respective replacement words.

Here's the extension in action. Words that appear in "Old Text"—"Corpo" and "Testa", have been replaced with words in "New Text"—"Body" and "Feet", respectively.

Wanna try it out? Open this sample base-> and click on "Copy base". The example will be copied to your Airtable workspace so you play with it. If you're satisfied, you can build around the example provided, or export the functionality to your own base. See below for full instructions.

Instructions to generate the script for Airtable Automations

  1. Create a new table containing a list of Old and New words like I've done above.
  2. In your Airtable base, go to Extensions (top right corner), and click on Add an extension.
  3. Search for "Scripting" and add it.
  4. Copy and paste the follow code into the editor:
  5. Follow the instructions on the screen to select the appropriate table and field names.
  6. Click Run, and copy the formula generated. It looks like a chain of substitutes. It looks something like: SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( {Options}, "Corpo", "Body"), "Piede", "Feet"), "Testa", "Head"), "Kopf", "Head"), "Fuss", "Feet"), "Tête", "Head"), "Korper", "Body"), "Fuss", "Feet")
  7. Create a new Formula field in your original table. Paste the formula copied in the previous step.
Need help?Contact us.