Forums - Thread Details
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 178 subscribers
  • Views 196 views
  • Users 0 members are here
Related

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
11 days ago

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

isInList(createList("ABC", "DEF"), $multiselectfield)

or

or(isInList("ABC", $multiselectfield), isInList("DEF", $multiselectfield)

Documentation has not been updated for this chanage

  • 0 11 days ago

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

    isInList(needle, haystack);
     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