Salesforce Developer Community

Chatter

Feed
2

Best Answers
1

Likes Received
0

Likes Given
10

Questions
16

Replies

Hello

Newbie here. I fear this is a bit basic, but I've been looking for answers for a couple of weeks with no luck. Hopefully this isn't too much to ask of the community.

I have a custom object and a Visualforce page to edit the records. There is a Due Date field on the object of type Date. When the record is edited, we need the date that is displayed in the input field to appear either in US format, or according to the user's locale. We are fine with either. What we always get is yyyy-mm-dd. We want mm/dd/yyyy. Have read that Visualforce is supposed to respect a user's locale settings.

There are lots of posts around date formatting when you are using apex:outputText and apex:param tags when you are just viewing the data, but that doesn't work when you have an apex:inputField tag.

Here is the code:

<apex:page standardController="MyObject__c" docType="html-5.0" >
<apex:form>
  <apex:outputPanel layout="block" >
   <apex:outputLabel value="Due Date" for="duedate"/>
   <apex:inputField type="date" showDatePicker="false" styleClass="slds-input" id="duedate" value="{!MyObject__c.Due_Date__c}"/>
  </apex:outputPanel>
</apex:form>
</apex:page>

I have found a few approaches that deal with some custom controller code. But it doesn't seem like it should be that difficult or that much work. Is there some easy formatting option that I am missing? The code above is easy with the simple binding right to the object field. I did some experimenting trying to override the field in a controller extension to format a string using a getter. But I couldn't get that exactly right from the perspective of how to reference the controller extension's methods in the page, let alone what to do during a save operation. But if doing it in controller code is necessary, I'd appreciate some pointers in the right direction. I'm going through Trailhead and some other educational materials as I can, but in parallel have some development requests to address.

Thanks!
Steve

Steve Nelson
October 20, 2015
Like
0

1 replies

SObject type does not allow locking rows

I am trying to use for update in the SOQL query for territory object. I recieve the below error

"SObject type does not allow locking rows"

Where as i tried to use the for update keyword on account and contacts and it did work. is there any limitation to use the FOR UPDATE on territories.

john4sfdc
December 11, 2014
Like
1

0 replies

Internal Salesforce Error while trying to delete records using batch Apex

john4sfdc
September 11, 2014
Like
0

3 replies

Salesforce.com Internal error in Batch apex.does anyone have an idea on this?

john4sfdc
August 18, 2014
Like
0

6 replies

how to refer custon setting fields in javascript button code

I need to refer a custom settting field in the Javascript button.

How do we refer custo setting values in Java script button code

john4sfdc
October 11, 2013
Like
0

4 replies

How to use custom setting values in Java Script

I need to refer a custom settting field in the Javascript button.

How do we refer custo setting values in Java script button code

john4sfdc
October 11, 2013
Like
0

2 replies

Datetime error

Datetime insdate;
insdate = 2013-10-07 00:00:00;
System.debug(insdate);

when i try to execute this as annonymous, I get the error unexpected token: '2013-10-07'

My question is, How do we assign a datetime value to a variable?

john4sfdc
October 07, 2013
Like
0

3 replies

How do run the batch class in annonoymus apex

Can anybody help me in executing the below batch class using annonomous apex

global class batchUpdateAccounts implements Database.Batchable<sObject>,Database.Stateful{

global Database.QueryLocator start(Database.BatchableContext bc){

    return database.getQuerylocator('select id,Category__c,Family__c from Account');
}

global void execute(Database.BatchableContext bc, List<SObject> scope) {

        List<Account> accs = (List<Account>)scope;
        List<Account> accsToUpdate = new List<Account>();
        List<Global_families__c> gfslst = new List<Global_families__c>();
        gfslst = [select Is_Global__c, Name from Global_families__c];

        for(Account acunts : accs){
        for(Global_families__c lstglobal: gfslst ){
        if(acunts.Family__c == lstglobal.Name && lstglobal.Is_Global__c == TRUE){
        Acunts.Family__c = 'Global';
        accsToUpdate.add(acunts);
        }
        }
        }

        update accsToUpdate;


}

global void finish(Database.BatchableContext bc){


}

}

john4sfdc
August 26, 2013
Like
0

SOLVED

10 replies

View state error

I am having a view state error on my vf page.

Below the controller code which i believe is causing the eror. Can anyone help me which part of the code is causing this error

public class Team_Attach_ACL
{
    id accountid,rectypeid;
    public AccountProgramAttachment__c naObj{set; get;}
   public Attachment attachment1{set; get;}
    public string filename { get;set;}
    public Team_Attach_ACL(ApexPages.StandardController controller)
    {
        accountid=system.currentPageReference().getParameters().get('id');
        naObj=new AccountProgramAttachment__c();
        naObj.isactive__c=true;
        Attachment1=new Attachment();
        rectypeid=Schema.SObjectType.AccountProgramAttachment__c.getRecordTypeInfosByName().get('Attachments').getRecordTypeId();
    }
   public Pagereference upload()
    {
        Attachment1.name = filename;
        naObj.name__c=filename;
        naObj.accountId__c=accountid;
        naObj.AttachmentCategory__c=naObj.AttachmentCategory__c;
        naObj.AttachmentTitle__c=attachment1.name;
        naObj.recordtypeid=rectypeid;
        naObj.IsActive__c = naObj.IsActive__c;
        if(filename!=null)
        {
            try
            {
                insert naObj;
                Attachment1.ParentId = naObj.id;
                insert Attachment1;
                return (new Pagereference('/'+accountid));
            }
            catch(Exception ex1)
            {
                //delete naObj;
                return null;
            }
        }
        else
        {
            String message1 = Label.AttachmentFileNotChosen;
            Apexpages.addmessage(new ApexPages.Message(ApexPages.severity.FATAL, message1));
        }
        return null;
    }
   public Pagereference cancel()
    {
        return (new Pagereference('/'+accountid));
    }
}

john4sfdc
August 19, 2013
Like
0

SOLVED

10 replies

how to bulkify a trigger

Hi all, I am a bit new to salesforce and i succesfully wrote this trigger. But i am lack of ideas on bulkifying it. The below trigger is a basic trigger to check if a contact is linked to a program or opportunity or account.

trigger CheckLinktoPrograms on Contact (after update,before delete) {

if(trigger.isupdate){
List<ProgramContactRole__c> lstConRole = new List<ProgramContactRole__c>();
List<AccountContactRole> lstConRole3 = new List<AccountContactRole>();
List<OpportunityContactRole> lstConRole4 = new List<OpportunityContactRole>();
Set<Id> setContactId = new Set<Id>();

for(Contact c:trigger.new){
setContactId.add(c.id);
}
lstConRole=[select id,name,ContactId__c,ProgramId__c,ProgramId__r.name from ProgramContactRole__c where ContactId__c IN:setContactId];
lstConRole3=[select id,ContactId,AccountId,Account.name from AccountContactRole where ContactId IN: setContactId];
lstConRole4=[select id,ContactId,OpportunityId,Opportunity.name from OpportunityContactRole where ContactId IN: setContactId];

for(integer i=0;i<trigger.new.size();i++){

if(trigger.new[i].Active__c==false ){

for(ProgramContactRole__c pcr:lstConRole){
   if(pcr.ContactId__c==trigger.new[i].id){
      trigger.new[0].addError('Cannot inactivate Contact if its linked to a Program: '+pcr.ProgramId__r.name);
   }
}

for(AccountContactRole acr:lstConRole3){
   if(acr.ContactId==trigger.new[i].id){
      trigger.new[0].addError('Cannot inactivate Contact if its linked to an Account: '+acr.Account.name);
   }
}

for(OpportunityContactRole ocr:lstConRole4){
   if(ocr.ContactId==trigger.new[i].id){
      trigger.new[0].addError('Cannot inactivate Contact if its linked to an Opportunity: '+ocr.Opportunity.name);
   }
}

}
if(trigger.new[i].To_be_deleted__c == true){
for(ProgramContactRole__c pcr:lstConRole){
   if(pcr.ContactId__c==trigger.new[i].id){
      trigger.new[0].addError('Cannot mark as delete if its linked to a Program: '+pcr.ProgramId__r.name);
   }
}

for(AccountContactRole acr:lstConRole3){
   if(acr.ContactId==trigger.new[i].id){
      trigger.new[0].addError('Cannot mark as delete if its linked to an Account: '+acr.Account.name);
   }
}

for(OpportunityContactRole ocr:lstConRole4){
   if(ocr.ContactId==trigger.new[i].id){
      trigger.new[0].addError('Cannot mark as delete if its linked to an Opportunity: '+ocr.Opportunity.name);
   }
}
}
}
}

if(trigger.isdelete){
List<AccountContactRole> lstConRole1 = new List<AccountContactRole>();
List<OpportunityContactRole> lstConRole2 = new List<OpportunityContactRole>();
Set<Id> setContactId = new Set<Id>();

for(Contact c:trigger.old){
setContactId.add(c.id);

}
lstConRole1=[select id,ContactId,AccountId,Account.name from AccountContactRole where ContactId IN: setContactId];
lstConRole2=[select id,ContactId,OpportunityId,Opportunity.name from OpportunityContactRole where ContactId IN: setContactId];

for(integer i=0;i<trigger.old.size();i++){

for(AccountContactRole acr:lstConRole1){
    if(acr.ContactId==trigger.old[i].id){
    string accountname='<html><bold>';
    accountname+=acr.Account.name;
    accountname+='</body></html>';
     trigger.old[0].addError('Cannot delete Contact if its linked to an Account: '+accountname+' with a Role ( Contact Role ) ');
   }
}

for(OpportunityContactRole ocr:lstConRole2){
    if(ocr.ContactId==trigger.old[i].id){
     trigger.old[0].addError('Cannot delete Contact if its linked to an Opportunity: '+ocr.Opportunity.name+' with a Role ( Contact Role ) ');
   }
}

}

}

}

john4sfdc
July 25, 2013
Like
0

1 replies

how do i bulkify this trigger

john4sfdc
July 25, 2013
Like
0

1 replies

SObject type does not allow locking rows

john4sfdc
December 11, 2014
Like
1

1 replies

line break in textarea long between text

Hi I have created a textarea long field. when i enterd data in this without enter it is showing in one line. how can i add line break without press enter so it should show on page with line break.

plz help!

Russell baker 1
October 22, 2015
Like
0

SOLVED

8 replies

Attachment trigger

Hello!

Can someone help me with a trigger? I have it together, but there is an issue with the attachment part. It is not attaching. Here is the trigger:

trigger CreateContractDocSignComp on dsfs__DocuSign_Status__c (after update)
{
map<id,id> testmap = new map<id,id>();

list <attachment> attach = new list<attachment>();
List<Contract> ctr = new List<Contract>();

for(dsfs__DocuSign_Status__c dsfs : Trigger.new)
{
if(dsfs.dsfs__Envelope_Status__c == 'Completed')
{
Contract c = new Contract(Name = dsfs.Name,
Status = 'Draft',
Total_Contract_Value__c = dsfs.Total_Contract_Value__c,
ContractTerm = Integer.valueOf(dsfs.Contract_Term_months2__c),
StartDate = dsfs.Contract_Start_Date__c,
Payment_Status__c = 'Ready to be Invoiced',
AccountId = dsfs.dsfs__Company__c,
Opportunity_Name__c = dsfs.dsfs__Opportunity__c,dsfsid__c = dsfs.id);
ctr.add(c);
}
}
if(ctr.size() > 0)
{
System.debug('-ctr------->'+ctr.size());
insert ctr;
}

for(contract con : ctr){
testmap.put(con.dsfsid__c, con.id);
}
system.debug('Testmap size is '+testmap.size());

system.debug('query data'+[select id,parentid,body,name from attachment where parentid in :
testmap.keyset()]);
for(attachment att : [select id,parentid,body,name from attachment where parentid in :
testmap.keyset()]){

if(testmap.containskey(att.parentid)){
attachment a = new attachment(name=att.name,body=att.body,parentid=testmap.get(att.parentid));
attach.add(a);
}
}
system.debug('attach is '+attach);
insert attach;

}

Thanks so much!

Shannon Andreas 1
October 20, 2015
Like
1

SOLVED

4 replies

Formatting apex:inputField value attribute for Date datatype

Steve Nelson
October 20, 2015
Like
0

2 replies

Trigger on Note object not firing in production yet works fine in SB

I created a Note trigger that parses out a particular string from the title and writes it to a custom field within its parent opportunity. I have run several tests within the sandbox environment and the trigger works. When i move it to production however, the trigger does not even fire. i tried both the developer console and the eclipse environment with no luck. i tried starting from scratch and building a simple version of the trigger to make sure no errors would intervene yet the problem still exists. i even built a simular trigger yet on the attachment object and that worked. i checked to see if there are any pre existing triggers on the note object that may screw my trigger up and there arent any. i am now out of options and need asistance

simple Note Trigger

trigger InvoiceListener on Note (after insert) {

System.Debug('false: ');

    /*

    boolean b = MyMatcher.find();
     System.Debug('here');

    if(b == true){

    List<Opportunity> oppQuery = null;
       oppQuery = [SELECT Id, accountId FROM Opportunity WHERE Id= :pId ];
    Opportunity op = oppQuery.get(0);
        System.Debug(op);
        //System.Debug('true: '+MyMatcher.group().substring(1));
        //DateTime d = datetime.now();
    //string timeStr = d.format('MMMMM dd, yyyy');
        //op.Invoice_Number__c = MyMatcher.group().substring(1);
        //op.Invoice_Date__c = Date.today();
         update op;

    }
    else{
      System.Debug('false: '+descrip );
    }
*/
}

Simular working attachment trigger

trigger AttachmentTest on Attachment (after insert) {
String Title;
Id pId;

for(Attachment att: Trigger.new){
Title=att.Name;
pId=att.ParentId;
}

}

Chris Kamarianakis
September 04, 2015
Like
0

5 replies

Apex Job Aborted By User

Hi, we've just tried to ask salesforce via a case why an Apex job is marked as aborted by User (when each User denies such knowledge) and they seem to think it's a developer request and pointed us here.

Case #11212305
Original request:
Hi, please can you let me know why the batch was "Aborted By User" as no one has aborted a job. Also can you state what the underlying error is - if there is one?
Apex Job Id: 7072000000vWcRV

Since this is an internal issue, I'm assuming the only folks who can help us the Salesforce employees who patrol these boards?

Thanks in advance.