Showing alert based on related entity's field value

(0) Share

Report

Posted on by epark06

1,328

Upon loading a Quote form, I want to show an alert based on the value of a field called "new_stage" from the related opportunity. I used CRM REST Builder for retrieveRecord and then added an if statement to check this field and show the alert. Here is the error. I'm new to javascript so I'm having trouble with my code. Any help would be appreciated.

3301.Capture.PNG

        function retrieveStage(opportunityId)
        {
            SDK.REST.retrieveRecord(
                opportunityId, 
                "Opportunity",
                "opportunity_quotes/new_stage", 'opportunity_quotes',
                function (result) {
                    var stage = result.opportunity_quotes.new_stage;
                }, function(error) {
                    Xrm.Utility.alertDialog(error.message);
                });

            if (stage != null && stage != 1) {
                alert("This is my test message.");
            }
        }

*This post is locked for comments

I have the same question (0)

All responses (20)

Answers (4)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

You should learn how to troubleshoot your JS using tools available - blogs.msdn.microsoft.com/.../debugging-custom-javascript-code-in-crm-using-browser-developer-tools

Was this reply helpful? Yes No
epark06 1,328 on at

Like (0)

Report
Thanks, I was able to show the alert properly, but the filter on stage does not work. It is always showing an alert.

function retrieveStage(opportunityId) { var opportunityID = Xrm.Page.getAttribute("opportunityid").getValue()[0].id; var EntitySchemaName = "Opportunity"; if (opportunityID != null) { SDK.REST.retrieveRecord( opportunityID, EntitySchemaName, "new_stage", null, function (result) { var stage = result.new_stage; if (stage != null && stage != 1) { alert("This is my test message."); } }, errorHandler ); } } function errorHandler(error) { writeMessage(error.message); }

Was this reply helpful? Yes No
Suggested answer

Mahendar Pal 45,095 on at

Like (0)

Report

Hello,

You may want to test your logic first using Rest builder if code/logic working there you can use it in your js web resource:

github.com/.../CRMRESTBuilder

Was this reply helpful? Yes No
Abby Kong 6 on at

Like (0)

Report

Hi LearningCRM,

what is the field type of new_stage?

Regards,

Abby

Was this reply helpful? Yes No
epark06 1,328 on at

Like (0)

Report
Hi Abby, the field is an option set. Here is my latest attempt. I am still getting the alert every time on quote onload. I only want this alert on values 2 and 3. I also tried adding "Xrm.Page.getAttribute("new_stage").getValue();" but this did not work.

function retrieveStage(opportunityId) { var opportunityID = Xrm.Page.getAttribute("opportunityid").getValue()[0].id; var EntitySchemaName = "Opportunity"; if (opportunityID != null) { SDK.REST.retrieveRecord( opportunityID, EntitySchemaName, "new_stage", null, checkstage, errorHandler ); } } function checkstage(opportunity) { var stage = opportunity.new_stage; if (stage != null && stage != 1) { alert("This is my test message."); } } function errorHandler(error) { alert(error.message); }

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

Can you please provide a screenshot from Opportunity attributes that contains new_stage field. You're using 2011 odata and in this case new_stage and new_Stage are different fields. Can you please provide that screenshot?

Was this reply helpful? Yes No
epark06 1,328 on at

Like (0)

Report

[quote user="Andrew Butenko"]

Hello,

Can you please provide a screenshot from Opportunity attributes that contains new_stage field. You're using 2011 odata and in this case new_stage and new_Stage are different fields. Can you please provide that screenshot?

[/quote]

The name/schema name is all lowercase. None = 1, Partial = 2, All = 3.

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

You gave me wrong screenshot. What I wanted to see is following:

I understand that this is standard attributes but it could be the case for your custom. That's why I asked for "attributes" and not attribute. I believe it could be unclear :)

Was this reply helpful? Yes No
epark06 1,328 on at

Like (0)

Report

Thanks, here it is. I will also try to filter on a different field to see if there's something wrong with the field...

Was this reply helpful? Yes No
epark06 1,328 on at

Like (0)

Report

Same behavior even with testing on another field.

When I use "if (stage != null)", it will fire alert every time.

When I use "if (stage == 2)", it never fires.

When I use "if (stage = 2)", it will fire alert every time.

Was this reply helpful? Yes No