Skip to main content

I am running a scraper to fetch data into my Airtable.

 

Sometimes, the Company name is in full; for example, International Business Machines.

I want to batch convert (correct term?) them into IBM.

 

I am half done with the automation -- When a Record Matches “International Business Machines” .

But what comes thereafter is the challenge -- I assumed it should be Update Record but unable to input the “IBM” text.

 

Any help would be greatly appreciated.

 

thanks

If you really wanted to make an automation for each and every instance necessary, you already have your trigger, and then you update record using the RecordID from the trigger to ID the record, select the field “Company Name” and type in IBM, as any instance of International Business Machines should result in IBM. 

I think the more preferred method would be via formula, using SWITCH() to automatically change International Business Machines to IBM. Then when you came across another instance (United Parcel Service→ UPS) you’d just add another variable instead of making another automation

Hey ​@SenRath,

 

I agree with ​@DisraeliGears01. I would suggest you use a formula to handle this, as automations might be error-prone for different reasons. 
 

What are other example of company names you would need to change?

 

Mike, Consultant @ Automatic Nation

​@DisraeliGears01 

​@Mike_AutomaticN 

 

Thanks a lot for the tip/s. Yes, that worked and much better than my initial idea.

 

Thanks again.

 

Glad to hear that ​@SenRath!

Mike, Consultant @ Automatic Nation 

Reply


Terms & Conditions