{Dynamics CRM Multiselect} Multiselect Picklist control in action–For Editable grids and Data uploads.

Thanks for your overwhelming response to our Multiselect control for Dynamics CRM. Thanks to everyone for your queries for the tool and liking it as well.

In case you have missed our earlier post regarding the multi select control for Dynamics CRM, you can jump to this link.

https://debajmecrm.com/2017/01/05/new-utility-multi-select-picklist-control-for-dynamics-crm/

Of the queries that have come across for the tool, the most asked were

  • How would the multi-select show up in views?
  • How would it work for editable grid’s and data uploads.

Well, I understand that I haven’t explained these in my earlier post and apologies for that. But my intention was to get everyone a taste of the tool and then do a deep dive on the advanced feature the tool offers.

No more talking here. Let’s straightway see how the multi-select control handles the above two scenarios.

How it would show up in Views?

For people who have already read my last article and for those who already are using the utility, they are pretty much aware of this. But just to brush up our memory, whenever we configure an Optionset field for multi-select using the tool, two additional fields gets created for the tool.

For example, I have a field called Display Name – Initial Communication (schema – initialcommunication) on the Opportunity entity which I have configured for multi-select behavior. Two additional fields get created

  • Multiselect Label for initialcommunication (xrm4you_multiselect_label_initialcommunication)
  • Multiselect for initialcommunication (xrm4you_multiselect_initialcommunication)

 

image

 

For all the view related purposes, the label field is the one we would be using. The first thing you can do here is come over to customizations and then change the Display name to something you want to the end-users to see. I change it to Communication only.

image

Save & Publish.

The next thing that I do is include it in the “Open Opportunities” view.

image

I have configured the Multi-select control on the form. In case you are not aware on how to do this, you can find it here – https://debajmecrm.com/2017/01/05/new-utility-multi-select-picklist-control-for-dynamics-crm/

Save & publish everything and we are all set.

I open an existing opportunity – “Video Hardware Upgrade’. The multi-select control renders and I select all the existing values.

image

Save it and you are done!

Now let’s see how it looks when I see it in the view.

image

The end-users ends up seeing the display values of the options selected which is kind of the ideal behavior that you would expect.

Please note that here the values are separated by ‘/’ character. However that can be changed with whatever character you would like it for your environment.

 

How does it work in editable grids & Data Upload

Here in comes the big question. Showing part is OK. But what about updating the value back from end-users perspective. Off-course you cannot expect your end users to save the optionset values.

Well don’t trouble yourself thinking too much on that. The tool from XrmForYou.com does that for you.

I have taken a new opportunity – “interested in new offerings” and have just entered a values for the communication field.

image

I just click on Save on the Grid.

Now I go ahead and open the record.

And as you can see, our selection is being reflected in the form as well.

image

Like in editable grids, for data-upload as well, all the end-users need to do is put the display labels of the Optionset Items separated by a separator of their choice. The tool will take care of mapping those text to the appropriate optionset values behind the scenes.

P.S – Support for editable grids and data upload is not available with the free version of the tool.

 

For more information about our products – please visit the products page – http://www.xrmforyou.com/products.html or write to us at info@xrmforyou.com

Advertisements

Author: Debajit

I am a Dynamics CRM Most Valuable Professional (MVP) with 10 years of experience in Microsoft .NET Technologies and 7 years of dedicated experience in Microsoft Dynamics CRM. I have worked with companies like Microsoft, SanDisk, PwC, TMF Group and have extensive experience of implementing complex CRM solutions from both offshore and client side. Currently the face of XrmForYou.com with significant experience in delivering corporate training on Dynamics CRM and have already delivered multiple projects to client through XrmForYou.com Author of multiple tools on codeplex including the 'Role Based Views' and 'CRM-Sharepoint Metadata manager & Attachment Extractor' which are available for commercial use under XrmForYou.com For consulting/ training, drop me a note at info@xrmforyou.com or visit our website www.xrmforyou.com

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s