• 12255 Points
  • Member since 

  • Chatter
  • 400
    Best Answers
  • 0
    Likes Received
  • 13
    Likes Given
  • 0
  • 3773
I have a master Data Extension and need to segment it for 30+ countries. The DE has a column Country with country codes. I would like to create filters and resulting Data Extensions using...an automated way. I thought I could use ServerSide JavaScript (as this is the only programming language I am comfortable with). I hope to complete it using a loop and for example an object with Country: CountryCode value pairs. I'd rather not use anything more complex (such as REST API, SOAP, etc) but a Script activity. Can someone help me get started with examples? (I found documentation so I would appreciate some code samples). Thank you in advance!
I have a report and I need to schedule it run every quarter in a year, how can this be done?
Please help
Hello frnds, we would like to integrate some of the dates from MS Project online with salesforce, so that if dates are entered once , they should be synced in both
Hello frnds,
we would like to integrate some of the dates from MS Project online with salesforce, so that if dates are entered once , they should be synced in both.
Can some one guide me on integration of MS Project online with salesforce
Hi Team,

I'm encountering an error while following the Gus at Work module. I'm being prompted to log in to AppExchange when trying to install Agile Accelerator. However, the authentication page leads to a "URL no longer exists" error

User-added image

User-added image

User-added image
I am trying to create New Account, Then Contact and Opportunity that is assigned to that account . but use Post method, so have them all in one page. I dont wanna create any class, I know I can do Account using method as it follows, however I am not sure if I can do the samething to create new contact and opportunity since I need account ID. Ill put fields on the page to ask user to enter new information
function createSobjectRecord() {
var accountInfo = {
    "Name": "Testing Jquery with Rest"
var accountInfoJson = JSON.stringify(accountInfo);
    type: "POST",
    url: "/services/data/v35.0/sobjects/Account",
    headers: {
        'Authorization': "OAuth " + sessionId,
        'Content-Type': 'application/json'
    crossDomain: true,
    data: JSON.stringify(accountInfo),
    dataType: 'json',
    success: function(responseData, status, xhr) {
    error: function(request, status, error) {


I am facing the below issue, can any one suggest how to solve this issue.User-added image I tried this by create an Event. 

I have created the solution for the Utility bar twice, once in the usual trailhead, and then another time in a new Dev org. I still get the same error


"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: FHFAMTYG"

I am trying to create a change password component using the standard site.changePassword() function . Its is not working as expected as the return type of site.changepassword is of a page reference and the pagereference methods are not supported in @AuraEnabled annotation. Please help me with some sample example for change password custom component
Hi All,
I need help on the chatter group issue.
I have created a chatter group in partner portal but I can't see the group in my internal org even every post is not feeded in internal chatter feed. Should I do anything for getting this?
I hope someone can assist me to do this. 

Challenge Not yet complete... here's what's wrong: 
The campingList JavaScript controller doesn't appear to be checking if form fields are valid
  • February 21, 2018
  • Like
  • 0
cómo llego a la página donde explica el camino a seguir para dar el exámen de "administrador de salesforce"?
Trailhead access via my mobile (iPhone X IOS 11.2.5) suddenly stopped working - worked last night but not at all today.
 'Safari cannot open the page because it could not establish a secure connection to the server.'
Any ideas?
I am trying to complete Challenge # 8 and I keep getting this error (last letters change each time)

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: GDVYNLBX

I have created a new Trailhead Playground and setup knowledge again and get the exact same issue. This is driving me nuts - please can anyone assist?
    Hi Everyone,
             I have a custon object called Test__c.I'm trying to display Test__c object records into two sections
             in a visualforce based on a field sepeartion.but how to read the fields from cotroller extension.
             vf page
             <apex:page standardController="Test__c" extensions="DivedeRecordsList" recordSetVar="test" >
                <apex:sectionHeader title="Test Records List" />
                <apex:form >   

                 <apex:pageBlock Title="Test Records completed">
                  <apex:pageBlockTable value="{!test}" var="w" >                     
                    <apex:column value="{!w.first}" />
                    <apex:column value="{!w.Second}" />
                    <apex:column value="{!w.third}" />
                    <apex:column value="{!w.Expired__c}" />
               <apex:pageBlock Title="New Test Records">  
                <apex:pageBlockTable value="{!test}" var="w" >     
                    <apex:column value="{!w.first}" />
                    <apex:column value="{!w.Second}" />
                    <apex:column value="{!w.third}" />    
                    <apex:column value="{!w.Expired__c}" />

            Apex class

            public class DivedeRecordsList {
                public Test__c testrecords{get;set;}
                List<Test__c> lst{get;set;}
                List<Test__c> lst1{get;set;}
                public DivedeWebinarsList(ApexPages.StandardController controller){
                     testrecords = (Test__c)controller.getRecord();

                public  List<Test__c> upcomingRecords(){
                    List<Test__c> lst = [select id,Name,first,second,third from Test__c where Expired__c = 'false'];
                    return lst;
                public  List<Test__c> completedRecords(){
                    List<Test__c> lst = [select id,Name,first,second,third from Test__c where Expired__c = 'true'];
                    return lst;

            Thanks In advance

I'm trying to this trailhead.
■Use Future Methods

I wrote berow code for test class,
but the 'AccountProcessor' class did not achieve 100% code coverage via your test methods.
public class AccountProcessorTest {
    public static void AccountProcessorTest(){
        List<Account> accounts = [Select Id, Name from Account];
        List<Id> ids = new List<Id>();
        for(account a : accounts){
So I tried to debug with checkpoint,
It seemed that 'aid' contains the Account record itself, not it's id

User-added image

How can I set Account.id to List<id>?

Thak you.
I am trying to PUT a json file from Salesforce to Amazon S3 Bucket using Rest Callout. But I am getting an exception as :
System.CalloutException: Unexpected end of file from server
Can anyone suggest me the issue.

My Code :
public class ProductAmazon_RestClass {
    public void ProductAmazon_RestMethod(string folderName){
        string binaryString = ProductAmazonIntegration.ProductAmazonIntegration();
        String key='******************************';
        String secret='******************************';
        String formattedDateString= Datetime.now().formatGMT('EEE,   dd MMM yyyy HH:mm:ss z');
        String bucketname = 'myBucketName';
        String host = 's3-website-us-east-1.amazonaws.com';
        String method = 'PUT';
        String filename = 'Product/Product.json';
        //Request starts
        HttpRequest req = new HttpRequest();
        req.setEndpoint('https://' + bucketname + '.' + host + '/' + bucketname + '/' + filename);
        req.setHeader('Host', bucketname + '.' + host);
        req.setHeader('Content-Length', string.valueOf(binaryString.length()));
        req.setHeader('Content-Encoding', 'UTF-8');
        req.setHeader('Content-Type', 'application/json');        
        req.setHeader('Date', formattedDateString);
        req.setHeader('ACL', 'public-read-write');
        String stringToSign = 'PUT\n\n' + 'application/json' + '\n' + '/' + bucketname + '/' + filename;
        String encodedStringToSign = EncodingUtil.urlEncode(stringToSign,'UTF-8'); 
        String signed = createSignature(stringToSign,secret);
        String authHeader = 'AWS' + ' ' + key + ':' + signed;
        Http http = new Http();
        try {
            //Execute web service call
            HTTPResponse res = http.send(req);
            System.debug('RESPONSE STRING: ' + res.toString());
            System.debug('RESPONSE STATUS: '+res.getStatus());
            System.debug('STATUS_CODE: '+res.getStatusCode());
        } catch(System.CalloutException ae) {
            system.debug('AWS Service Callout Exception: ' + ae);
    public string createSignature(string canonicalBuffer,String secret){
        string sig;
        Blob mac = Crypto.generateMac('HMACSHA1', blob.valueof(canonicalBuffer),blob.valueof(secret));
        sig = EncodingUtil.base64Encode(mac);        
        return sig;

I am trying to get through a TrailHead module "AppExchange App Development" and within the unit "Package an AppExchange App ",

I tried completing the Hands-on challenge as instructed and I am very sure that I followed every word as instructed.  I still keep getting the below error for reasons I dont understand.

Here is the error:
"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: ZMFNEVBY"

Any help is greatly appreciated! Thank you in advance.
I am stuck on Challenge#1 of Reports & Dashboards Specialist Superbadge.
One of the very first requirement is to import data in to salesforce.
I have this file that I need to import. It has Account Name filed. I am trying to do mapping through Dataloader I dnt see Account Name field for mapping. 
User-added image

User-added image


Hi! After going through most of the "Build a lemonade stand" app, ive finally reached the last challenge,
however, while trying to verify the challenge, I get the following error:
 "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: UPETIEOU"

I think im on a brand new org, and it looks like the challenge is done correctly, so im not sure why
this is broken. Thank you for your help :)
I am having one Set having data type as String and One List of type 'GroupMember'.

I want to type cast it . Tell me way to type cast it .

Set<String> mergelist=new Set<String>();

List<GroupMember>  newGroupMember = new List<GroupMember>(); 

I want to insert mergelist data into newGroupMember list.
I have a custom object named "Listing".


1) Status (New, Pending, Booked) - Picklist
2) Booking Number - Text Field

We want to autogenerate Booking Number whenever status is changed to Booked.
Booking Number should be in sequence (Alphanumeric i.e. BN-000091).
It should be generate only for booked status.

How can we do this ?

I have a case where the customer wants Submit for Approval button on Approval History related list to be removed.
Is that possible and if yes - how ?
User-added image
Thanks in advance
 I am trying to take 500 points challenge but the take challenge button is disabled, for 100/200 points am able to take but only for 400/500 the button gets disabled and am not able to complete the module. Happens for all the modules with 500 point. any module I chose it happens for all challenges with 500 points. Am also able to login to devoloper part but only challenge am unable to take.
write a query to get parent with max no of child records?
how to insert multiple opportunities for a single account ?
Can anyone help me through this using apex
Thanks in Advance
Hi All,
Recently, we had a requirement for Integrating Salesforce and Marketo with Gigya (Customer Identity Mangement tool).
Could anyone please share something on this and how it can be achieved. 

Hi all,I want to integrate share point with sfdc to upload file from sfdc to sharepoint and I have sharepoint account just what else we need and how to do it i have heard abt Microsoft azure so do i need account for it?plaz help me out!
Hi I was attending trailhead module"Lightning Components Basics-
Before You Start ".I tried to change the "MyDomain" but on Salesforce classic mode.But after chnaging the domain and save it i am unable to login from almost 2 days now login is not happening with the new Url.
note:-I was using gmail account to login to trailhead,Dont have a specific sfdc user login.

Kindly reply any one have solution.
Thank you
I have an college assignment/project to create an app "A resume management and recruitment system". (I am still learning to use salesforce)
Modules I should work on for this:
Module1: Insert and Search Resumes.
Module2: Manage Positions.
Module3: Manage Resumes
Module4: Generate Reports and Design Dashboard
I don't necessarily need to create visualforce pages for everything so I just created objects for Resume and Positions and will run with that. But that way I am not able to add the option to upload under Resume object because I use standardController="Document" in the visualforce page code for uploading files (code in pastebin link). Also, how do I make a page similar to what is shown in "Shortlisting" (image in imgur link).
Here's what it should sort of look like but doesn't need to be exactly the same. https://imgur.com/a/Xg7TP
Some code I have tried: https://pastebin.com/PrByfnHJ
Let me know if there's a better place to get some help with all this. Any links for tips on how to proceed will be very helpful
I have two sets of data about 6000 accounts - one in salesforce and an exact copy in ZOHO. What is the best method by which I can connect both so that any update made in ZOHO is updated in Salesforce and vice versa?
Hello everyone, 

I have a list of fields to display in my visalforce page, the request is to display other fields by clicking on the name of one of the first fields.
Any Ideas Please.
  • March 21, 2018
  • Like
  • 0
i have a site called abc contains a form . after user fills the form and submit he will enter into the new page with success message.
Now the problem is if he press back button in the browser it will move to the form again with all enterd values.if he re submite the page Duplicate record is getting created. Please help me out how to avoid entry through back button.
Any once worked in New survry functionality which is realeased in Spring 18. i have created the template and when we are sending survey link to to community user its should attach to the perticular contact record, how to do this ? 
Any help on this is much appreciated 
I am trying to complete the last challenge of the Lightning App Builder module and cannot install the unmanaged package.  I followed instructions in the troubleshooting guide, but keep getting the following message: "Insufficient Privileges: You do not have the level access necessary to perform the operation you requested." Is there a way to get around this to complete the module? 
Hi, can anyone kindly help with amending the below code so that it can convert the Lead to an existing Contact (and contact's Account) by using the specified Exisitng Contact ID which would be stored on the same Lead record in a custom field.

I'm hoping to trigger this Apex Class from Process Builder (or Flows), but I believe the only piece I'm missing and struggling with is knowing how to write the code so that I can pass the contact id I want it to convert to.

Thank you kindly in advance,

Public class AutoConvertLeads
    public static void LeadAssign(List<Id> LeadIds)
        LeadStatus CLeadStatus= [SELECT Id, MasterLabel FROM LeadStatus WHERE IsConverted=true Limit 1];
        List<Database.LeadConvert> MassLeadconvert = new List<Database.LeadConvert>();
        for(id currentlead: LeadIds){
                Database.LeadConvert Leadconvert = new Database.LeadConvert();
                Leadconvert.setDoNotCreateOpportunity(TRUE); //Remove this line if you want to create an opportunity from Lead Conversion 
        if (!MassLeadconvert.isEmpty()) {
            List<Database.LeadConvertResult> lcr = Database.convertLead(MassLeadconvert);

I think I need to get this type of ttext into the code but not confident at all how to do it;

- 'Leadconvert.setContactId(contactId)'
- 'Leadconvert.setAccountId(accountId)' or better still may be something like 'Leadconvert.setAccountId(contactId.accountId)' (my logic being to avoid errors where the account id for the contact possibly changes over time)
Hi I am creating object specific quick actions. All funcitonality works, however I am getting an error when checking my challenge.  When I check the object, all looks good, including name, layout, quick action, and functionality on my mobile device.  Are there additional reference materials I can check, or is tthere a way to  rollback my work to redo this challenge.  Thank you!
My Vetforce trailhead won't update my data managent module upon completion.  I have attempted to re-complete this module multiple times and my trailhead fails to refresh.  This is preventing me from completing my administrator training.  Please help with this.

I have a Device object who have an option to add multi-instances of Case object.
Now, I want to add a counter to count the instances of cases in each device. 
I want it to count retroactivity.

Thank you very much!

There is a online software called Mindbody. Mindbody provide some API's to fetch the data from the Mindbody.

I also want to do the same in salesforce. I want to fetch the client's data by hitting the API using the Apex class.

Can anyone done the Mindbody and salesforce integration before.

Can anyone help me I have not worked on the Integration before. 

Challenge Not yet complete... here's what's wrong: 
The Account object does not have the correct values for the 'type' field,

Can comebody help me on this issue please!! I tried everything possible
I want to achieve one requirement that when Manager A logs in to his Org, then he should see only employees under him not under any other manager using lookup. Can someone help me to achieve it?
Trying to test the App in Salesforce1 - When I click "App Launcher" and then Salesforce.com I get this error message: Python 2.5 is no longer available. Please refer to https://goo.gl/aESk5L for more information. 

Please help so I can move forward. Thank you!
I would like to connect my org to the external data using OData 4.0. I have been configured the External Data Source and automatically create External Object.
But there is a problem when creating record in the external object. After save button clicked, then error dialog appears, see image below:
User-added image
Actually the data that I inserted was successfully created, but I still meet this error.
FYI, I have been configured the primary key on OData configuration and MySQL database.
I have a custom object called 'Class_Allocation__c' and have a lookup field on this object called 'Related_Contact__c.  I need expert help to write a trigger on Class_Allocation__c to auto copy the contact Id into this field based on 'Student__Name__c' field on Class_Allocation__C and Student_id_from_Student_object__c (on contact)
  • September 15, 2017
  • Like
  • 1
Hello All,
I need to be able to update an Azure database from Salesforce.  Mainly for Cases and Lawyers, when cases or lawyers get updated I need to update the Azure DB as well.
I have seen the examples that talk about Azure to Salesforce, but I have not seen anything talking about Salesforce to Azure.
I have looked at both the Salesforce WCF and RestAPI https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/
But again these go from Azure to Salesforce.

Is it possible to go the other way?  What would be the best approch to this as I have seen many differnt approches to connecting.
We don't want any syncing of data, just to make a .NET call when Salesforce records get updates ect.. to update our Azure DB.
I am a brand new admin and I know nothing about the admin side of SalesForce.  Can someone explain to me how I can check if my org is using a single sign-on or HTTPS call outs?   I need to know if the default certificate retirement on 8/7/17 will affect my org before 8/7/17.   I've been reading about it but none of it makes sense to me.
when I was installing an app from appexchange, I got the oauth error. My account is the type of 30-day-free. 

Error code : 1800。

who can help me?
  • May 17, 2017
  • Like
  • 1
I have following scenario and want to set up partner community license.

1. Have profile Customer service rep.
2. He has access to only Order object.

i know we need to set Account as partner and then contacts need to be enabled as partner and then create user and assign the partner community profile.
But if i have no.of users and want to assign them Partner Community License  and Customer service repprofile, how i should proceed to implement this?

Could you please suggest?
I found an error in a Trailhead, thought I'd help anyone else with the same problem. While trying to solve the Using Events to Add Markers to the Map section of the Build an Account Geolocation App trailhead I kept receiving an error about a null value. Debugging the code I found that the map variable in AccountMapController.js was null. This is because the accounts were loading faster than the Leaflet.js libraries. To get around this I changed the accountsLoaded function to recursively check if the map existed only add markers once the map was an object:

   if(component.get("v.map") != null){
            var map = component.get("v.map");

            var accounts = event.getParam("accounts");
            for (var i=0; i<accounts.length; i++) {
                var account = accounts[i];
                var latLng = [account.Location__Latitude__s, account.Location__Longitude__s];
                L.marker(latLng, {account: account}).addTo(map);
            accountsLoaded(component, event, null); 


I am creating my first visualforce email. 

I am trying to list the Opportuntiy; owner, contact roles, and  opportuntiy team all on email template. I been able to figure out how to add the opportunity contact roles but I can't figure out how to add the Opportuntiy Owner and Opportuntiy team through the email code. 

Please see my visualforce code below. Thanks in Advance! 

<messaging:emailTemplate subject="Testing VF" recipientType="User" relatedToType="Opportunity">
<messaging:plainTextEmailBody >
This is testing the text section....
Opportunity Name: {!Relatedto.name}
Account: {!Relatedto.account.name}
Amount: {!Relatedto.amount}
Contact Roles for this Opportunity:
<apex:repeat value="{!RelatedTo.OpportunityContactRoles}" var="ContactRole">
{!ContactRole.Contact.Name} {!ContactRole.Contact.Email}
<apex:repeat var="team" value="{!relatedTo.opportunityteammembers}">


Hello Experts,

I have created excel workbook with help of VF page & XML Spreadsheet Reference. However I am not able to insert the company's logo in the first sheet. Can any one please suggest me how to insert an image in the sheet. Below is the VF code :

<apex:page controller="XYZ_controller" sidebar="false" showHeader="false"  contentType="application/vnd.ms-excel#{!object.Name__c}_Bid_Preview.xls" cache="true" action="{!changeProposalStatus}">
    <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
        <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
        <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">

<Worksheet ss:Name="Cover">
  <Column ss:Width="70" ss:StyleId="s_plain"/>
  <Column ss:Width="100" ss:StyleId="s_plain"/>
  <Column ss:Width="100" ss:StyleId="s_plain"/>
  <Column ss:Width="250" ss:StyleId="s_plain"/>

        <Cell  ss:Index="2" ss:StyleID="s9_confidential" ss:MergeAcross="3"><Data ss:Type="String">CONFIDENTIAL</Data></Cell>
<I NEED TO INSERT AN IMAGE HERE i.e COMPANY'S LOGO> (For testing, any logo will do)

<Row ss:AutoFitHeight="1">
        <Cell  ss:Index="2" ss:StyleID="s_cover_heading" ss:MergeAcross="3"><Data ss:Type="String">Test Data</Data></Cell>
        <Cell  ss:Index="2" ss:StyleID="s_cover_heading_lab" ss:MergeAcross="3"><Data ss:Type="String">Test Data</Data></Cell>
I request your swift support and help on this. Your efforts would be greatly appreciated. Thanks in advance...!!
  • July 21, 2016
  • Like
  • 1