Multiselect dependency in Enterprise 9.1 on SugarCloud. 

Hi Jim Cotten,

Correct. The user interface does not let admins use multiselect fields in a calculation of another field or its dependency calculation (the two use the same interface essentially).

There is a workaround you can employ at a code level that is fairly simple.

Hosted by Sugar Cloud, you can use Module Loader to install a custom package with the custom code you wish to install. This requires knowing how to make a Module Loadable Package.

Steps I took:

1. In Studio, for Accounts, I created a multiselect field (ms1_c) and a textfield (tf1_c).
2. I calculated tf1_c with this field variable formula: $name
3. I added the two fields to the Accounts RecordView layout.
4. In the file system, I edited custom/Extension/modules/Accounts/Ext/Vardefs/sugarfield_tf1_c.php
5. I changed the formula from: 

   $dictionary['Account']['fields']['tf1_c']['formula']='$name';

   to: 

   $dictionary['Account']['fields']['tf1_c']['formula']='$ms1_c';

6. I ran a Quick Repair and Rebuild to push these changes to throughout the appropriate files in the system.
7. I edit an Account and set the multiselect with two sample values and save.

The results appear in the RecordView

 {SugarClub Administrator Edit: We're sorry, but this image is no longer available}  

I hope this helps!

Patrick, this is a great answer.  I will be experimenting with it today.

Patrick, this is a great answer.  I will be experimenting with it today.