web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Discovery Document - Sale Information Gathering

(0) ShareShare
ReportReport
Posted on by 288

Hi Guys,

As with most sales cycles there comes a point when what the sales person is charging the potential client needs to be verified to ensure that a profit is being made from the sale.

We have a pretty large excel file that contains close to 100 questions that the sales person needs to gather. This is then passed to the various teams to make sure each department will make money from the sale and provide sign off for the sale to go ahead.

The excel file was given to me to add it to CRM Dynamics. I did so by creating a new entity called "Discovery Document) and added the various questions as seperate fields to the entity. i think linked this to the opportunity entity so when the sales person is working the opportunity, he/she can create a new discovery doc from within the opportunity.

My issue is this form doesnt look great, and while I have added rules around various questions, I just thing there has to be a better way of gathering this information.

One thought was to use Microsoft Forms, but I want to ensure the data is captured and housed within Dynamics in some format.

Open to suggestions and would love to hear what other solutions are out there that I could look into.

Thanks for your help

Jason

I have the same question (0)
  • Verified answer
    prt33k Profile Picture
    6,907 on at

    If you have 100 questions to be captured on a form, you can divide the question into different sections and utilize different tab to keep the information in a clean format. Having 5 tabs with 20 questions look much cleaner than one big form with 100 questions.

    Also usually questions are dependent on answers - so you may want to explore the show/hide option on questions based on answers. This approach might not look very clean on UI but maintaining information will be easier - considering search and reporting.

    Another way will be to use an editable grid - where you create one record for each question and show all 100 record in an editable grid with a questionnaire as a master entity and question as a child entity. This will require some coding too - basically creating all 100 records for each questionnaire. Though this will provide information in compact form, this might cause challenges in advance find since each question has to be linked to parent questionaire.

  • Jason Fleming Profile Picture
    288 on at

    Thanks Prateek,

    Ive utilised this in the system, have items on various tabs etc so its good to hear I wasnt that far off when using Dynamics to input this data.

    Is this the best way to gather this information do you know or would something like microsoft forms be an option. My thought is that forms is more appealing on the eye but want to make sure it all links back into Dynamics for reporting purposes.

    Thanks again.

    Jason

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 81 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 49 Most Valuable Professional

#3
#ManoVerse Profile Picture

#ManoVerse 40

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans