Skip to main content

Building a script for a mass Find & Replace Automation

  • January 5, 2023
  • 3 replies
  • 29 views
T
Forum|alt.badge.img+1

Hi, 

I am looking to build a script that will allow me to run a large find and replace on Airtable en masse so I do not need to do each one individually. I have a list of around 137 words, they are sectors, that I would like to replace with broader sector categories or something along those lines.

For example, Film > Entertainment or Media & Healthcare Products > Healthcare. The sector on the left is what I would like to find and the category on the left is what I would like to replace. 

Does anyone have a script like this to hand where i can replace the find and replace words, or please could someone help me in creating this code. 

Thanks

    3 replies

    TheTimeSavingCo
    Forum|alt.badge.img+31

    Just checking, but have you tried the "Find and replace" script?



    Adam, Airtable Consultant - thetimesaving.company
    T
    Forum|alt.badge.img+1
    • tomsavage
    • Author
    • New Participant
    • January 9, 2023

    Just checking, but have you tried the "Find and replace" script?




    Yes, I did look at this extension and this is how I originally started doing it. Thanks for highlighting it. However, I have circa 100 words to find and replace, so I have to run the script over 100 times. I am wondering if there is a way to upload a table or list of the circa 100 words I am looking to find & replace. The aim is to only need to run the script once, rather than individually for each word.

    TheTimeSavingCo
    Forum|alt.badge.img+31

    Yes, I did look at this extension and this is how I originally started doing it. Thanks for highlighting it. However, I have circa 100 words to find and replace, so I have to run the script over 100 times. I am wondering if there is a way to upload a table or list of the circa 100 words I am looking to find & replace. The aim is to only need to run the script once, rather than individually for each word.


    Ah, I'm not aware of anything pre-built that's like that I'm afraid.  Creating a wrapper around that "Find and replace" script to handle a list of words you gave it would probably take an hour or so I reckon

    Adam, Airtable Consultant - thetimesaving.company
    Terms & ConditionsAccessibility statement