Sign Up ›
  • sakthivel
  • NEWBIE
  • 0 Points
  • Member since 2012
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 8
    Questions
  • 9
    Replies
6 replies

Custom Object Records - Delete permission only for system administrator

i have a custom object which is child(B) of master object (A)

 

The delete button  should be visible to only sys admins for Object B(child), any solution ? 

1 replies

Help needed with a trigger - Update Multi Picklist from Master to Child

Sorry for the newbie question.

 

Let me try to be simple and clear as much as possible,

 

I have 2 objects, 2 fields , just want to replicate those multi picklist values from master to child

 

Project                  (Master)  - Location (Multi- Picklist)

Project Strategy  (Child)     - Location (Text)

 

Is it possible only by trigger ?

 

I tried having multiple if statement  formula , but cannot create full formula, since the multipicklist has more number values.

 

It seems formula syntax has some character limitation ;( I'm using EE , hope somebody help me on creating trigger to achieve this.

 

Thanks,

Sakthivel

5 replies

Update Opportunity Fields from Account Fields

Hello,

 

Can someone Please assure , is it possible or not on professional edition ? 

 

There is a look-up relationship in opportunity with account(Basically),

 

I have some fields on Account and same fields are there in opportunity too,

 

Most of the fields are updated on account itself, Is it possible to override the same in opportunity too with input from account object?  

 

I have only two solutions 

1. Workflow  - Professional edition doesn't support 

2. Formula - User cannot modify or enter values 

 

I want to enter the values on opportunity if values are empty coming from account..

 

Is there any way to achive it ? 

 

Please let me know for further clarifications.. 

 

 

2 replies

Report of Contacts Without Opportunities or Contact with no Opportunities

Hello,

I need to create a report with the following catagory, it may look simple but can't generate in professional edition 

All contacts without opportunity.

i have tried rollup summay field on account, it shows all contacts(with/without opportunity) related to account 

I cannot create a formula or rollup field in contact to calculate total opportunities since there is no any direct relationship between contact and opportunities.


I can create report type - opportunities with contact role but there is no cross filter functionality available on professional edition also if i use the filter contact id equal none its not at all filtering properly. This kind of relationship filter is not implemented i guess.

If anyone came across same situation and found any solution for this PLEASE help me.

Email - sthandavarayan@gtr.net

SOLVED
1 replies

Need Help on lpad formula

i want to convert 1 to 001 by workflow or anything..

 

My custom field name -  Number_of_Vacancies

 

i used this formula

 

lpad( Number_of_Vacancies2__c ,3,'0')

 

giving error, to change the filed type to text

 

lpad( text(Number_of_Vacancies2__c) ,3,'0') Not helping.. any idea ? ?

1 replies

Need help in creating a test case for scheduled apex

Can somebody help me creating a test case please...  it is a scheduled apex class, here is my code ..

 

global class FBR_ApexScheduleMonthClass Implements Schedulable
            {
                       global void execute(SchedulableContext sc)
                        {
                                    ValAdd();
                        }
 public  static void ValAdd()//Set<Id> InquiryId
  {  
  
List<FBR_Inquiry__c> Inquiry= [SELECT KPIInquiryContent__c,KPIInquiryContent__r.Account__c,CommodityName__c,ModifyDate__c,Status__c from FBR_Inquiry__c  ];
{
FBR_Inquiry__c FBR= Inquiry[0];
Date startDate=FBR.ModifyDate__c.toStartOfMonth();
Date endDate=FBR.ModifyDate__c.toStartOfMonth().addMonths(1);

LIST<AggregateResult> countmonth=[SELECT count(KPIInquiryContent__c) coun from FBR_Inquiry__c where KPIInquiryContent__r.Account__c=:FBR.KPIInquiryContent__r.Account__c and ModifyDate__c >= :startDate AND ModifyDate__c < :endDate and PayoffObject__c=:'○' and Status__c IN('対応中' ,'対応完了')];
 //LIST<AggregateResult> calmonth=[Select CALENDAR_MONTH(WorkDate__c), count(ImportCount__c) icount from WorkResultsMonth__c where Account_Name__c=:acname GROUP BY CALENDAR_MONTH(WorkDate__c)];
LIST<AggregateResult> calmonth=[Select count(ImportCount__c) icount from WorkResultsMonth__c where WorkDate__c >= :startDate and WorkDate__c < :endDate and Account_Name__c=:FBR.KPIInquiryContent__r.Account__c];

List<KPIAccident__c> acc= [SELECT MonthlyGeneratedCount__c,MonthlyPPM__c from KPIAccident__c where Account__c=:FBR.KPIInquiryContent__r.Account__c];   
if(!acc.isEmpty() )
      {
          
          KPIAccident__c accupdate = acc[0];         
          Integer totalcountmonth=Integer.Valueof(countmonth[0].get('coun')); 
          
          accupdate.MonthlyGeneratedCount__c=totalcountmonth;   
         
          Integer totalmonthwork= Integer.Valueof(calmonth[0].get('icount'));
          accupdate.MonthlyPPM__c=(totalmonthwork/totalcountmonth*1000000);
          update accupdate;
      }else 
      {
         KPIAccident__c kpi = new KPIAccident__c();
         List<KPIAccident__c> ToUpdate = new List<KPIAccident__c>(); 
        // kpi.Date__c=FBR.ModifyDate__c;         
          kpi.Account__c=FBR.KPIInquiryContent__r.Account__c;         
        // kpi.itemname__c= FBR.CommodityName__c;     
         
         Integer totalcountmonths=Integer.Valueof(countmonth[0].get('coun'));
         kpi.MonthlyGeneratedCount__c=totalcountmonths; 
         Integer totalmonthworks= Integer.Valueof(calmonth[0].get('icount'));
                    
         kpi.MonthlyPPM__c=(totalmonthworks/totalcountmonths*1000000);
         ToUpdate.add(kpi);
         insert ToUpdate;

} 

}
} }
2 replies

Formula to display a name of the months ?

In Opportunity i have the fields - start date & end date

 

Depending on the fields i want to display names in between the two dates..

 

 please see the screenshot Attached

 

 

 

 

4 replies

Need Trigger Update

Requirement : 

 

I need to calculate total number of days to close for the each opportunities.

 

Criteria - 

 

I have a custom field Days to close

 

Whenever a opportunity record reaches stagename = closed won or lost

 

-  it should update the field Days to close by calculating the total number of days between the record created and stagename = closed won or lost

 

Sorry if it is confusing, as a newbie i cant explain clearly , still if anybody knows the situation pls help me to create the trigger to update.

 

Thanks in advance

2 replies

Saving different records depending on different picklist

Hi,

I have a picklist consisting different picklist Values.(A,B,C)

There consists of a default edit page ,and also when a person selects a picklist value as A, few more section gets visible,when a person selects B,few more section gets visible and so on.

My requirement is :

Suppose i am selecting picklist A ,then while saving it should save the record along with the Section which gets enabled when the picklist value A is selected.

For the record saved under A,it shouldnt consists of fields which belongs to B & C.

Thanks in Advance for assistance on the above topic.

Regards,
Rabi

  • April 26, 2013
  • Like
  • 0
6 replies

Custom Object Records - Delete permission only for system administrator

i have a custom object which is child(B) of master object (A)

 

The delete button  should be visible to only sys admins for Object B(child), any solution ? 

1 replies

Help needed with a trigger - Update Multi Picklist from Master to Child

Sorry for the newbie question.

 

Let me try to be simple and clear as much as possible,

 

I have 2 objects, 2 fields , just want to replicate those multi picklist values from master to child

 

Project                  (Master)  - Location (Multi- Picklist)

Project Strategy  (Child)     - Location (Text)

 

Is it possible only by trigger ?

 

I tried having multiple if statement  formula , but cannot create full formula, since the multipicklist has more number values.

 

It seems formula syntax has some character limitation ;( I'm using EE , hope somebody help me on creating trigger to achieve this.

 

Thanks,

Sakthivel

5 replies

Update Opportunity Fields from Account Fields

Hello,

 

Can someone Please assure , is it possible or not on professional edition ? 

 

There is a look-up relationship in opportunity with account(Basically),

 

I have some fields on Account and same fields are there in opportunity too,

 

Most of the fields are updated on account itself, Is it possible to override the same in opportunity too with input from account object?  

 

I have only two solutions 

1. Workflow  - Professional edition doesn't support 

2. Formula - User cannot modify or enter values 

 

I want to enter the values on opportunity if values are empty coming from account..

 

Is there any way to achive it ? 

 

Please let me know for further clarifications.. 

 

 

2 replies

Formula to display a name of the months ?

In Opportunity i have the fields - start date & end date

 

Depending on the fields i want to display names in between the two dates..

 

 please see the screenshot Attached

 

 

 

 

4 replies

Need Trigger Update

Requirement : 

 

I need to calculate total number of days to close for the each opportunities.

 

Criteria - 

 

I have a custom field Days to close

 

Whenever a opportunity record reaches stagename = closed won or lost

 

-  it should update the field Days to close by calculating the total number of days between the record created and stagename = closed won or lost

 

Sorry if it is confusing, as a newbie i cant explain clearly , still if anybody knows the situation pls help me to create the trigger to update.

 

Thanks in advance