• Ajay L
  • NEWBIE
  • 89 Points
  • Member since 2014

  • Chatter
    Feed
  • 2
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 15
    Questions
  • 30
    Replies
Hello,

I am trying to modify this existing trigger that prevents someone from deleting an attachment to only fire if the associated parent opportunity stage is Closed Won - 
 
trigger AttachmentSaver on Attachment (after delete) {
  // Get the current user's profile name
  Profile prof = [select Name from Profile where Id = :UserInfo.getProfileId() ];
  
  // If current user is not a System Administrator, do not allow Attachments to be deleted
  if (!'System Administrator'.equalsIgnoreCase(prof.Name)) {
    for (Attachment a : Trigger.old) {
      a.addError('Unable to delete attachments.');
    }  
  }
}

What do I need to add in here that would only fire this error for Closed Won Opps?

Thank you,
Oksana​
Is there any limitation that dependent picklist value is not being populated using defaultValues in force:createRecord?
createINTRecord:
function(component, event, helper) { 
var iws = component.get("v.parentIWS"); 
console.log('IWS details Specialty__c: '+ iws.Specialty__c); 
var createRecordEvent = $A.get("e.force:createRecord"); 
createRecordEvent.setParams({ 
"entityApiName": 'Apprenticeship__c', 
"recordTypeId": null, 
'defaultFieldValues': { 
'Opportunity__c': iws.Opportunity__c, 
'InternshipWorkSite__c': iws.Id, 
'Track__c': iws.TrackFamily__c, // Controlling Field 
'Job_Category__c': iws.Specialty__c, // Dependent Field 
'Employer__c' : iws.Account__c, 
'Cohort_Sem__c' : iws.Opportunity__r.Cohort_Sem__c, 
'Start_Date__c' : iws.InternshipStartDate__c, 
'Site_Location__c' : iws.Site_Located__c, 
'Internship_Cluster__c': '--None--' } 
}); 
createRecordEvent.fire(); }


Issue:
'Track__c'-----> // Controlling Field
       'Job_Category__c'---> // Dependent Field of Track__c
                'Internship_Cluster__c'---> //Dependent Field of Job_Category__c

I am able to assign the value to only top level picklist, but not dependent fields. I can see the value printing in the console and also value available in the picklist. However the value is not populated in the form.

User-added image
  • March 21, 2018
  • Like
  • 0
Original question:
have created custom Related list button using a VF page to created child record with default values. However, as I click the button it is opening in a new window and parent record detail page is missing in the background. Even if I cancel the record it shows a blank page instead of record detail page.

I am using sforce.connection.createRecord() to cretae the record.

Parent Rcord:
User-added image

New Opportunity:
User-added image
  • December 27, 2017
  • Like
  • 0
I am trying to create a related list button with default values with sforce.one, however when I try to click Save button I am getting this error "Review the errors on this page". But no errors listed, and all the required fields have been filled properly.

VF Page:

<apex:page standardController="Opportunity" recordSetVar="opps"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.0/jquery.min.js"></script> <apex:includeScript value="/soap/ajax/28.0/connection.js"/> <apex:includeScript value="/soap/ajax/28.0/apex.js"/> <script type="text/javascript"> sforce.connection.sessionId = "{!$Api.Session_ID}"; $( window ).ready(function() { createOpportunity(); }); var recordId = '{!$CurrentPage.parameters.Id}'; var OBJECT_NAME_HERE ='Opportunity'; var RECORDTYPE_NAME_HERE ='Internship Seats'; var url ='/006/e?retURL=%2F&' try{ //Query the record type var RecordTypeIds = sforce.connection.query("SELECT Id FROM RecordType WHERE SObjectType='" + OBJECT_NAME_HERE + "' AND Name='" + RECORDTYPE_NAME_HERE + "' LIMIT 1"); var rtTypes= RecordTypeIds.getArray("records"); var RecordTypeId = rtTypes[0].Id; //Query the parent record var cons = sforce.connection.query("SELECT Id,Name FROM Account WHERE Id = '" + recordId + "'"); var stats= cons.getArray("records"); //Internship Seats Opportunity url +='RecordType='+RecordTypeId; url +='&CF00N50000001oGFd='+stats[0].Name; url +='&CF00N50000001oGFd_lkid='+stats[0].Id; url +='&opp11=Open'; //Default values var defaultValues = { 'AccountId':stats[0].Id, 'Corporate_Account__c' : stats[0].Id, 'StageName':'Open', 'retURL':'/006', 'nooverride':'1' } } catch(e){ alert('An Error has Occured. Error:' +e); } function createOpportunity(){ if( (typeof sforce != 'undefined') && sforce && (!!sforce.one) ) { sforce.one.createRecord('Opportunity',RecordTypeId,defaultValues); }else{ window.location='{!URLFOR($Action.Opportunity.New, null, [RecordType='+RecordTypeId+',save=1], true)}'; } } </script> </apex:page>

User-added image
  • December 18, 2017
  • Like
  • 0

I am trying to create custom Related List button using Lightning Out VF page. The component loads fine however, when I click on the button it is opening in a new tab, Is there a way I can show it on the same page in a MODEL?User-added image
 
<!-- Load Lightning dependencies -->
<apex:includeLightning />

<div class="slds">
    <!-- Target div for the Lightning component -->
    <div id="customObjectEdit"></div>
</div>

<script>
var recordId = '{!lId}';

$Lightning.use("c:createLtgOutApp", function() {
    var attributes = {
        recordId: recordId
    };

    var targetElementId = 'customObjectEdit';

    $Lightning.createComponent('c:createLtgOut', attributes, targetElementId,
                               function(cmp) {
                                   // At this point the component has been created and loaded
                               });
});
</script>

 
  • August 23, 2017
  • Like
  • 0
Superbadge
Process Automation Specialist> Step 2

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

I am really stuck here.

Any help please.?

Reagrds,
Ajay
  • August 03, 2017
  • Like
  • 0
Superbadge
Lightning Experience Specialist

Automate the creation of fulfillments

error:
Challenge Not yet complete... here's what's wrong: 
The Fulfillment Creation process does not appear to be working properly. Please check that your task was created with all of the field values set appropriately.

What am I missing here?

User-added image

Regards,
Ajay
  • August 01, 2017
  • Like
  • 0
Hi,

I am getting this error on Automate Your Business Processes>>Create a Satisfaction Survey
>>Add a Screen for Thanking the Customer
 

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

Everuthing is done as mentioned in the trailhead, but still I am getting this error. any reason?

Regards,
Ajay
hi,

I am working on a requirement to integrate Salesforce with LinkedIn. The requirement to send the contact email in the request and get the basic profile data using REST API?

Regards,
Ajay
  • September 01, 2016
  • Like
  • 0
Hi,

I have a complex requirement to build a report. Hoever I noticed that it is not possible with standard report. Can you help me the best way to create this complex report using VF page.

User-added image

Left side colum has Field Labels. and we need to caluculate each field value Percentage based on the value selected on the total reocrds which users attened that specific field.

Thanks in advance.
Reagrds,
Ajay
  • August 29, 2016
  • Like
  • 0
Hello,

Can anyone help me on this validation rule causing CPU timeouts. When load the data through dataloader this validation is causing the CPU time out error, if I deactivate this rule and the load is success with no CPU timouts. I tried multiple times and noticed the same results. Is there a betterway we can write this validation rule?

AND ( 
OR($Profile.Name <> "API Integration", $Profile.Name <> "USA Sales Planning Rep",$Profile.Name <> "USA Sales Planning Executive",$Profile.Name <> "USA Sales Planning Mgr",$Profile.Name <> "API Eloqua" ), 
OR( 
ISBLANK( BillingCity ), 
ISBLANK( BillingStreet ), 
ISBLANK( BillingCountry), 
ISBLANK( BillingState), 
ISBLANK( BillingPostalCode ) 

)
Hi,

I have this vf page and trying to make sortable table. It is working on laptop browser. However when I launch it in iPhone the sorable is not working. the rows are not moving. I also used jQuery touch punch.

<apex:page >
    <html lang="en">
  <head>
      <meta charset="utf-8"/>

    <title>jQuery UI Touch Punch - Mobile Device Touch Event Support for jQuery UI</title>

      <meta name="viewport" content="width=device-width, initial-scale=1.0"/>
      <meta name="description" content=""/>
      <meta name="author" content=""/>

    <!--[if lt IE 9]>
    <script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/jqueryui-touch-punch/0.2.2/jquery.ui.touch-punch.min.js"></script>    
<script
type="text/javascript"
charset="utf8"
src="https://cdnjs.cloudflare.com/ajax/libs/jqueryui-touch-punch/0.2.2/jquery.ui.touch-punch.min.js"
>
</script>
    <![endif]-->

        <link rel="shortcut icon" href="/ico/favicon.ico"/>
            <link rel="apple-touch-icon-precomposed" sizes="114x114" href="/ico/apple-touch-icon-114-precomposed.png"/>
                <link rel="apple-touch-icon-precomposed" sizes="72x72" href="/ico/apple-touch-icon-72-precomposed.png"/>
                    <link rel="apple-touch-icon-precomposed" href="/ico/apple-touch-icon-57-precomposed.png"/>

    
    <style>body { background:#fff; font-family:"Helvetica Neue",Helvetica,Arial,sans-serif; }</style>

    <apex:stylesheet value="{!URLFOR($Resource.style, 'style.css')}"/>
    <apex:stylesheet value="{!URLFOR($Resource.testResources, 'normalize.css')}"/>
    <apex:includeScript value="{!URLFOR($Resource.testResources, 'jquery-1.8.2.js')}"/>
    <apex:includeScript value="{!URLFOR($Resource.testResources, 'jquery-ui.js')}"/> 
     <apex:includeScript value="{!URLFOR($Resource.jResources, 'jquery.min.js')}"/> 
     <apex:includeScript value="{!URLFOR($Resource.jResources, 'jquery-ui.min.js')}"/> 
     <apex:includeScript value="{!URLFOR($Resource.jResources, 'jquery.ui.touch-punch.min.js')}"/> 
    <apex:stylesheet value="{!URLFOR($Resource.jResources, 'jquery.ui.all.css')}"/>
    <apex:stylesheet value="{!URLFOR($Resource.jResources, 'jquery-ui-1.10.2.custom.min.css')}"/>
  </head>
  <body>

    <div class="container">
      

      <style>
        #sortable { list-style-type: none; margin: 0; padding: 0; width: 60%; }
        #sortable li { margin: 0 3px 3px 3px; padding: 0.4em; padding-left: 1.5em; font-size: 1.4em; height: 18px; }
        #sortable li span { position: absolute; margin-left: -1.3em; }
        </style>
        <script>
        $(function() {
          $( "#sortable" ).sortable();
          $( "#sortable" ).disableSelection();
        });
        </script>


      <div class="demo">

      <ul id="sortable">
        <li class="ui-state-default"><span class="ui-icon ui-icon-arrowthick-2-n-s"></span>Item 1</li>
        <li class="ui-state-default"><span class="ui-icon ui-icon-arrowthick-2-n-s"></span>Item 2</li>
        <li class="ui-state-default"><span class="ui-icon ui-icon-arrowthick-2-n-s"></span>Item 3</li>
        <li class="ui-state-default"><span class="ui-icon ui-icon-arrowthick-2-n-s"></span>Item 4</li>
        <li class="ui-state-default"><span class="ui-icon ui-icon-arrowthick-2-n-s"></span>Item 5</li>
        <li class="ui-state-default"><span class="ui-icon ui-icon-arrowthick-2-n-s"></span>Item 6</li>
        <li class="ui-state-default"><span class="ui-icon ui-icon-arrowthick-2-n-s"></span>Item 7</li>
      </ul>

      </div><!-- End demo -->



      <div class="demo-description" style="display: none; ">
      <p>
        Enable a group of DOM elements to be sortable. Click on and drag an
        element to a new spot within the list, and the other items will adjust to
        fit. By default, sortable items share <code>draggable</code> properties.
      </p>
      </div><!-- End demo-description -->


      
    </div>

    <script type="text/javascript">

  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-29418466-1']);
  _gaq.push(['_setDomainName', 'furf.com']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();

</script>

    </body>
</html>
</apex:page>


Please can any one help me here?

Regards,
​Ajay
Hi,

I am trying to deploy/retrieve/validate the metadata with Ant scripts to sandbox environment and it gives me the below error:

Error: Failed to login: UNSUPPORTED_API_VERSION - Invalid Api version specified on URL

Sandbox API version: 36.0

CustomPackage.xml API version: 36.0 (I did tried with 35 also)
It is working with another sandbox with APT version 37.0

Can you please help me how to solve this issue?
User-added image
Regards,
Ajay
 

Class:
    Map<String,Integer> ScoreMap = new Map<String,Integer>{'A4'=>7,'B4'=>7,'C4'=>5,'D4'=>4,'E4'=>4,'A3'=>8,'B3'=>7,'C3'=>6,'D3'=>5,'E3'=>5,};

if(sOperation== 'sUpdate')
                {
                    Contact oldC = OldConTriggerMap.get(c.Id);
                   
                    if((oldC.Score_OL__c!= c.Score_OL__c || 
                        oldC.Score_MC__c!= c.Score_MC__c ||
                        oldC.Score_PF__c!= c.Score_PF__c&& ScoreMap.ContainsKey(c.Score_MC__c))
                        )
                    {
                        c.Score_OL__c = ScoreMap.get(c.Score_MC__c);
                    }
                }
Test Class:
//Create a new account
        Account acc=new Account(Name='Account37',Phone='1142234334',Type = 'Prospect',
        Score_PF__C = 'B',
        );
        insert acc;
     //Create new contact
        Contact con = new Contact();
        con.LastName='ContactCS6737';
        con.AccountId=acc.Id;        
        con.Score_MC__c = 'B1';            
        insert con;
        
        con.Score_MC__c='B3';
        update con;
        Contact updatedCon=[SELECT Id,LastName,Score_MC__c from Contact WHERE Id=:con.Id];
        System.assertEquals('B3', con.Score_MC__c);

None of the lines are covered.

Regards,

Ajay

  • April 28, 2016
  • Like
  • 0
Hi,

Can any one help me, what is the best way to learn thoroughly APEX coding. Are there any best books to follow? consider that I am new to programming.

Reagrds,
Ajay
  • August 06, 2014
  • Like
  • 0
Hi All,

Here is my business requirement and I never worked on webservices. 

1. We have specif objects and fields to consume by Oracle.
2. Oracle will consume the webservice and then should be able to  updated few fields in SFDC.

My Assumptions:
Simply generate WSDL and provide them to consume the webservice?
or Do we have to write any classes for each object to expose the data?

Please help me, how I have to achieve this.

regards,
Ajay

  • August 05, 2014
  • Like
  • 0
Hello everyone, 
I want to display columns in my lightning Component no click button, 
Can u help me.
 
  • March 22, 2018
  • Like
  • 0
Hello,

I am trying to modify this existing trigger that prevents someone from deleting an attachment to only fire if the associated parent opportunity stage is Closed Won - 
 
trigger AttachmentSaver on Attachment (after delete) {
  // Get the current user's profile name
  Profile prof = [select Name from Profile where Id = :UserInfo.getProfileId() ];
  
  // If current user is not a System Administrator, do not allow Attachments to be deleted
  if (!'System Administrator'.equalsIgnoreCase(prof.Name)) {
    for (Attachment a : Trigger.old) {
      a.addError('Unable to delete attachments.');
    }  
  }
}

What do I need to add in here that would only fire this error for Closed Won Opps?

Thank you,
Oksana​
Superbadge
Process Automation Specialist> Step 2

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

I am really stuck here.

Any help please.?

Reagrds,
Ajay
  • August 03, 2017
  • Like
  • 0
Hi,

I am getting this error on Automate Your Business Processes>>Create a Satisfaction Survey
>>Add a Screen for Thanking the Customer
 

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

Everuthing is done as mentioned in the trailhead, but still I am getting this error. any reason?

Regards,
Ajay
Hello. Regarding SalesForce training for SalesForce Administrator certification, I have just started the TrailHead instruction. In my Setup or Developer org, I am not seeing the link button which allows me to create an app. I have looked at the help, but still don't see it. My context says BMC RemedyForce.

Am I doing something wrong, or could it be that my org instance is not properly enabled? What I see does not look like the Setup screen or Developer org in the video.

Thank you!
Stephen
Hello,
I am developing an app and was told we might have to use the authenticator to do 2 factor auth with our app. Is there any support between the Authenticator and the SFDC Android SDK? If so, where can I find documentation on it?

Thanks.
Hello, 

I am working on creating a Contract template in visualforce, and I have to display a few numbered lists.  I am using a seperate outputtext for each item in the list, like so: 
 
<apex:outputText >
A.  Item A and corresponding text, this could wrap into a second, third, fourth, etc line.  How can I make the lines indent?
</apex:outputText>
<br/>
<br/>
<apex:outputText >
B.  Item B and corresponding text, this could wrap into a second, third, fourth, etc line.  How can I make the lines indent?
</apex:outputText>
<br/>
<br/>
<apex:outputText >
C.  Item C and corresponding text, this could wrap into a second, third, fourth, etc line.  How can I make the lines indent?
</apex:outputText>
<br/>
<br/>
<apex:outputText >
D.  Item D and corresponding text, this could wrap into a second, third, fourth, etc line.  How can I make the lines indent?
</apex:outputText>

How do I specify that when the text wraps on to a second line, it becomes indented? 

Thanks in advance!

John
Hi there,

I am trying to add a visualforce area type homepage component. But it keeps showing a blank area.
my visualforce page named mynewpage.vfp code here
<apex:page >
    <apex:pageBlock >
        Hello world!
    </apex:pageBlock>
</apex:page>
when I preview it, it's like this.
screenshot1
Then I create a homepage component here
User-added image

Next, I add it to home page layout and assign it correctly.
User-added image

After all, I go back to Home page, it shows nothing about this new page except its label.
User-added image

Could anyone tell me what is wrong here, or give me a detail example of adding a visualforce area type homepage component please?

In addition, here is what I found in home page's html code
<div>
   <div>
      <h2>test vf page</h2>
   </div>
   <div><iframe height="200px" frameborder="no" width="100%" title="MyNewPage" src="https://c.na30.visual.force.com/apex/MyNewPage?autoMapValues=1&amp;inline=1&amp;core.apexpages.framework.ApexViewServlet.getInlinedContentRequest=1&amp;sfdcIFrameOrigin=https://na30.salesforce.com/home/home.jsp&amp;sdfcIFrameOrigin=https://na30.salesforce.com/home/home.jsp" scrolling="no" name="06636000004EKlc" marginwidth="0" marginheight="0" id="06636000004EKlc"></iframe></div>
</div>
Thanks,

 
  • August 29, 2016
  • Like
  • 0
I have a Visual Force page that I created that contains a dynamic pick list field I want to add to a page layout. The VF page uses a standard controller for "Account" and has an extension. I am having an issue with the dynamic pick list field displaying on the Account page when I add it to the page layout.

VF Code:
<apex:page standardController="Account" extensions="Account_QuoteTemplatesExtension" showHeader="false" sidebar="false">
    <apex:form >
        <apex:PageBlock mode="edit">
            <apex:PageBlockSection title="Quote Template Selection" columns="1">
                <apex:PageBlockSectionItem >

                    <!-- Label for picklist -->
                    <apex:outputLabel value="Quote Template" for="quoteTemplates" />
                    <!-- Dynamic picklist of values (quote templates) -->
                    <apex:selectList value="{!selectedTemplate}" size="1" id="quoteTemplates">
                        <apex:selectOptions value="{!TemplateOptions}" />
                    </apex:selectList>

                </apex:PageBlockSectionItem>
            </apex:PageBlockSection>
        </apex:PageBlock>
    </apex:form>
</apex:page>

Apex Controller:
global with sharing class Account_QuoteTemplatesExtension {

private final ApexPages.StandardController controller;
private final Account record;
private final Id recordId;

public String selectedTemplate {get; set;}

public Account_QuoteTemplatesExtension (ApexPages.StandardController stdController) {
    this.controller = stdController;
    this.recordId   = this.controller.getId();
    this.record     = [SELECT id, name FROM Account WHERE Id = :this.recordId LIMIT 1];
}

// Returns list of quote template options
public List<SelectOption> getTemplateOptions() {
    // Initiate option list
    List<SelectOption> tempOptions = new List<SelectOption>();
    // Get all quote templates from metadata
    List<Quote_Template__mdt> quoteTemplates = [SELECT MasterLabel, Template_Id__c FROM Quote_Template__mdt];
    // Add all options to select option list
    for (Quote_Template__mdt temp : quoteTemplates) {
        tempOptions.add(new SelectOption(temp.Template_ID__c,temp.MasterLabel));
    } 
    return tempOptions;   
}

I added the VF page in a section on the page layout like so:
Screenshot of customized page layout

But the page layout section remains blank
Blank section on page layout

The preview renders properly, but it will not display on the page layout
Preview of VF Page

I have already checked the security settings for the VF Page and have enabled access for System Administrator, which is the profile I am using. I have also tried to render a very simple VF page with the following code:
<apex:page standardController="Account">
        <apex:outputText value="Hello World" />
</apex:page>
But it still leaves the page layout blank-- I'm not sure where to go from here. Any suggestions?




 
Hello!

I'm pretty new to salesforce and I’ve been tasked with finding a way to update the records in my Lead object based on bounce reason. Specifically, If I send out an email and the message bounces, I want to trigger a workflow process that automatically updates my primary email field with my alternative email field. Reason being, I can only send out mass emails to primary email addresses. I tried taking a simpler approach by taking email and updating it using ‘Bounced Reason = “” ‘, and It didn’t work. I’ve researched and have come to the conclusion that I will have to go DEV route and use a query to access leads with bounced emails then update them that way. What I wanted to do was have this set to TRIGGER, but not sure how to go querying for each record. Any help, guidance, and a little bit of mind mapping will go a long way.

Ex.
Email: lo2222lo@xa.com email bounced        Alt Email: lolo2222@xa.com
Trigger Auto Update
Email: lolo2222@xa.com                      Alt Email: lolo2222@xa.com
  • August 29, 2016
  • Like
  • 0
Hi,

I have a complex requirement to build a report. Hoever I noticed that it is not possible with standard report. Can you help me the best way to create this complex report using VF page.

User-added image

Left side colum has Field Labels. and we need to caluculate each field value Percentage based on the value selected on the total reocrds which users attened that specific field.

Thanks in advance.
Reagrds,
Ajay
  • August 29, 2016
  • Like
  • 0
Hello,

Can anyone help me on this validation rule causing CPU timeouts. When load the data through dataloader this validation is causing the CPU time out error, if I deactivate this rule and the load is success with no CPU timouts. I tried multiple times and noticed the same results. Is there a betterway we can write this validation rule?

AND ( 
OR($Profile.Name <> "API Integration", $Profile.Name <> "USA Sales Planning Rep",$Profile.Name <> "USA Sales Planning Executive",$Profile.Name <> "USA Sales Planning Mgr",$Profile.Name <> "API Eloqua" ), 
OR( 
ISBLANK( BillingCity ), 
ISBLANK( BillingStreet ), 
ISBLANK( BillingCountry), 
ISBLANK( BillingState), 
ISBLANK( BillingPostalCode ) 

)