• Joel Ramos
  • NEWBIE
  • 20 Points
  • Member since 2015

  • Chatter
    Feed
  • 0
    Best Answers
  • 1
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 10
    Replies
Dear fiends,

Do you know a free app to MAP contacts? Any suggestion?

Thanks in advance for your help.
Dear all,

I was looking into the community some solutions about how to create complex SQL Scripts.

Last week, I started in a company that they use SalesForce. So I have been learning about it.

I would like to receive some advices about create complex tables join​ (Inner Join, Left join, etc). Salesforce doesn't offer this funcionalities as SQL Server.

Thanks in advance for your support. I hope to become an expert soon and help other people.
Dear all,

I was looking into the community some solutions about how to create complex SQL Scripts.

Last week, I started in a company that they use SalesForce. So I have been learning about it.

I would like to receive some advices about create complex tables join​ (Inner Join, Left join, etc). Salesforce doesn't offer this funcionalities as SQL Server.

Thanks in advance for your support. I hope to become an expert soon and help other people.
Challenge Not yet complete... here's what's wrong:
There was an unexpected error while verifying this challenge. Usually this is due to some pre-existing configuration or code in the challenge Org. We recommend using a new Developer Edition (DE) to check this challenge. If you're using a new DE and seeing this error, please post to the developer forums and reference error id: RPNJLOPG

My org is a brand new dev org, separate from the Trailhead plaground I was using beforehand.
Any thoughts?
Trailhead processing engine is throwing following error, when I am working on "Lightning Experience Specialist" Superbadge Step #4

Challenge Not yet complete... here's what's wrong: 
The Fulfillment Creation process does not appear to be working properly. Please check that your fulfillment was created with all of the proper field value specified in the requirements.

I completed all steps according to requirement and couldnot find where is the error, Any help is highly appreciated.

My Developement work:

Object - Adventure Package
Start Process- Only when a record is created 

FIRST NODE 

Define Criteria for this Action Group 

Criteria for Executing Actions - Conditions are met 

Set Conditions:

1. [OpportunityLineItem].Oppotunity.StageName Does not equal Cancelled 
2. [OpportunityLineitem].Fulfillment_Created_c Equals False

Conditions - All of the conditions are met (AND) 

IMMEDIATE ACTIONS 

1. Create a Record 

Record Type - Fulfillment 

Set Field Values 

AdventurePackageId -  Reference -[OpportunityLineItem].Id
Adventure Package cost - Reference - [OpportunityLineItem].TotalPrice 
Adventure - Reference -  [OpportunityLineItem].Product2Id
Expedition Leader - Reference -[OpportunityLineItem].Product2.Expedition_Leader_c
Explorer - Reference - [OpportunityLineItem].Explorer_C
Fulfillment Name - Formula -[OpportunityLineItem].Product2.Name + [OpportunityLineItem].Id
Opportunity-  [OpportunityLineItem].OpportunityId
Schedule Date -Reference - [OpportunityLineItem].ServiceDate
Status- Picklist - New 


2. Update Records

Record - [OpportunityLineItem].Opportunity ID 

No criteria just update records 

Set new fields for the records you update 

Needs Insurance - Reference- [OpportunityLineItem].Product2.Needs_Insurance_c
Needs waiver - Reference -  [OpportunityLineItem].Product2.Needs_Waiver_c

3. Update Records 

Record - [OpportunityLineItem]

Criteria for Updating Records - No criteria-just update records 

Set new field values for the records you update 

Fulfilment Created = True 

Evaluate the Next Criteria 

 SECOND NODE 


EVALUATE THE NEXT CRITERIA 

Define Criteria for this Action Group 

Criteria for Executing Actions - Conditions are met 

Set Conditions:

1. [OpportunityLineItem].Explorer_c   Is Null  = True 

Conditions - All of the conditions are met (AND)

IMMEDIATE ACTIONS 

Create a Record - Task 

Set Field Values

Assigned to ID - reference- [OpportunityLineItem].Opportunity.OwnerId
Related to ID - reference -[OpportunityLineItem].Opportunity.Id
Priority - Normal 
Status - Not started 
Subject- String - Update explorer 

SCHEDULED ACTIONS 

14 days from now 

Post to Chatter 

User - Select a user from a record - [OpportunityLineItem].Opportunity.Owner.Id

Message:

{![OpportunityLineItem].Opportunity.Name}

{![OpportunityLineItem].Product2.Name}

{![OpportunityLineItem].Id}

Any pointers or Ideas?
Hi All, 

Maybe I am missing something but I am going around in cirlces with the Contacts without Hobbies report. I have: 

1. Created a custom report type to get Contacts without hobbies 
2. Created an Account Value bucket field
3. Create a % Open Opps Formula 
4. Added First Name, Last Name, Total Opp Value, Open Opp Value, Phone, Email, %Open Opps to the report 
5. Summarised by Account Value then Account 

And im still getting an error: 

Challenge Not yet complete... here's what's wrong: The 'Contacts Without Hobbies' report is not configured correctly.

I have added screenshots of all the pieces - hoping someone else has hit this issue 

User-added image

User-added image

User-added image

User-added image
Has anyone completed this trail? I am stomped on challenge number 3, regarding created the process for fulfillment. Any pointers or guidance would be appreciated.
 
Hi all,

I have a problem with this challenge : 

Write an Apex trigger that fires before records are inserted and ensures that the ShippingState field has the same value as the BillingState field.
Create an Apex class named AccountTriggerHandler that contains a public static method called CreateAccounts to accept the List of Account objects.
For each Account record, before saving, ensure that the ShippingState field has the same value as the BillingState field.
Write an Apex trigger named AccountTrigger that fires before records are inserted.
The Apex trigger must call the AccountTriggerHandler.CreateAccounts() method with the collection of new records.
Create a test class named AccountTriggerTest that inserts 200 Account records with a BillingState of CA. After the insert, test to ensure that all 200 records have a ShippingState of CA.
Before verifying this challenge, run your test class at least once using the Developer Console Run All feature.

and this is my classes :
 
public class AccountTriggerHandler {
    
    public static void CreateAccounts(List<Account> acclist){
        
        
        for(Account a:acclist){
            
            if(a.ShippingState!=a.BillingState){
                a.BillingState=a.ShippingState;
              
            }
        }
    }

}
 
trigger AccountTrigger on Account (before insert) 
{
    if (Trigger.isBefore && Trigger.isInsert) {
			AccountTriggerHandler.CreateAccounts(Trigger.new);
		}	
	}
 
@isTest
public class AccountTriggerTest {
    
    @isTest static void TestCreate200Records(){
        
        // Test Setup data
        // Create 200 new Accounts
        List<Account> accts = new List<Account>();
        for(Integer i=0; i < 200; i++) {
            Account acct = new Account(Name='Test Account ' + i, BillingState = 'CA');
            accts.add(acct);
        
            Test.startTest();
            //insert acct;
        	Test.stopTest();
            
            for (Account a:accts){
                
                System.assertEquals('CA', a.ShippingState, 'ERROR');
            }
            
    }

        
}
}
And this error :
Challenge Not yet complete... here's what's wrong: 
The 'AccountTrigger' Trigger does not appear to be working correctly. Inserted records did not have matching BillingState and ShippingState values.

Anyone can help me please??
Thanks!
 
Dear all,

I was looking into the community some solutions about how to create complex SQL Scripts.

Last week, I started in a company that they use SalesForce. So I have been learning about it.

I would like to receive some advices about create complex tables join​ (Inner Join, Left join, etc). Salesforce doesn't offer this funcionalities as SQL Server.

Thanks in advance for your support. I hope to become an expert soon and help other people.