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 169

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. 

  • Suggested answer
    Kamilcmm Profile Picture
    169 on at
    RE: How to pre-populate a field when new record is created?

    Thanks Lu Hao

  • Verified answer
    LuHao Profile Picture
    40,878 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,325 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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,758 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans