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 CRM (Archived)

Est. revenue field keeps unlocking on the opportunity form

(0) ShareShare
ReportReport
Posted on by

Hi

I have set a business rule to lock the est. revenue field on the form as soon as a value is entered. It locks once the value is entered and then as soon as I save the form the field unlocks. We have the est. revenue field in the main body of the form and also the header - they both link so that when one field is updated the other one is also, it is also a mandatory field.

Please can you let me know why it would unlock on saving the form?

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    gdas Profile Picture
    50,091 Moderator on at

    Hi Jess,

    Could you please share what condition you applied in the business rules?

    Try to make condition like below -

    If you want to field lock based on other field-  

    ===============================

    IF SOME FIELD CONTAINS DATA

    SET EST. REVENUE LOCK

    ELSE

    SET EST. REVENUE UNLOCK ================================

    OR

    if you want to set lock based on EST. REVENUE field

    =================================

    IF EST REVENUE CONTAINS DATA

    SET EST. REVENUE LOCK

    ELSE

    SET EST. REVENUE UNLOCK

    Make sure you set the business  rules scope All Forms.

  • Community Member Profile Picture
    on at

    Hi Goutam

    It still doesn't work. I have placed an image of the workflow below, note est. revenue = annualised revenue. Again when i add a value into one of the fields the lock sign appears, however when I go to save it, it unlocks itself.

    Thanks

    Est.-revenue-process.JPG

  • Suggested answer
    gdas Profile Picture
    50,091 Moderator on at

    Hi Jess,

    Here I have created BU on Budget Amount in opportunity entity. See its working for me  -

    My Business Rules , scope I chooses Opportunity  -

    BU3.png

    Here I am typing on new Opportunity  Form its unlock while typing   -

    5773.BU1.png

    After finish my typing I move out the cursor , fields got locked . I have not save Opportunity yet. See its still showing New Opportunity in the header.

    0042.BU2.png

    Now I am going to saved the record and see fields got locked permanently -

    BU3.png

  • Community Member Profile Picture
    on at

    Hi Goutham

    Thanks for that, my process replicates yours and my opportunity does the same as yours all the way to saving it when the opportunity saves but the field then becomes unlocked.

    Thanks for your help, however I am going to now raise this with our CRM consultants as there must be something running in the background preventing it from permanently locking.

    Thanks

  • Suggested answer
    gdas Profile Picture
    50,091 Moderator on at

    Do you  have any kind of JS call   in the form onload ?

  • Community Member Profile Picture
    on at

    No we don't have any javascript on the form - is that what you mean?

  • Suggested answer
    Community Member Profile Picture
    on at

    Hi,

    This is OOB functionality from MS. The business rule functionality will be overridden by MS behaviour. 

    You can try this in a trial account, it behaves the same way. 

    Najm

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 CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans