Thread Details
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 367 subscribers
  • Views 879 views
  • Users 0 members are here
Forum Actions

In the release notes for Sugar 11; the function isInList has been updated to work with mulitselect fields; Is there an examples of how to properly make this call?

Jeff Bickart

In the release notes for Sugar 11, https://support.sugarcrm.com/Knowledge_Base/Installation_Upgrade/What_to_Expect_When_Upgrading_to_11.0/. It states 

Sugar Logic Passing a mulitselect field as a second parameter in the isInList() formula does not work. Admin users can now pass a mulitselect field as a second parameter in the isInList() formula.

What is the proper way to use this update?

I'm trying to show a value if ABC or DEF is selected in the multiselct field

Fullscreen
1
isInList(createList("ABC", "DEF"), $multiselectfield)
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

or

Fullscreen
1
or(isInList("ABC", $multiselectfield), isInList("DEF", $multiselectfield)
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Documentation has not been updated for this chanage

  • 0 Sugar Employee Badge

     This is built to support the second formula of yours(I also tested to make sure). 

    Fullscreen
    1
    isInList(needle, haystack);
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
     Needle being the value/string you're searching for in the haystack/the multiselectfield. 

    For example, if we have a multiselect field $multi_field with values A, B, C selected:

    1. isInList(A, $multi_field) = true

    2. isInList(B, $multi_field) = true

    3. isInList(X, $multi_field) = false