Users can create items and giving them title. (text column in table)
Users could be able to set up, for themselves, multiple keywords of what they are interested in. (text column in table)
When someone upload an new Item, I want users to receive an email alert if the newly added item’s title contains a keyword from other users’ keyword list.
I tried to do it with table relation and If-then column…
Problems:
When the keyword cell is empty, it matches with every item.
I couldn’t find a proper way to create a rule to make it work.
Need:
Advices on how to.
A potential solution that allow the matching even if the keyword is not 100% matching (ex typo error, plural)
You can use the Javascript column or if-else column to check if the string contains the search key… also turn to lower case key and string before comparing
While I wrote this post I was using if-else column, no matter how I make it, it doesn’t work. Also when using if-else, using the “is included” or “includes” fonction while the keyword cell is empty, it cause a major error where every item are matching with the empty keyword cell.
I might need to try with a JS column but I still don’t have a big hope.
