I have a text-field, that I want to fill with the content of another text-field (MCE_Product__r.Name) and the Year and Month of column End_Date__c.

 

Could someone help me with the correct coding ?

 

Text Options

• *A blank value (null)
• *Use a formula to set the new value

  Hide Formula Editor

  Insert Operator + Add- Subtract* Multiply/ Divide^ Exponentiation( Open Parenthesis) Close Parenthesis& Concatenate= Equal<> Not Equal< Less Than> Greater Than<= Less Than or Equal>= Greater Than or Equal&& And|| Or  Formula Value (Text) = MCE_Product__r.Name & YEAR( End_Date__c ) & MONTH( End_Date__c ) Error: Incorrect parameter for function &(). Expected Text, received Number Use formula syntax: e.g., Text in double quotes: "hello", Number: 25, Percent as decimal: 0.10, Date expression: Today() + 7

  Functions -- All Function Categories --Date & Time Logical Math Text Advanced ABS AND BEGINS BR CASE CEILING CONTAINS DATE DATEVALUE DAY EXP FIND FLOOR GETSESSIONID IF ISCHANGED ISNEW ISNULL ISNUMBER ISPICKVAL LEFT LEN LN LOG LOWER LPAD MAX MID MIN MOD MONTH NOT NOW NULLVALUE OR PRIORVALUE REGEX RIGHT ROUND RPAD SQRT SUBSTITUTE TEXT TODAY TRIM UPPER VALUE YEAR

trigger Before_Insert_Special_Event on SFDC_Special_Event__c (before insert) {

 

for (SFDC_Special_Event__c se : Trigger.New)

{

se.Name = se.MCE_Product__r.Name;

se.Description__c = se.Workshop_Name__c;

}

}

 

Instead of uning Autonum, I want to structure my "Name"-field myself. Unfortunately, it doesn't work the way I code it.

 

I want to combine in Name, a data field and a sequence, but even filling it with an existing column doesn't work. Since the field is not filled manually, the system says : "You have to fill the Name-field". Description-field works properly.

 

Could someone give me a hint, to solve this problem ?

 

Thanks

trigger After_Insert_On_Lead on Lead (after insert) {
Opportunity a = new Opportunity(name='Automatically created from Lead',
StageName = 'Pending',
CloseDate = date.newInstance(2008, 10, 28),
Nextstep = 'Visit');
Insert a;
}

How can I refer to the values of the inserted Lead ? For instance, I want to copy the value of the newly created Lead in an Opportunity field.

Can i make a custom field dynamically read-only or editable, depending on the value of another custum column ?

Example: I want all my custom fields, related to cancellation info, to be read-only if product_stage is not cancelled, and editable if product_stage is cancelled

In a validation trigger, I want to use only Opportunities created in 2008;

So, I want to include this condition in my validation trigger.

Problem is to find the correct coding for replacing the ISNEW() by CREATEDDATE >= '2008-01-01'

Rule Name	Opportunity_Category	Active
Error Condition Formula	AND( OR(ISPICKVAL(StageName,"Pending."), ISPICKVAL(StageName,"Tentative."), ISPICKVAL(StageName,"Accepted."), ISPICKVAL(StageName,"Signed."), ISPICKVAL(StageName,"Refused."), ISPICKVAL(StageName,"Cancelled."), ISPICKVAL(StageName,"Declined."), ISPICKVAL(StageName,"Aborted."), ISPICKVAL(StageName,"On Hold.")), ISPICKVAL(Opportunity_Category__c,""), ISNEW() )
Error Message	As of Stage='Pending', Opportunity Category should be present	Error Location	Opportunity Category
Description	As of stage = 'Pending', Opportunity Category has to be present
Created By	Roger Vangoidsenoven, 12/02/2008 13:14	Modified By	Roger Vangoidsenoven, 13/02/2008 10:06

trigger After_Insert_On_Lead on Lead (after insert) {
Opportunity a = new Opportunity(name='Automatically created from Lead',
StageName = 'Pending',
CloseDate = date.newInstance(2008, 10, 28),
Nextstep = 'Visit');
Insert a;
}

How can I refer to the values of the inserted Lead ? For instance, I want to copy the value of the newly created Lead in an Opportunity field.

Can i make a custom field dynamically read-only or editable, depending on the value of another custum column ?

Example: I want all my custom fields, related to cancellation info, to be read-only if product_stage is not cancelled, and editable if product_stage is cancelled