Look for text within multi-selection value

Options
PJG
PJG Member
edited July 7 in Calculations & Variables (Beast Mode)

Hi all,

I currently have code like this, which converts some selection values to a shorter display value

when Business Division_p = 'Biologics' then 'Bio'

The problem is that the attribute is multi-selection, so when there is more than one value selected, there is no match. How can I change this line of code to look for text within the text of the selected options, instead of the entire selected options?

Thanks!

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    you can use the like operator along with the % sign which acts as a wildcard

    when Business Division_p LIKE '%Biologics%' then 'Bio'
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    you can use the like operator along with the % sign which acts as a wildcard

    when Business Division_p LIKE '%Biologics%' then 'Bio'
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories