I plan to build a confirmation portal for sensitive words using Zapier, where company employees can paste a piece of text and check if it contains any sensitive words. I plan to use:
- Typeform: To allow company employees to paste their text and their email
- Google Sheet: To allow developers to add sensitive words in real-time (currently over 2000)
- Filter: To find the latest sensitive words in the Google Sheet and filter them directly into the Filter setup.
- The filtered sensitive words will be pasted in an email and sent to the employee, informing them of which sensitive words are in the text they posted.
I am now stuck with the Filter. As my Filter conditions are constantly changing, using "contains" to set it up requires continuous addition of "or" conditions, and it also causes difficulties in modifying.
I would like to ask if there is a better way to set up the Filter?
Best answer by nicksimardView original