Does Roll Up Summary field supports formulas with expressions?

Thanks

Sankar

Hi Friends,

I have a visual force page where i was displaying records with the field createdby.name. This was working for me before summer 12 release.

After i activated summer 12 release, createdby.name field does not show the value. The query have the value but when showing them in partner portal, it is not showing up.

If anyone have any idea on this issue please let me know.

Thanks.

Hi Friends,

When I try to accept the case records from the queue I am getting the following error message

"This profile is not setup to accept cases from queue"

I am already the member of the queue. The OWD is Private to the Case object.

My profile is having access to "Transfer Record" permission also having full access over case C, R, E, D, View All, Modify All.

But I still get the error while accepting the case from the queue.

Could anyone help me out in this issue???

Thanks in Advance.

Thanks,

Elavarasan N.

Hi Guys,

I have a requirement to count the no. of cases attached to an account.

We dont have have a roll-up summary field for this. So that i have created a trigger to do this (on Case object while insert, update, delete). It was working fine but later i fouint that while merging two accounts this case count is not getting updated. So that i have return on more trigger while updating an account so that i can get the correct case count.

But an account is having 1500 cases. While updating one of its cases its thrwing an error saying "too many query rows". While deactivate the trigger which return on account the updation happens without any error.

In the same way while updating 1000 account records at a time its throwing the same error. While deactivating the case trigger its working fine.

I am not able to understand this.

Please suggest me a way.

Trigger under account:

trigger updateNoOfCases on Account (after update) { try { for(Account accTemp : Trigger.new) { List<Case> caseList = new List<Case> (); caseList = [select id from Case where AccountId = :accTemp.Id]; if (accTemp.of_cases_attached__c != caseList.size()) { accTemp.of_cases_attached__c = caseList.size(); } } } }

Trigger on Case:

if(Trigger.isupdate) { List<Account> accountsWithCases= [select id, of_cases_attached__c, (select id from Cases) from Account where Id IN :Trigger.newMap.keySet() or Id In : Trigger.oldMap.keySet()]; for(Account a :accountsWithCases) { Integer count=0; for(Case caseObj : a.cases) { count++; } a.of_cases_attached__c=count; accObj.add(a); } update accObj; }

Hi Friends,

I have written a trigger to update the "Total case attached(custom field on account)" to particular account.

Its working fine.

But for the existing accounts its not getting reflected.

So i have return one class to call from the Systemlog, so that it will go and update the account field.

But its saying like size exceed:1134 records. It seems like list can accomadate 1000 records.

Kindly give me a solution.

public class UpdateexistingAccountCaseRollup{ public static void updateAccountCases(){ List<Account> a = [select Id,of_cases_attached__c, service_location__c, (select Id from cases) from account]; List<Account> acc2=new List<account>(); for(Account acc : a) { List<Case> cases = acc.cases; acc.of_cases_attached__c = cases.size(); System.debug('***'+cases.size()); acc2.add(acc); } update acc2; } }

Thanks,

Ghilli.

Hi Friends,

I have requirement like i need to repeat a list to show the label of the field in front end

While user select the field and save the data, only the api name of the field should get stored in DB.

Controller:

----------- 

List<String> fieldList = new List<String>(); 

 Map<String, Schema.SObjectField> fMap = Schema.SObjectType.Account.fields.getMap();
         List<Schema.SObjectField> fTokens = fMap.values() ;

            for( Integer i = 0 ; i < fTokens.size() ; i++ )
               {
                     Schema.DescribeFieldResult f = fTokens.get(i).getDescribe();
                     if( f.isAccessible())  { 
                      fieldList.add(f.getLabel());  
                     fieldList.add(f.getName()); 

              }

VF Page:

----------

 <apex:repeat value="{!matrix}" var="r" id="segId2">
            <td width="10%">
                 <apex:repeat value="{!r}" var="c" id="fldd">
                    <apex:inputCheckbox id="chk"  value="{!c}" onclick="return getValues(this,'{!$Component.fieldVal}','{!$Component.MarSeg}','{!$Component.hidd}');"/> <apex:outputLabel value="{!c}" id="fieldVal">
                    </apex:outputLabel>
                    <br />
                 </apex:repeat>

Here I need to use lable to display in the front end and while click save button i need to save button of the specific field into the DB.

Kindly suggest me a solution for this.

Any help is appreciated.

Thanks,

Ghilli.

Hi,

I have a requirement like this:

I have four record types for Opportunities. we can say RT1, RT2, RT3, RT4.

I have a field Type in Account object.

I need to display only 3 record types and want to hide the RT4 if the opportunity is created from the account whose type is not partner.

If oppty is created from the opportunity tab we can restrict through validation rule.

But when creating from the accout related list(whose type is not partner), i need to able to select only 3 record types rather than 4.

Please sugggest a way to do this.

Thanks,

Ghilli.

Hi Friends,

I want to batch submit all of the forecasts which are owned by the salesrep(role based) and also i want to do this job for every one month period.

Can we schedule this through apex data loader????

If yes please tell met he way to do this.

If No please suggest me a way to do this task.

Thanks,

Ghilli.

Hi Friends,

I am having 5 profiles in my developer account lets say profile 1, profile 2,..........profile 5.

I have given read, write permission for profile 1 on account object and only read permission for all other profiles from 2 to 5.

So that profile 1 user can able to add notes & attachments on account, others wont since they dont have the edit permission on accounts.

But profile 2 user need to add notes and attachments for an account. If i give edit permission for him, he will get edit permission for all other items in accounts. I want to give him access only to create notes and attachments.

Please tell me how to do this

also suggest me a solution for this requirement.

Thanks,

Ghilli.

Hi Friends,

I am trying to integrate SAP with salesforce.

Please tell the way to do this using freewares.

Is there any tools or services provided by salesforce for this integration???

Also please tell me about "Integration as a Service" provided by salesforce.com?????

Please reply for this.

Thanks. 

Hi,

I have a scenario like this:

"Need to test how to do this: If SalesRep is in Station/Lettered Territory but Account is in Enterprise Terrotory, how do they make the Oppty territory get auto populated".

Please help me out in this to proceed further.

Its a critical requirement for my project.

Thanks,

Elavarasan.

Test Territory Assignment - Accounts created by a Sales Rep who only has one territory should automatically be assigned to the reps territory. Please figure out how to make that work.

This is my project requirement .Can anyone tell me how to proceed with this .

Regards,

Ram

Hi Friends,

I have one requirement in that if a Status check box is checked for a account, that account should not be edited by the user.

How to make this account as readonly.

Please guide me to do this.

Thanks.

Hi Friends,

IMAGE(
CASE(Marked_for_deletion__c,
"FALSE", "/img/samples/light_green.gif",
"TRUE", "/img/samples/light_red.gif",
"/s.gif"),
"Marked For Deletion Flag")

Here Marked_for_deletion__c is a checkbox. so i used TRUE and FALSE in the case functions.

But its showing error Like " Error: Incorrect argument type for function CASE(). "

Kindly help me out in this.

Thanks.

Hi All,

I have one requirement like i need to update the field 'Status'(custom field added to Account) to 'Yes' while attachment is added to the account. If no attachment is there under account the status to be changed to 'No'.

Kindly let me know where i need to trigger the event.

If we need to use Apex/VFPage, guide me to do that.

Thanks.

Hi Friends,

Kindly help me fo do this.

When i try to add a roll up summary field in account to count the cases, its showing the case object in the summarized object picklist.

 So how to do this???

Trigger???

Kindly help me out in this.

Thanks.

Hi Friends,

I need to disable the status picklist of the Oppurtunity standard object.

Kindly let me know how to do this.

Thanks.

Hi Friends,

I have one requirement like this.

I have once salesforce account, i am writing one apex class and generating the WSDL.

I need to use this WSDL to create a apex class in diff salesforce account.

After creating apex class from the WSDL what i need to do in order to access the method which is there in WSDL.

Kindly help me out in this.

Regards,

Elavarasan N.

Hi Friends,

I have created one approval process on Oppourtunity object.

And I have set the initial submitter as record owner.

If i create a new opportunity record, its getting created. But i can not find the Submit for Approval button in the related list.

In fact i can not find the Approval history relationlist itself.

Kindly help me out in this.

Thank you very much.

Hi Friends,

I have Eclipse, Apache Axis, Apache Tomcat server installed seperatly.

How to make an environment to develop web services using java with the above said tools.

How can i configure eclipse to write a web service using java and axis.

Kindly tell me the steps to configure the eclipse with WSDL and Axis.

Thank you.

Hi Friends,

I have a visual force page where i was displaying records with the field createdby.name. This was working for me before summer 12 release.

After i activated summer 12 release, createdby.name field does not show the value. The query have the value but when showing them in partner portal, it is not showing up.

If anyone have any idea on this issue please let me know.

Thanks.

Hi all,

I have a question, my case is I two profiles, one for Admin and other for Non Admin.

I have my page and class in Enable visualforce access & Enable apex class access in Non Admin profile.. All fields level security have been checked.. All the Custom Object Permissions hae been checked

There is a button call Visualforce page in a custom object.

For Admin profile everything works fine.

In Non Admin Profile, if View Setup and Configuration permission is checked, accessing the visualforce page works fine. If View Setup permission is unchecked, I can access to visualforce page but after I select any picklists in visualforce page -> Insufficient Privileges error message is shown

Are there any settings that need to be done? Any suggestions would be great..

Thanks

Hello All,

I have a Visualforce Page which  when viewed as an Admin works fine, the page has a rerender portion when on selecting a value from a drop down a couple of text boxes get rerendered.

I logged in as a different user and the page shows up fine, when i change the drop down the rerender gets called and i end up getting the message

"Insufficient Privileges You do not have the level of access necessary to perform the operation you requested. Please contact the owner of the record or your administrator if access is necessary. "

The VF page, the apex class, the extension class, the objects used (have C R E D), all have the permissions for this profile. Also, all fields of the associated objects are visible to this profile.

With this error message i am unable to get any clue of what is happening actually, it's just supposed to rerender a few text boxes which are not associated with any access privileages.

Moreover, the debug log says "SUCCESS" and all getter and setter methods are called fine. Its only when the page refreshes itself that something goes wrong somewhere.

Please let me know your thoughts.

Thanks,

Edwin

Does Roll Up Summary field supports formulas with expressions?

Thanks

Sankar

I have person accounts enabled for my organization.

I am trying to update a contact record. When I execute update query and if the contact record is my person account, it throws me below error:

INVALID CROSS REFERENCE KEY

Cannot select a person account.

I can understand that the contact record is actually referring to person account .. but then why should I able to select it using - select id from contact where id = 'personaccountid'?  

If anybody knows the resolutions, please do let me know.

Regards,

Chandrakant M

Hi,

Can we customize the batch submit around Forecasting to set it at a timestamp.Something like the Forecast batch submit should run automatically at 00:00 hrs at the end of quarter.

Is this feasible. Any help is welcome.

Thanks & Regards,

Heena Bhatnagar

Hi

I am fairly new to Force.com development and have hit an issue trying to build some relationships on a custom object.

I have an 'Assessment' custom object with a custom lookup field to a 'Claim' custom object.  I want to build a further custom lookup field on Assessment: 'Claim Contact' that looks up from another custom object, but this object is the detail in a master-detail relationship with the Claim object. 

I want to know how to constrain the 'Claim Contact' lookup so that it only shows values that are related to the Claim that has already been looked up on to the Assessment.

i.e. if the Assessment is linked to Claim A, which has child Contacts Jack and Jill, then these should be the only contacts I am able to pick using the 'Claim Contact' lookup on the Assessment.  If the assessment is not linked to any Claim then I need the lookup to return no results.

Is there a configuration solution to this or if not does anyone know what the best approach is to do this?

Many thanks in advance!

Hi Friends,

I have one scenario in that i need to send the account details to the owner's mobile phone.

I am using the following code to do that. But while executing its asking for the user id and password.

If i gave that also its again loading the same the page.

Please help me to rectify this.

The code is :

<html> <head> <script type="text/javascript" src="/js/functions.js"></script> <script src="/soap/ajax/10.0/connection.js"></script> <script type="text/javascript"> function init() { alert("hi"); var carrier = "{!User.Cell_Phone_Carrier__c}"; alert("hi4"+carrier); if ( carrier == "" ) { alert( "No cell phone carrier specified" + " in your personal information"); setTimeout("window.close();",100); return; } var cell_number = "{!User.MobilePhone}"; alert("hi5"+cell_number); if ( cell_number == "" ) { alert( "No cell phone number specified"+ " in your personal information"); setTimeout("window.close();",100); return; } var l = window.location; alert("hi2"+l.href); if ( l.protocol == "https:") { l.href = l.href.replace(/https/,'http'); alert("hi3"+l.href); return; } sforce.connection.remoteFunction( {url :"http://www.google.com/sendtophone",mimeType: "text/plain",requestHeaders:{"Content-Type":"application/x-www"+ "-form-urlencoded"}, method: "POST", requestData: "gl=US&hl=en"+ "&client=navclient-ffsms"+ "&c=1&carrier="+ carrier+ "&subject={!Account.Name}"+ "&text={!Account.BillingStreet}\n"+ "{!Account.BillingCity}"+ "&mobile_user_id="+ cell_number, async: true, onFailure : done, onSuccess : done}); } function done( response ) { alert("hi6"); document.getElementById('sendtophone'). innerHTML = response; setTimeout("window.close();",5000); } </script> </head> <body onload="init();"> <div id="sendtophone" > </div> </body> </html>

Thanks

I have a problem: we should fire a trigger after a file was attached to a custom object. Unfortunately the “after insert” and the “before insert” event on the Attachment object doesn’t get fired (but the after delete event does but we don't need that).

Does anybody has an  idea why? It can't be the code, it's just debugoutput. Or any workaroung?