Enhance Multi-Select Picklist Functionality - Increase Reportability and User Experience

We have a special guest Peter Lyon going over a really cool unmanaged package that he built to help solve the reporting nightmare that is Salesforce multi-select picklist fields. Pete created a flow that automatically updates a related object with multi-select picklist values so that reporting is a breeze. Now instead of having to comb through all of the semicolon-separated values in a report, you can use the child records. We learn how this flow is built, the speed it takes to process records, and the reduction of headache for Salesforce admins and developers when using this technique.
Subscribe to Pete / @letsplaysalesforce
Check Pete out on LinkedIn / badpeteno
Down the unmanaged package here! bit.ly/MultiParser
Subscribe for more videos like this: bit.ly/2ZjoZ8h
Want to take your #Salesforce Knowledge to the next level? Go to salesforcementor.teachable.com/ new course content every week to keep you fresh.
If this video was helpful consider supporting me.
/ salesforcementor
Patrons get access to all my source code, an exclusive discord, and Daily Force Primer for exam questions.
Check out www.salesforcementor.com for additional Salesforce content.
Thanks for watching.
Follow me on twitter / thewalters954
Connect with me on LinkedIn / walters954
Join the Salesforce Exchange Discord join.sfxd.org
---------------------------------------------------------------------------------
Recommended Books
Advanced Apex Programming amzn.to/2X8hZb4
Clean Code amzn.to/2X8iaTM
Salesforce Platform App Builder Certification amzn.to/3eZOGPj
Practical Salesforce Development Without Code amzn.to/30tDXsD

[@pedroprada1]

Wow! What an amazing and creative way to use Flows to automate fixing Multiselect Reporting capabilities.

[@user-jl1pp8zk6h]

Brilliant! Super helpful--thank you both!

[@cburt22ify]

This is awesome, big ups dude!

[@heatherglenn8352]

Oh my goodness! So glad I found this! I just deployed our version to production and users are already loving it. Thank you!

[@kubrakayman4627]

This is a great solution for multiselect picklist! Thank you both!

[@marybethlemay4115]

I love steve mo! you three guys are the main guys I listen to! together with Judi Sohn!

[@Condimenting]

Great video!

[@lucianroux4510]

Thank you so much for sharing this with us.

[@Walters954]

Thank Pete he was put the time and effort to package this up and demo it for everyone.

[@freecaseyanthony312]

very smart, thanks for putting this up

[@Walters954]

Our pleasure!

[@whelm5985]

Great solution! One question, would you still recommend this solution if we have 20 multi select picklist in one record ?

[@bhuvaneswaryr4399]

Thank you both for the great video. I have a question, would you prefer this method using process builder and flow combination over apex trigger?

[@cjsimmons8790]

Awesome solution! One question... I have a multi-select picklist on the Lead object. Since Lead cannot be the master in a master/detail relationship, how can I use this solution for Leads?

[@neilhohmann10]

In this case, the Lead could be the parent in a lookup relationship with a custom object. Just be sure to set up the child object to be deleted upon the deletion of the Lead object. (If anyone sees why this wouldn't work, let me know.)

[@davidsno3501]

What is this wizardry?! 🤯

[@Walters954]

The magic of flows!

[@marybethlemay4115]

Another questions - in the unmanaged package they just used the name to set the value in the best practice/meal preference table. It would be cool to click on those values (i.e. vegetarian option) and see related banquet orders. I think I get that it's not a picklist itself (It's driven by a text) field so you can't do it but what would be the work around. making best practice a picklist field? I assume then you'd have to have the values pretty set.

[@ZerotoCourseHero]

Ummmm #genius