Is there a way to identify multiple keywords in a string and add the corresponding tag from a multi-select option?

[zhiliang_chen]

Hello all!

I would like to ask if anyone have an idea how to automate the following scenario or a formula.

Eg. I have different strings like

1. This is a Christmas tree.
2. This is a Xmas tree

I want to identify both the keyword “Christmas” and “Xmas” and tag them to a Multi-select option as “Christmas”

Is there an existing formula or automation to this?

Thank you all!

[kuovonne]

If the text contains keywords for multiple themes, I suspect that all of the matching themes should be tagged. Isn’t that why it is a multiple-select instead of a single-select?

I think that a linked record field would be better than a multi-select field. Storing the themes in their own table would automatically give a place to store the related keywords. Then an automation script can search the text for keywords and make the record links based on the matches found. Since the primary reason for tagging themes is for finding all the records under the same theme, it would be easier to identify those records in the linked record field of the theme.

[Justin_Barrett]

Clearly I’m reading this all wrong. I’ll step out now.