Batch change keywords

[Michael_Lever]

In my law library I have a field "keywords’ , customised to multiple select. I have a keyword Notice/Service that I want to delete and substitute two keywords Notice and Service.

The quickest way I find to batch change a keyword is either to copy and paste and input into each record or enter the keyword(s) into an empty field then shift>enter and drag the blue rectangular to fill each empty field,

However, that cannot be done when the field is not empty to begin with but contains other (different) keywords that are not to be overwritten, (See screenshot)

Is there another way to batch input into a field that contains existing keywords that are to be retained? (I have approximately 350 entries to change and am resigned to doing them one by one)

[ScottWorld]

I would check out the Batch Update extension. It should do what you need.

[Michael_Lever]

Thank you ever so much. 273 records updated in seconds! I change keywords regularly so this extension is going to be very useful.

[ScottWorld]

That’s great to hear! You’re welcome! :grinning_face_with_big_eyes:

[kuovonne]

Michael_Lever:

I change keywords regularly

In that case, you might also consider converting your multiple-select field to a linked record field.

[ScottWorld]

@Michael_Lever

This is great advice from @kuovonne! I highly recommend this approach. I also meant to mention this earlier myself, but I was driving while posting and had to be brief. Lol.

If you need help on learning about linked record fields, you might greatly benefit from my free Airtable training course:

LinkedIn

Learning Airtable Online Class | LinkedIn Learning, formerly Lynda.com

Learn the basics of Airtable, a spreadsheet-database platform, including how to create tables, use different types of fields, leverage views, work with records, link tables, and more.

[Michael_Lever]

Very kind of you to suggest ways other than the Batch extension but the latter is good enough for my needs, thank you.