Skip to main content Salesforce and Tableau exam registrations are now closed through July 21st. Learn more about the new Salesforce certification experience coming soon.

Feed

Connect with fellow Trailblazers. Ask and answer questions to build your skills and network.

Hello - I am looking to create a flow that will check against an account id and object id to see if the account already exists in a custom object when importing data via data loader. 

 

For example, in a custom object "account role" which is a related list under another custom object there is an existing account that is listed as "buy-side".  Weekly I import new account roles using data loader and there could be in the list the same account already listed as buy-side but in my latest import it is listed as "user."  I want to prevent creating a new role for the same account so the flow would need to review for existing account id's within the same object id  

 

Flow for data loader import to prevent duplicates on custom object

 

 

 

#Flow

9 answers
0/9000
1 answer
  1. Today, 4:40 PM

    You can't download it from Trailhead, but a copy of your certification is sent to your individual email. Could you check your email and search for the certification you want to download?

0/9000

Having conversations with clients, I have difficulties explaining and making it tangible for non-tech and business related positions contacts. I always take examples and make sure its understood but i feel like being creative and having it all explained in one or two slides. 

Goal : explaining how credits are consumed without talking about rows. ;) 

 

Thanks

0/9000

My customer is currently using our live chat embedded in a custom app. They are moving to SFS mobile and require the ability to have real time chat with the different internal business groups that are existing agents. Has anyone done this? The field technicians often need questions answered while onsite and they do not want them to call. 

7 answers
0/9000

I use Service Cloud Voice and Amazon Connect. Once a call is received, a VoiceCall is created in Salesforce, which triggers creation of the PendingServiceRouting record with the RoutingModel of ExternalRouting. However, the call is not routed to available agents, so the caller is always holding on the line. 

What I checked so far:

  1. Agents got a contact center group assigned
  2. The contact center group has the queue mapped with it
  3. The VoiceCall record is assigned to that Queue
  4. The Queue is linked with the Routing Configuration of type External Routing
  5. The presence status of the agents is linked with the Phone channel
  6. The Connection Status component shows that the agent is available (screenshot)

What might be the issue?

0/9000

I cleared the JS exam on 12-12-2022, and I didn't receive the JavaScript Developer1 certificate yet in the mail, I have got exam result as passed with all the details. I raised the support ticket with case id : #00834956 as well but didn't receive the response yet.I've completed the LWC super badge also.

 

Not sure if this the right place to ask about it.

 

#Certifications #Javascript #Trailhead #Trailhead Superbadges

11 answers
0/9000
Hey guys , I am beginner to salesforce, my reqirement is I have to find the Second Maximum amount of oppurtunity using Soql query,, so what will be the query ??
4 answers
  1. Aug 12, 2019, 9:33 AM
    Hi,

    You can achieve this with order by, limit and offset.

     

    List<Opportunity> secondHighestAmount = [SELECT Id, Name, Amount FROM Opportunity WHERE <your_where_clause> ORDER BY Amount DESC NULLS LAST LIMIT 1 OFFSET 1];

    if(secondHighestAmount.size() == 1) {

    Opportunity secondHighestOpp = secondHighestAmount.get(0);

    //Do something with secondHighestOpp

    }

    Explanation:

    • ORDER BY Amount DESC NULLS LAST (get the opportunities in the amount order from highest to lowest)
    • LIMIT 1 (get only one record)
    • OFFSET 1 (skip the highest amount opportunity)

    Regards,

    MKR
0/9000
1 answer
0/9000