Challenge 1:
Validation rule on Lead
Country Validation Rule
Condition Formula: NOT(
OR(
Country = "US",
Country = "USA",
ISBLANK( Country )
)
)
Error Location: Field Country
State Validation Rule
Condition Formula: OR(
LEN(State) <> 2,
NOT(CONTAINS("AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:" &
"IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:" &
"NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:" &
"WA:WV:WI:WY:PR", State))
)
Error Location: Field State
Queues:
Queue Name: Rainbow Sales
Queue Name: Assembly System Sales
Assignment Rule:
Rule Name: Trailhead Assigment Rule
Challenge 2:
Account Validation Rules
Billing Country Rule
Shipping Country Rule
Billing State Rule
Shipping State Rule
Account Name Rule
Account Fields:
- Number of deals (Roll-Up Summary field): Count Opportunity. No filter criteria
- Number of won deals (Roll-Up Summary field): Count Opportunity with filter criteria as "Stage equals Closed Won"
- Last won deal date (Roll-Up Summary field): MAX(Opportunity: Close Date) with filter criteria as "Stage equals Closed Won"
- Deal win % (Formula field): Number_of_won_deals__c / Number_of_deals__c
- Total amount of won deals (Roll-Up Summary field): SUM(Opportunity: Amount) with filter criteria as "Stage equals Closed Won"
- Call for Service (Formula field): IF( DATE( YEAR(Last_won_deal_date__c)+2 , MONTH(Last_won_deal_date__c) , DAY(Last_won_deal_date__c) ) <= TODAY(), 'Yes', 'No')
Challenge 3:
Custom Object Creation
Challenge 4:
Add Stage Value:
Add Custom Field:
Add Sales Process:
Add Recordtype
Validation Rule
Challenge 5:
Approval Process:
Note: Make sure you populate manager field on your user record with some valid user. In this case make your manager as Naushi(User you created in your org). If you wont select user manager you wont be able to submit for approval.
Email Alert
Note: Make sure you add a user in email alert
Process Builder:
Opportunity object with option created and updated.
1st and 2nd node end will be changed to evaluate next criteria.
1st Node Criteria
Opportunity Account Type = customer and opportunity.account id not equal to null
1st Node Action
2nd Node Criteria
Opportunity stage = prospecting and opportunity.account id not equal to null and opportunity account type = Prospect.
Note: there will be 2 actions 1 is email same as above and second is creating task.
2nd Node Action:
3rd Node Action:
Opportunity Stage = Negotiation/Review
3rd Node Action:
2 actions are used in this node.
Challenge 6:
Flow:
- Flow must be of type Flow.
- Screen with 3 choices and store the result in screen choice fields : ProductType
- Lookup to find records in product2 with contains ProductType and store them as variables (Id + name)
- Screen to display variables
- Activate the flow
- Add the flow to the opportunity screen using app builder.
Lightning Page:
A record page on Opportunity object.
Drag and drop flow component on it and save.
Activate page.
Challenge 7
- Change field type of field "Day of the Week" on robot object to formula text and use below formula.
- CASE( MOD( Date__c - DATE(1900,1,6),7) , 0, "Saturday",1,"Sunday",2,"Monday",3,"Tuesday",4,"Wednesday",5,"Thursday",6,"Friday","")
- Go on Process builder created in step 5.(You have to clone this Process Builder in order to make changes)
- Go on 4th Node of closed Won opportunity.
- Go on action create setup record.
- Change formula of date field from [Opportunity].CloseDate + 180..
- to
- CASE(MOD([Opportunity].CloseDate + 180 - DATE(1900, 1, 7),7), 0, [Opportunity].CloseDate + 181, 6, [Opportunity].CloseDate + 182, [Opportunity].CloseDate + 180)
- Save and activate.
Happy Coding!!!
Challenge 5 Steps are incomplete , please provide it more accurate , challenge failed.
ReplyDeletePlease share error you are getting from Trailhaed and where you find steps are missing.
DeleteYes, doesn't work, stuck on step 5, getting the following error
ReplyDeleteSystem.DmlException: Insert failed. First exception on row 0; first error: CANNOT_EXECUTE_FLOW_TRIGGER. Also for first node criteria, what is the second field and value?
For 1st node second criteria checking opportunity account id not null.
ReplyDeleteMake sure you are entering right values and fields. Please share screen shot of your error
hi, thanks for sharing ur work. its really helpful for cross checking our inputs.
ReplyDeletechallange 5 doesnot work for me.
what exact field and value u use in first node.
i get the following error
Challenge Not yet complete... here's what's wrong:
There was an unexpected error in your org which is preventing this assessment check from completing: System.DmlException: Insert failed. First exception on row 0; first error: CANNOT_EXECUTE_FLOW_TRIGGER, The record couldn’t be saved because it failed to trigger a flow. A flow trigger failed to execute the flow with version ID 301f400000025Lh. Flow error messages: An unhandled fault has occurred in this flow
An unhandled fault has occurred while processing the flow. Please contact your system administrator for more information. Contact your administrator for help.: []
thanks
thanks for sharing your error. Make sure that you select created and updated on opportunity object when you create process builder. Also at the end of first node change stop to evaluate next criteria. I am updating screen shots in post.
DeleteMake sure no other process builder are active except this one.
Before checking challenge create some test records in you org and make sure that if you are using right information in fields. For example if you create opp for approval process testing make sure you enter amount greater than 100,000 and stage is prospecting. Because what i experienced is that Trailhead is testing your test data.
Email me your screen shots if you still have issue.faiza.naz90@gmail.com
"Challenge Not yet complete... here's what's wrong:
ReplyDeleteA new Opportunity with a 'Prospecting' stage for a 'Prospect' Account did not successfully create a Task for the Account owner with the Subject 'Send Marketing Materials'."
I have created the construction of the task and it is in the image. In the AssignedId field, it is referenced with [Opportunity] .OwnerId ??
Thank you
I had the same issue. Despite of all correct entries, i kept getting the same message. So, i started over again in a totally new DE org and it passed me.
Deleteno task should be assigned to account owner so it will be opportunity.Account OwnerId and make sure subject text is "Send Marketing Materials".
ReplyDeleteCreate a test record in system and check that task is getting created or not with mentioned subject. Trailhaed check task against this Send Marketing Materials subject
This comment has been removed by the author.
Deletei am getting error in step number 7 it would be really helpful if you help me out
ReplyDeleteVineet please share your error
DeleteThis comment has been removed by the author.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteStep 6 having error:
ReplyDeleteThere was an unhandled exception. Please reference ID: VRBCNAXM. Error: Faraday::ClientError. Message: MALFORMED_QUERY: When retrieving results with Metadata or FullName fields, the query qualifications must specify no more than one row for retrieval. Result size: 2
Please help me.
Dhaval,
DeleteCan you please check that you are using right column names in record Lookup. After looking at error it looks like there is some problem with query. Please share screen shots of your flow.
Hi Faiza,
ReplyDeleteThanks for sharing this article.
I am wondering where this Stage as Customer comes from in Step #5,first criteria of the Process. Since it is neither one of the standard values nor an addition they asked for as part of the module.Can you please help me understand this?
It is opportunity account type = customer.
DeleteI am having same question. the only options are customer-direct, and customer-chanel
DeleteI ran into the same issue. "Customer" wasn't an option for me. Only "Customer-Direct" and "Customer-Channel". Do we need to create another value for the Customer Type field?
DeleteCould You please Post in short What are all criteria for the nodes in the Process builder
ReplyDeleteSome screenshot are not visible.Can you upload it.
ReplyDeletewhich screen shots are not visible?
Deletepopulate manager field on your user record with some valid user. can you please tell me the steps to do this
ReplyDeleteHi i followed your steps but am getting this error can u pls suggest me where am doing wrong
ReplyDeleteChallenge Not yet complete... here's what's wrong:
An Opportunity with the Stage 'Negotiation/Review' and the Amount greater than $100,000 was not successfully submitted for approval upon creation.
For step 7, I'm getting an error on Day of the Week that says the Date__c field cannot be used in this type of formula. What to do?
ReplyDeletei am also getting the same error Date__c Field cannot be used in this type of formula
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteIs Salesforce your passion... Looking for an extra-ordinary training session, new to coding, worried about placements
ReplyDeleteWe are here to help you
"Attend the free demo (write to us on hello@diac.co.in for confirming your timing)
Refer you friends and get great discounts
Salesforce Developer and Admin Training along with Certification Training
Highly optimized and easy to learn Salesforce online training which includes Salesforce ADMIN, DEVELOPMENT, LIGHTNING, BUSINESS ANALYST.
Call us @91-9310096831
I am excited for this salesforce Online Training Hyderabad
ReplyDeleteChallenge Not yet complete... here's what's wrong:
ReplyDeletePlease check the custom fields on the Account object. Not all custom fields were found
eventhough i have created proper custom fields (6),it throws this error.
i also have same error.
DeleteThanks for sharing such a useful blog.
ReplyDeletePersonalised badges
Corporate Badges
Actually when i want to make Amount of won deals with rollback summery it s not show Amount field.In Field Aggregate section why.
ReplyDeleteI loved your post.Much thanks again. Fantastic.
ReplyDeletesalesforce training
salesforce online training
A new Opportunity with a 'Prospecting' stage for a 'Prospect' Account did not successfully create a Task for the Account owner with the Subject 'Send Marketing Materials'. can any one pls help me
ReplyDeleteA new Opportunity with a 'Prospecting' stage for a 'Prospect' Account did not successfully create a Task for the Account owner with the Subject 'Send Marketing Materials'. I have tried many solutions, including starting from scratch on new play grounds multiple times. Please help me!! Thanks
ReplyDeleteA new Opportunity with a 'Prospecting' stage for a 'Prospect' Account did not successfully create a Task for the Account owner with the Subject 'Send Marketing Materials'. help me
ReplyDeleteChallenge Not yet complete... here's what's wrong:
ReplyDeletePlease check the custom fields on the Account object. Not all custom fields were found. plshelp me i am getting these error