Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | All TechTalks
We have recently conducted an expo and collected a lot of leads via paper forms that we are going to begin entering into our CRM system. One of the items on the form was "what publications do you read?". We had checkboxes and the prospects were able to check more than one. Since I know there is no option for a multiselect picklist in CRM, what would be the best way to implement this? I know one option is using checkboxes but we want to report on this using a chart that shows how many people read each publication which I am not sure how to do if we have a different field for each one.
You can create a new entity (Publication), and have an N:N relationship between Contact and Publication. This will let you associate any number of contacts with any number of publications. Then you would build a chart to get the data back, it would be a chart or graph by Publication, showing the number of contacts for each publication.
Hope this helps! If it's what you're looking for, please mark this as the Verified answer.
Edit: This would also give you more flexibility if you need to add publications down the line, since it would just be a new record.
Business Applications communities