Dec 01, 2021 05:45 PM
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
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!
Dec 04, 2021 01:59 PM
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.
Dec 04, 2021 05:49 PM
Clearly I’m reading this all wrong. I’ll step out now.