0

if contains then

I am trying to create a formula where if the text box contains a certain phrase or word to then display an action, how do i do this?

2 replies

null
    • SMoore
    • 4 yrs ago
    • Reported - view

    Got it!

     

    If text like "value" then 

    • SMoore
    • 4 yrs ago
    • Reported - view

    I have

     

    let o := concat((select Comment).'Search For');
    let c := Comment;
    let i := first((select Comment where 'Search For' like c) order by Order);
    i.'Show As'

    Although, in order for i.'Show As' to work, it has to be the EXACT input, not if it is similar or contains what 'Search For' is looking for. 

     

    The formula referenced above is acting like:

    let o := concat((select Comment).'Search For');
    let c := Comment;
    let i := first((select Comment where 'Search For'=c) order by Order);
    i.'Show As' and i need it to pull only when it contains a specific rersult. 

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 1851Views