# Trigger alert when two values match

**URL:** <https://community.glideapps.com/t/trigger-alert-when-two-values-match/68331>\
**Category:** Ask for Help\
**Created:** [December 3, 2023, 11:40pm UTC](https://community.glideapps.com/t/trigger-alert-when-two-values-match/68331 "2023-12-03T23:40:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lucas\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_r/32/61017_2.png) [@Lucas\_R](https://community.glideapps.com/u/Lucas_R)\
**Post date:** [December 3, 2023, 11:40pm UTC](https://community.glideapps.com/t/trigger-alert-when-two-values-match/68331/1 "2023-12-03T23:40:12Z")

</div>

Context:

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:

1. When the keyword cell is empty, it matches with every item.
2. 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)

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [December 3, 2023, 11:44pm UTC](https://community.glideapps.com/t/trigger-alert-when-two-values-match/68331/2 "2023-12-03T23:44:58Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Lucas\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_r/32/61017_2.png) [@Lucas\_R](https://community.glideapps.com/u/Lucas_R)\
**Post date:** [December 4, 2023, 12:09am UTC](https://community.glideapps.com/t/trigger-alert-when-two-values-match/68331/3 "2023-12-04T00:09:39Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [December 4, 2023, 12:10am UTC](https://community.glideapps.com/t/trigger-alert-when-two-values-match/68331/4 "2023-12-04T00:10:51Z")

</div>

You need to handle an empty key in a separate function… don’t lose your hope… this is not a very hard problem 😉