• CharuDutt
  • NEWBIE
  • 65 Points
  • Member since 2020

  • Chatter
    Feed
  • 2
    Best Answers
  • 0
    Likes Received
  • 1
    Likes Given
  • 2
    Questions
  • 12
    Replies
Hello everyone,

I'm currently wokring on creating a validation rule where if the field "Source" is = "Task" that it can no longer change and is "locked in" so to speak. Here's my latest attempt:

AND(
    ISCHANGED(Source),
    ISPICKVAL(PRIORVALUE(Source),"Task")
)

However, when activated I can still change Source to whatever I want. Can anyone help?
i have 3 fields 
field 1- mr
field 2- bean
in the field 3 i have to show 'mr bean '
basically i have to show the 2 fields value in the 3rd field
i have 4 checkbox field on an object and 1 pickilist field 



1>    if all four checkbox is checked picklist isequal to all active
2>    if any three checkbox is checked picklist isequal to review
3>    if any two checkbox is checked picklist isequal to approved
4>     if one or none checkbox is checked picklist isequal to rejected
Hi All,
Below is my code snippet but it is not working..


trigger Acc_Opty_Creation on Account (after insert) {
    List <Account> accList = Trigger.New;
  
    User u= [Select id from user where alias ='integ'];
    List<Opportunity> opty= New List<Opportunity>();
    List<Opportunity> opty2= New List <Opportunity>();
    
     
    for (Account a : accList){
        Opportunity op = new Opportunity();
        op.Name= a.Name+'_Opty';
        op.CloseDate=System.today()+15;
        op.StageName='Prospecting';
        op.AccountId= a.Id;
        op.OwnerId=u.Id;
        opty.add(op); 
    }
    insert opty;
    
    for (Account a : accList){
        Opportunity Op2 = new Opportunity();
        op2.Name= a.Name+'_Opty';
        op2.CloseDate=System.today()+20;
        op2.StageName='Needs Analysis';
        op2.AccountId= a.Id;
        op2.OwnerId=u.Id;
        opty2.add(op2); 
   }
   insert opty2;
}
Hello everyone,

I'm currently wokring on creating a validation rule where if the field "Source" is = "Task" that it can no longer change and is "locked in" so to speak. Here's my latest attempt:

AND(
    ISCHANGED(Source),
    ISPICKVAL(PRIORVALUE(Source),"Task")
)

However, when activated I can still change Source to whatever I want. Can anyone help?
Hi Team,

We have a requirement where two Objects Invoice and account . whenever an account is created  it should update total number of invoices and  amount on  Sum of amount object on account .

Account and Invoice object  are having lookup relationship
Account and Amount are the fileds on Invoices object
 

I need to put below validation in description field -
Allowed characters should be - a-z A-Z 0-9 Space and Special Characters are & ( ) - . and the description field  must start with a-z A-Z 

can anyone help me with regrex expression for this validation?

Hi. Can someone share the code sample on how to insert parent and child (Master-Detail relationship) in one DML? is it possible? I saw an example with External ID. but I assume it is not my case and I need to create an extra field that I don't need actually. 




 
i have 3 fields 
field 1- mr
field 2- bean
in the field 3 i have to show 'mr bean '
basically i have to show the 2 fields value in the 3rd field
We have a field called "Initial Contract Signature Date" which is a date field. This field records when the initial contract is signed. A contract can be auto-renewed monthly or annually which is indicated by a number field "Renewal Term Months". I would like to create a new formula field that calculates the "Next Renewal Date".

So if it is a 1 month renewal term, and initial contract date is 12/1/2020, then the "Next Renewal Date" would be 1/1/2021. However, I would like it to automatically update to the next month when 1/1/2021 has passed... so when I log in on 1/2/2021, the "Next Renewal Date" would update to 2/1/2021.

This would also work the same manner if it is 12 month renewal except the year would update to the next year. So if initial contract date was 1/1/2020 and the renewal term months is 12, it would show 1/1/2021. But when I look at this date again on 1/2/2021, this should automatically update to 1/1/2022.

Any help is appreciated.

 
i have 3 fields 
field 1- mr
field 2- bean
in the field 3 i have to show 'mr bean '
basically i have to show the 2 fields value in the 3rd field