web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
    Kamilcmm Profile Picture
    171 on at
    RE: How to pre-populate a field when new record is created?

    Thanks Lu Hao

  • Verified answer
    LuHao Profile Picture
    40,890 on at
    RE: How to pre-populate a field when new record is created?

    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
    a33ik Profile Picture
    84,331 Most Valuable Professional on at
    RE: How to pre-populate a field when new record is created?

    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.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Sahan Hasitha Profile Picture

Sahan Hasitha 394

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 123

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 103 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans