Hi! I need to check if a text area contains the na...
# general
i
Hi! I need to check if a text area contains the name of the current user, and, if so, show the related record in the results of a saved search. I’ve tried several formulas for such criteria, but I’m not sure how to access the user’s name. Here is the formula I know that works (tested against my own name): CASE WHEN {text_area_internal_id} LIKE ‘%{user’s_name}%’ THEN 1 ELSE 0 END. What should be put instead of user’s_name?
b
use the current user join
i
Thanks!!