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 :
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

How to pre-populate a field when new record is created?

(0) ShareShare
ReportReport
Posted on by 171

Hi,

So we have an opportunity form which has a 'price list' field on it. We currently have 3 price lists and we only use one of them most of the time the other two are used from time to time. 

Is it possible to have it so that the 'price list' field is automatically populated with our main price list when someone creates a new opportunity without the user having to select it manually?

Users can then also create a quote from within the opportunity so is it possible to auto populate the price list on the quote from the opportunity?

I hope this makes sense.

Many thanks in advance. 

I have the same question (0)
  • Suggested answer
    a33ik Profile Picture
    84,331 Most Valuable Professional on at

    Hello,

    You can write a JavaScript that will do that for you. If opportunity is created during qualification of Lead you can create a real time workflow that will do that for you.

  • Verified answer
    LuHao Profile Picture
    40,892 on at

    Hi partner,

    Is it possible to have it so that the 'price list' field is automatically populated with our main price list when someone creates a new opportunity without the user having to select it manually?

    Yes, we can implement it using a business rule. The following are the specific steps.

    1) Go to Advanced Settings > Customizations > Customize the system.

    pastedimage1573453901741v1.png

    2) Expand Entities > Opportunity, click Business Rules, click New.

    pastedimage1573454030857v2.png

    3) Set the condition to Status contains data. Add a action - Set Default Value, then select Field to Price List, select Value to the main price list.

    pastedimage1573455110534v1.png    pastedimage1573454343062v4.png

    4) In the top right corner, select the form scope. Save and activate the business rule.

    pastedimage1573454475876v5.png

    The effect of this business rule is that whenever you create a new opportunity record on the selected forms, the field price list will be automatically populated with the value. When you manually change the value of the field price list or for an opportunity record that has already been created, this business rule will not work.

    Users can then also create a quote from within the opportunity so is it possible to auto populate the price list on the quote from the opportunity?

    D365 has already implemented it by default.

    When you create a quote from the opportunity, the fields of new quote maps the fields of opportunity, which means that the price list of the quote is automatically populated by the price list of the opportunity.

  • Suggested answer
    Kamilcmm Profile Picture
    171 on at

    Thanks Lu Hao

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 > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Martin Dráb Profile Picture

Martin Dráb 45 Most Valuable Professional

#2
iampranjal Profile Picture

iampranjal 36

#3
Satyam Prakash Profile Picture

Satyam Prakash 31

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans