Following use case:
We are preparing all our e-mail materials within Notion. We also have a list with "Spam" trigger words. This list is a database because it is always expanding. Now I want to create a function, which matches to content or subject with the list. For this I have created a relation to the "Spam" database and pulled in every trigger. Now I've created a new Text prop where the user can put the content of the mail inside (because we can not get into page content with formulas). As you can see I've created the following formula:
if(contains(prop"INSERT CONTENT), prop("Blacklist")), "SPAM", "OK")
As easy as I thought, it does not work, because I can put into "INSERT CONTENT" whatever I want, the state of the formula does not change.
Does anybody have any idea, how to get it work? :D
I'm trying to find a match between two arguments. If a match does get found I want to state it as "SPAM", if there is no match found I want to declare it "OK".
