Hi, I have to update contacts deaily if a custom number field call_interval_count with number 1 if call_interval_c !=  null. 
My batch is below:

global class updatecontactworkflow implements Database.Batchable<SObject>, Database.Stateful{
             
    global Database.QueryLocator start(Database.BatchableContext BC)
    {
        String query = 'Select Id, Call_Interval__c From contact WHERE Call_Interval__c != Null';
        system.debug(query);
        return Database.getQueryLocator(query);
    }
     
    global void execute(Database.BatchableContext BC, List<SObject> scope){
        for(contact obj : (contact[]) scope){
            if(obj.Call_Interval__c != Null){
               obj.Call_Alert_Count__c = 1;
              } else 
               obj.Call_Alert_Count__c = 1;
            }
        system.debug('list to be updated size  :: ' + scope.size());
        if(!scope.isEmpty())
        {
              update scope;
         }
     }

    global void finish(Database.BatchableContext BC){
    }
}

and test class is :

@isTest             
private class updatecontactworkflowTest 
{
    static testmethod void testbatch() 
    {
        Account acc = new Account(Name='Test Account');
        insert acc;
              
        List<contact> cons = new List<contact>();
        for (integer i=0; i<50; i++)
        {
            contact con = new contact();
            con.AccountId=acc.Id;
            con.Name='My contact'+i;
            con.Level__c ='C Level';
            con.Functional_Role__c = 'Opeartion';
            con.Title = 'CFO';
			con.Phone = '+441569172306';
			con.Email = 'na@na.com';
			con.Call_Alert_Count__c = '1';
			
            //con.LastActivityDate = System.today()+15;
            cons.add(con);
        }
        insert cons;
        
       Test.startTest();
           updatecontactworkflow  obj = new  updatecontactworkflow ();
           Database.executeBatch(obj, 200);
       Test.stopTest();

    }
}

Code Coverage is 46% (6/13). Please assist :)

Dear friends,

I am new to the development , could you please cover the test class for following code with explaination.

Code
---------------------------------------------------------------------------------

public with sharing class AccountDealOpportunity {

    public AccountDealOpportunity(ApexPages.StandardController controller) {
        
        lstOpp = new List<Opportunity__c>();
        AccId = ApexPages.currentPage().getParameters().get('id');
        Account iAcc = [SELECT id, Recordtype.Name, Name FROM Account WHERE Id =: AccId];
        String Query = 'SELECT id, Name, Originator__c, Investor__c, Interested_Products__c, Asset_Class__c, Investor_Category__c,'+
                        +'Amount__c,Valid_Till__c,RecordType.Name FROM Opportunity__c where ';
        if(iAcc.RecordType.Name == 'Investor')
        {
            query = query + 'Investor__c =: AccId';
        }
        else if(iAcc.RecordType.Name == 'Originator')
        {
            query = query + 'Originator__c =: AccId';
        }
        lstOpp = Database.query(query);
    }


    public List<Opportunity__c> lstOpp {get;set;}
    Public Boolean isShowOpp {get;set;}
    String AccId;
    
    public AccountDealOpportunity()
    {
        
    }
    
    public pageReference CreateDeal()
    {
        PageReference DealPage = new PageReference('/apex/CreateDeals?id=' + AccId);
        DealPage.setRedirect(true);
        return DealPage;
    }
    
    public pageReference OpportunitytoDeal()
    {
        return Null;
    }

}

------------------------------------------------------------------------


Thanks In Advance ....

Regards,
Soundar Raj

Hello! I am trying to create a formula field in which the formula is different depending on a picklist selection. Specifically, if "Weekly" is the picklist selection, the formula will be "Minimum_Charge__c / Weeks__c)*4"; if "Semi-weekly" is selected, the formula will be "Minimum_Charge__c / .05)*4". If neither is selected, I would like for the field to remain blank, but haven't figured that out either. I have the first half working (other than the remain blank part), but can't figure out how to complete it. 

The first part:
(IF(ISPICKVAL( Frequency__c , "Weekly"),  
(Minimum_Charge__c /  CASE(Weeks__c, "Every 2 weeks",2,
                                     "Every 3 Weeks",3,
                                     "Every 4 weeks",4,
                                     "Every 6 weeks",6,
                                     "Every 8 weeks",8,
                                     "Every 10 weeks",10,
                                     "Every 12 weeks",12,
0)*4),0))

How do I complete this? Thanks in advance for your help!

Hi,

   I have a requirement to show the grand total of quantity, quantity is a input field user can change the value as the user change it should automatically dispaly the grand total in the column fotter please suggest me how to implement this feature. 


  <apex:page standardController="Opportunity" extensions="OptyLineEditCnt" id="pg" sidebar="false">
     <apex:form id="frm">
      <apex:pageBlock title="Edit Opportunity Lines" id="pb2">
        <apex:pageBlockTable   Width="100%" id="pbt2">
           <apex:inputfield id="Quantity" value="{!Quantity}" > </apex:inputfield>
      </apex:pageBlockTable>
     </apex:pageBlock>
     </apex:form>       
  </apex:page>

Thanks
Sudhir

I have 10 users with same profile and CRUD permissions.After 2 months I decide to give 2 users ONLY Create permission. How do i accomplish this ?

Thanks
 

Hello,

 I have created custom button on custom object. In this custom button i want to select records according to particular city. When i will selcet city "Mumbai" then i have to get all accounts having city mumbai. So that i can select some records from mumbai only. I have created code to display all the accounts records and to show selected some and its working fine. I want to know that how to apply filter so that i will get records according selected city.


Controller:
public with sharing class MyCompController1
{ 

public String str;
    public MyCompController1(ApexPages.StandardController controller) {
    
   str= ApexPages.currentPage().getParameters().get('id');
   system.debug('**************Record id is**********************'+str);
   if(wrapAccountList == null)
{
wrapAccountList = new List<wrapAccount>();
for(Account a: [select Id, Name, BillingCity from Account])
{
wrapAccountList.add(new wrapAccount(a));
system.debug('*****************wrapAccountList******************'+wrapAccountList);
}
}

    }



public List<wrapAccount> wrapAccountList {get; set;}
public List<Account> selectedAccount{get;set;}

private List<Id> accountids=new list<Id>();
public List<Account> acc;

public PageReference processSelected()
{
    selectedAccount = new List<Account>();

    for(wrapAccount wrapAccountObj : wrapAccountList)
    {
    if(wrapAccountObj.selected == true)
    {
        selectedAccount.add(wrapAccountObj.acc);
        //accWrap.acc.Name
        system.debug('*****************!!!!!!!!!wrapAccountList******************'+selectedAccount);

    }
    }
 /*for(Account acc: selectedAccounts)
{
Daily_Visit_Plan__c pv =new Daily_Visit_Plan__c();
pv.Name__c= acc.id;
insert pv;


} */
            PageReference pageRef = new PageReference('/apex/Visitplan');
           
            return pageRef;
}


public list<Account> srecs;
public list<Account> getSrecs()
{
 srecs= [select Id, Name, BillingCity from Account];
 system.debug('*****************!!!!!!!!!srecssrecssrecssrecs******************'+srecs);

        return selectedAccount;
}

public class wrapAccount {
public Account acc {get; set;}
public Boolean selected {get; set;}

public wrapAccount(Account a)
 {
acc = a;
selected = false;
}
}
}




VF PAGE1:


<apex:page standardController="Account" extensions="MyCompController1" standardStylesheets="false" sidebar="false">
<script type="text/javascript">
function selectAllCheckboxes(obj,receivedInputID)
{
var inputCheckBox = document.getElementsByTagName("input"); for(var i=0; i<inputCheckBox.length; i++)
{
if(inputCheckBox[i].id.indexOf(receivedInputID)!=-1)
{
inputCheckBox[i].checked = obj.checked;
} } }
</script>
<apex:form >
<apex:pageBlock >
<apex:pageBlockButtons >
<apex:commandButton value="Create Visit" action="{!processSelected}" />
</apex:pageBlockButtons>
<apex:pageblockSection title="All Contacts" collapsible="false" columns="1">
<apex:pageBlockTable value="{!wrapAccountList}" var="accWrap" title="All Doctors And Chemists">
<apex:column >
<apex:facet name="header">
<apex:inputCheckbox onclick="selectAllCheckboxes(this,'inputId')"/>
</apex:facet>
<apex:inputCheckbox value="{!accWrap.selected}" id="inputId"/>
</apex:column>
<apex:column value="{!accWrap.acc.Name}" />
<apex:column value="{!accWrap.acc.BillingCity}" />
</apex:pageBlockTable>
</apex:pageblockSection>
</apex:pageBlock>
</apex:form>
</apex:page>

VF PAGE 2:
<apex:page standardController="Account" extensions="MyCompController1" sidebar="false">
<apex:pageBlock >
<apex:pageBlockSection title="Displaying selected records.." collapsible="false">
<apex:pageBlockTable value="{!srecs}" var="item" >
<apex:column value="{!item.id}"/> <apex:column value="{!item.name}"/>
<apex:column value="{!item.BillingCity}"/>
</apex:pageBlockTable>
</apex:pageBlockSection>
</apex:pageBlock>
</apex:page>
 

Hello,

I am not able to create custom button as in a cotent source drop down list there is no visualforce page to select.

My code is 
Controller:

public with sharing class MyCompController
{    
    Map<Integer, Account> AccountIdList = new Map<Integer, Account>();

    public MyCompController() {
        Integer i = 0;
        for (Account a : [SELECT Id, Name FROM Account]) {
            AccountIdList.put(i, a);
            i++;
        }
    }

    public Map<Integer, Account> getAccountIdList() {
        return AccountIdList;
    }
}

VF Page:

<apex:page controller="MyCompController"> <apex:form > <apex:repeat value="{!AccountIdList}" var="accNum"> <apex:outputText value="({!AccountIdList[accNum]}, {!AccountIdList[accNum].Name})" /><br/> </apex:repeat> </apex:form> </apex:page>

I have a Developer Edition Account.
I have created a Workflow Rule which triggers an Outbound Message. I am using requestbin url to send message but it gives error '(403) Forbidden' in Delivery Failure Reason.

Please tell me what is the reason for this error as there is no information to resolve this issue. Please help how can i fix this one.

Thanks
Ankur Saini

<apex:repeat value="{!ObjLoadingSetting.listofMapping}" var="mapping"  id="mrep">
                                     <tr>
                                         <td><apex:selectList value="{!mapping.selectSobjectfield}" styleClass="selectedValue" size="1" disabled="{!ObjLoadingSetting.editmod}" onchange="SelectedValueSOQL('{!ObjLoadingSetting.UpsertLoadingSetting.Sobject_Name__c}','Multipal','')" style="height:30px; width:250px;" ><apex:selectOptions value="{!mapping.SobjectFieldList}"/></apex:selectList></td>
                                         <td><apex:selectList value="{!mapping.selectReportfield}" size="1" disabled="{!ObjLoadingSetting.editmod}" onchange="checkm(this.id)"   styleClass="parentclassm" multiselect="false" id="acc3"  style="height:30px; width:130px;"  ><apex:selectOptions value="{!mapping.ReportfieldList}"/></apex:selectList></td>
                                         <td><apex:inputText value="{!mapping.selectMappingfield}" disabled="{!OR(mapping.editenable,ObjLoadingSetting.editmod)}" style="height:30px; width:300px; padding-left:5px;"/></td>
                                         <td><a href="#!" class="button2" onclick="deleteROWM('{!i}','{!ObjLoadingSetting.UpsertLoadingSetting.Sobject_Name__c}','Multipal','')" style="margin-left:15px;" >Delete</a></td>
                                     </tr>
                                     <apex:variable var="i" value="{!i+1}"/>
                                 </apex:repeat>

 

<apex:repeat value="{!listOfShowSettings}" var="settObj">
                                 <tr>
                                     <td class="border1" style="text-align:center;">{!i}</td>
                                     <td class="border1" style="text-align:center;"><a href="#!" onclick="document.getElementById('Multiple').style.display='none';document.getElementById('Nested').style.display='none';selectJobToShow('{!settObj.dataLoaderObject.Job_Name__c}')" >{!settObj.dataLoaderObject.Job_Name__c}</a></td>
                                     <td class="border1" style="text-align:center;">{!settObj.noOfObject}</td>
                                     <td class="border1" style="text-align:center;">{!settObj.dataLoaderObject.Query_Type__c}</td>
                                     <td class="border1" style="text-align:center;">Temp</td>
                                     <apex:variable var="i" value="{!i+1}"/>
                                 </tr>
                             </apex:repeat>

 

strSoql = ObjLoadingSetting.UpsertLoadingSetting.SOQL_Query__c.substring(0,ObjLoadingSetting.UpsertLoadingSetting.SOQL_Query__c.indexof(ObjLoadingSetting.UpsertLoadingSetting.sObject_Name__c)+ObjLoadingSetting.UpsertLoadingSetting.sObject_Name__c.length())+' where '+ ObjLoadingSetting.whereClause+' limit 1';

HI Team,

1. Validation rules apply to new and updated records for an object, even if the fields referenced in the validation rule are not included in a page layout or an API call
 a) True
 b) False

2. When is cross object formula calculated?
 a). When it is viewed.
 b). When related object record created or updated.
 c). When the record is created or updated.
 d). When an update is scheduled.

3. soap webservices commonly used for ?
 a). simple light weight services that are typically stateless
 b). Public APIs that use HTTP and JSON
 c). Enterprise apps that require a formal exchange format or stateful operations.
 d). No one uses SOAP any longer.. it's four letter word.

4. The setup audit trail tracks changes to which of the following items?
 a). email address changes.
 b). approval processes completion.
 c). page layout changes.
 d). record updates.
 e).chatter posts

5. which of the following salesforce 1 app requirements would be most likely to push you in the direction of using programmatic tools like visualforce ? (Choose the best answer)
 a). Governor limits.
 b). A need to use custom objects and fields to track data specific to your business.
 c). A need to support a complex business process with a highly customized user interface and click through path.
 d). A need for full access to all data stored in salesforce.

Please give me the reply to above questions....


Regards
Lakshmi

I need help on the following requirement as follows,

I have a text field called "Latest date" which has values in "March -2017" format

I want another formula field to convert the above text to dd/mm/yyyy format


The date can be 1st of every month

I shouldnt make any changes to the existing field and need this functionality in  a new field

Help me how to acheive this

Thanks in Advance

Hi, I have to update contacts deaily if a custom number field call_interval_count with number 1 if call_interval_c !=  null. 
My batch is below:

global class updatecontactworkflow implements Database.Batchable<SObject>, Database.Stateful{
             
    global Database.QueryLocator start(Database.BatchableContext BC)
    {
        String query = 'Select Id, Call_Interval__c From contact WHERE Call_Interval__c != Null';
        system.debug(query);
        return Database.getQueryLocator(query);
    }
     
    global void execute(Database.BatchableContext BC, List<SObject> scope){
        for(contact obj : (contact[]) scope){
            if(obj.Call_Interval__c != Null){
               obj.Call_Alert_Count__c = 1;
              } else 
               obj.Call_Alert_Count__c = 1;
            }
        system.debug('list to be updated size  :: ' + scope.size());
        if(!scope.isEmpty())
        {
              update scope;
         }
     }

    global void finish(Database.BatchableContext BC){
    }
}

and test class is :

@isTest             
private class updatecontactworkflowTest 
{
    static testmethod void testbatch() 
    {
        Account acc = new Account(Name='Test Account');
        insert acc;
              
        List<contact> cons = new List<contact>();
        for (integer i=0; i<50; i++)
        {
            contact con = new contact();
            con.AccountId=acc.Id;
            con.Name='My contact'+i;
            con.Level__c ='C Level';
            con.Functional_Role__c = 'Opeartion';
            con.Title = 'CFO';
			con.Phone = '+441569172306';
			con.Email = 'na@na.com';
			con.Call_Alert_Count__c = '1';
			
            //con.LastActivityDate = System.today()+15;
            cons.add(con);
        }
        insert cons;
        
       Test.startTest();
           updatecontactworkflow  obj = new  updatecontactworkflow ();
           Database.executeBatch(obj, 200);
       Test.stopTest();

    }
}

Code Coverage is 46% (6/13). Please assist :)

Hello

I need to bind picklist values to an toggle switch in an visualforce page. assuming the toggle switch is created using css or jquery.

if I click save button then it should save to object.

please help me out.

thanks
vandana

hi

how to show each contacts on the visualfroce page and each particular record have a button for edit and delete and save  ??

example
id ,lastName,firstName
112222xhd , xyz , yyy              edit ,delete,save
same another records .............. how to possible please suggest me


Thanks
Nagma
 

Hi,
I need to display only number after /
EX :   20 /12
Output : 12

How can i achevie with validation ?

Hi All,

What is the purpose of the below regular expression?

string test = '00045304^+453534$!';
system.debug('>>>> Remove leading zero >>'+test.trim().replaceAll('^0+(?!$)', ''));

Thanks,
Vijay
 

Hi,

My exact requirement is as follows,

I have a custom object, say myreports__c, where in each record user will choose a report name in a lookup field and will have a time field, an email field and a date field.

So, now I've to query these records each day which has the today's date in the date field and need to run and email the selected report in those records at the mentioned time.

Even a sample or suggestive code will be greatly helpful.

Thanks,
Leafen Sandy

Dear friends,

I am new to the development , could you please cover the test class for following code with explaination.

Code
---------------------------------------------------------------------------------

public with sharing class AccountDealOpportunity {

    public AccountDealOpportunity(ApexPages.StandardController controller) {
        
        lstOpp = new List<Opportunity__c>();
        AccId = ApexPages.currentPage().getParameters().get('id');
        Account iAcc = [SELECT id, Recordtype.Name, Name FROM Account WHERE Id =: AccId];
        String Query = 'SELECT id, Name, Originator__c, Investor__c, Interested_Products__c, Asset_Class__c, Investor_Category__c,'+
                        +'Amount__c,Valid_Till__c,RecordType.Name FROM Opportunity__c where ';
        if(iAcc.RecordType.Name == 'Investor')
        {
            query = query + 'Investor__c =: AccId';
        }
        else if(iAcc.RecordType.Name == 'Originator')
        {
            query = query + 'Originator__c =: AccId';
        }
        lstOpp = Database.query(query);
    }


    public List<Opportunity__c> lstOpp {get;set;}
    Public Boolean isShowOpp {get;set;}
    String AccId;
    
    public AccountDealOpportunity()
    {
        
    }
    
    public pageReference CreateDeal()
    {
        PageReference DealPage = new PageReference('/apex/CreateDeals?id=' + AccId);
        DealPage.setRedirect(true);
        return DealPage;
    }
    
    public pageReference OpportunitytoDeal()
    {
        return Null;
    }

}

------------------------------------------------------------------------


Thanks In Advance ....

Regards,
Soundar Raj

Hi All,

Please help in the problem I am facing for the below Scenario.
I am working on a trigger to auto count the number of times a filed is updated each month. Though the problem is the filed is on Opportunity object and each User has muiltiple opportunities. So if the field is updated in any opportunity, the field on the User page should increment. This will help us know the number of dispaches each month from each user.

Please help me in approaching the issue.

Regards
Avinash

Hi,
I am using same Standardcontroller and Extension for both the pages, and set redirect as false. But still it create new instance of Controller and view state gets Null.
Guys Please send me anty idea, if you have to resolve this problem.
One one more error if I set setRedirect(False) then it has been  showing
the page you submitted is invalid for this session. Please click save again to confirm you chenges.  

Hello! I am trying to create a formula field in which the formula is different depending on a picklist selection. Specifically, if "Weekly" is the picklist selection, the formula will be "Minimum_Charge__c / Weeks__c)*4"; if "Semi-weekly" is selected, the formula will be "Minimum_Charge__c / .05)*4". If neither is selected, I would like for the field to remain blank, but haven't figured that out either. I have the first half working (other than the remain blank part), but can't figure out how to complete it. 

The first part:
(IF(ISPICKVAL( Frequency__c , "Weekly"),  
(Minimum_Charge__c /  CASE(Weeks__c, "Every 2 weeks",2,
                                     "Every 3 Weeks",3,
                                     "Every 4 weeks",4,
                                     "Every 6 weeks",6,
                                     "Every 8 weeks",8,
                                     "Every 10 weeks",10,
                                     "Every 12 weeks",12,
0)*4),0))

How do I complete this? Thanks in advance for your help!

Hi Experts,
I want to create a account list VF page where it will have two links Edit and Del, when clicked on Edit,account record should be editable and when you click on Del,it should show dialog box,when you confirm it, it should delete record and if you cancel it should not delete record.

Kindly provide me the code for the same.

Regards

We have requirement where in we need to display fields based on the checkbox selected .I have written a VF page and Apex classe but still not able to acieve the requirement below are the few points i am trying to achieve.
1. When first checkbox is selected second checkbox should be hidden and viceversa.
2. Also we need to clear the values from the  dependent fields in the pageblock section on unchecked box.

Any lead or steps to achieve this is very hepfull.

Thanks in Advance.

Visualforce Page:


<apex:page standardController="Opportunity" extensions="rpac">

<apex:form >
<apex:pageBlock >
  <apex:pageBlockSection columns="1" id="Test" >
 <apex:inputcheckbox value="{!Opportunity.abc__c}" >
 <apex:actionSupport event="onchange"  action="{!aaa}" rerender="Test" />
</apex:inputcheckbox>
  <!--<apex:outputPanel rendered="{!(Opportunity.abc__c)}" > -->
		<apex:inputField value="{!Opportunity.abc__c}"  rendered="{!(Opportunity.abc__c)}" />
        <apex:inputField value="{!Opportunity.abc_Class__c}" rendered="{!(Opportunity.abc__c)}" />
        <apex:inputField value="{!Opportunity.abc_Transition_Phase__c}" rendered="{!(Opportunity.abc__c)}" />
   </apex:pageBlockSection>
   
   <apex:pageBlockSection columns="1" id="Test1" > 
     <apex:inputcheckbox value="{!Opportunity.xyz__c}" > <!--removed selected=true label="Same as Above" -->
     <apex:actionSupport event="onchange" action="{!bbb}" rerender="Test1" />
     </apex:inputcheckbox>    
        <apex:inputField value="{!Opportunity.ayz_Payment_Terms__c}" rendered="{!(Opportunity.xyz__c)}" />
        <apex:inputField value="{!Opportunity.xyz_Record_Delete__c}" rendered="{!(Opportunity.xyz__c)}" />
</apex:pageBlockSection>
</apex:pageBlock>
</apex:form>
</apex:page>


Apex class:

public with sharing class Repack{

    public Opportunity test{get;set;}
    public Opportunity test1{get;set;}
    public boolean abc {get;set;}
    public boolean ayz{get;set;}

        public Repack(ApexPages.StandardController stdCtrl) {
        this.test=(Opportunity)stdCtrl.getRecord();
        abc=False;
        this.test1=(Opportunity)stdCtrl.getRecord();
        ayz= False;
        //this.test=true;//observe the change in this line.Added this for proper behaviour on load 
       }
       
       public pagereference aaa(){
           
           return null;
       }
       public pagereference bbb(){
           
           return null;
       }

   }

We have an email alert that needs to go out X days after a certain date. We currenty have a date field for that certain date and a box where we put how many days after that date we need that email to go out. However, I need this to be automated. I need a formula, workflow rule or process that allows me to calculate what date should the email trigger. and then trigger the email For example, if the days are 5 then the new date based on today's date would be April 30th.  On April 30th the email should trigger. So I either need a fomula that adds the 5 days to my date and gets me a new date from where the email alert triggers or something else that achieves the same. How do I create a formula that does this? 

I created the web-to-lead form with multiple picklist, but I am using checkbox value, however, when I receive the lead, the value can't not populate in SFDC, could someone help to check if I am missing somthing that cause the value can't capturing and popluate in SFDC?

Target of the attacks? (please check all that apply):<br>
DNS:<input id="00N6F00000EX5Ga" name="00N6F00000EX5Ga[]" type="checkbox" value="DNS"><br>
Network infrastructure:<input id="00N6F00000EX5Ga" name="00N6F00000EX5Ga[]" type="checkbox" value="Network infrastructure"><br>
Service/application/website:<input id="00N6F00000EX5Ga" name="00N6F00000EX5Ga[]" type="checkbox" value="Service/application/website"><br>
Other or not sure:<input id="00N6F00000EX5Ga" name="00N6F00000EX5Ga[]" type="checkbox" value="Other or not sure"><br>
 

We referenced <apex:relatedlist list="CombinedAttachments" title="{!$Label.Notes_Attachments}"/> on Visualforce Page. But the problem with this retated list is, when we click on attach file in it : A new window opens and there are option to upload and attach file and finally to click on 'Done'. When I click on Done, Visualforce Page becomes unresponsive and no attachment is added. Do anyone have workaround regarding this?

I am new to Salesforce. How do i create a drop down list with "Stagename" field values of Opportunity object. Based on the value selected from drop down list i need to display the filtered Opportunity object records.