• MNRob
  • NEWBIE
  • 25 Points
  • Member since 2009

  • Chatter
    Feed
  • 1
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 4
    Questions
  • 3
    Replies
Reading through other examples and I still can't see my issue.

SELECT CSR__r.name, sum(margin__c) FROM shipment__C WHERE Actual_Delivery_Date__c = this_month  group by CSR__r.name.

If I drop the aggregate and group by my simple list comes back just fine.

Thanks in advance!
  • January 03, 2017
  • Like
  • 0

confused newbie here. I've read some previsous posts and I thought I had things right... apparently not.

I have tired  value="{!origZip}" and get save error -

ErrorError: Unknown property 'origZip' 

 

If I try value="{!rater.origZip}" and value="{!Rater__c.origZip}"/ I get

 

Error: Invalid field origZip for SObject Rater__c

 

 
Yes, I'm guessing at this point.

 

Any help would be greatly appreciated.

 

 

public class Rater{

    public String origZip {get; set;}   
    public String destZip {get; set;}
    public final Rater__c rater;

}

 

VFP

 

<apex:page StandardController="Rater__c">
    <apex:variable value="{!Rater__c}" var="rater" />
    <apex:pageBlock title="Spot Quote">
        <apex:pageblockSection>
            <apex:form>     
                <APEX:OUTPUTTEXT value="Orig Zip: "></APEX:OUTPUTTEXT>      
                <apex:inputText style="width: 50px" value="{!origZip}"/>
                <apex:outputText value="  "></apex:outputText>
                <APEX:OUTPUTTEXT value="Dest Zip: "></APEX:OUTPUTTEXT>      
                <apex:inputText style="width: 50px" />
                <apex:commandButton value="Rate"/>
            </apex:form>
        </apex:pageblockSection>
    </apex:pageBlock>
</apex:page>

  • March 04, 2010
  • Like
  • 0

I am uploading some data into custom fields to the account object using infromatica. It works great.

 

I added a trigger the is supposed to calculate the Gp Per Load when Gp or load count is updated. This works great when updating via the UI (only the administrator has rights through the UI).

 

However the trigger does not appear to fire when the data is updated/inserting from infromatica? Any thoughts?


Below is the trigger. Any help is greatly appreciated.

 

trigger updateGPPerLoadMTD on Account(before insert, before Update) {
Account newAccount= trigger.new[0];
Account oldAccount= trigger.old[0];


integer descLength;

if ((newAccount.Loads_Current_Month__c != oldAccount.Loads_Current_Month__c  ||
     newAccount.GP_Current_Month__c != oldAccount.GP_Current_Month__c ) && newAccount.Loads_Current_Month__c > 0 ) {
     newAccount.GP_Load_MTD__c = newAccount.GP_Current_Month__c /  newAccount.Loads_Current_Month__c; 
}

If (newAccount.Loads_Current_Month__c == 0){
    newAccount.GP_Load_MTD__c = 0;
}
}

  • February 15, 2010
  • Like
  • 0

We have independent sales agents who are set up as portal users since they are not employees of the company. However they do have email accounts with us and we would like to set up the outlook desktop integration for them.

 

Does anyone know of a way to do this for portal users?

 

Thanks in advance.

  • November 23, 2009
  • Like
  • 0
Reading through other examples and I still can't see my issue.

SELECT CSR__r.name, sum(margin__c) FROM shipment__C WHERE Actual_Delivery_Date__c = this_month  group by CSR__r.name.

If I drop the aggregate and group by my simple list comes back just fine.

Thanks in advance!
  • January 03, 2017
  • Like
  • 0

I am uploading some data into custom fields to the account object using infromatica. It works great.

 

I added a trigger the is supposed to calculate the Gp Per Load when Gp or load count is updated. This works great when updating via the UI (only the administrator has rights through the UI).

 

However the trigger does not appear to fire when the data is updated/inserting from infromatica? Any thoughts?


Below is the trigger. Any help is greatly appreciated.

 

trigger updateGPPerLoadMTD on Account(before insert, before Update) {
Account newAccount= trigger.new[0];
Account oldAccount= trigger.old[0];


integer descLength;

if ((newAccount.Loads_Current_Month__c != oldAccount.Loads_Current_Month__c  ||
     newAccount.GP_Current_Month__c != oldAccount.GP_Current_Month__c ) && newAccount.Loads_Current_Month__c > 0 ) {
     newAccount.GP_Load_MTD__c = newAccount.GP_Current_Month__c /  newAccount.Loads_Current_Month__c; 
}

If (newAccount.Loads_Current_Month__c == 0){
    newAccount.GP_Load_MTD__c = 0;
}
}

  • February 15, 2010
  • Like
  • 0

My company requires that I use Remote Desktop Connection to access my Outlook.  I need help in figuring out how to get my emails (sent and received) into Salesforce, without having to cut and paste them.  I cannot use Outlook Connect, since our IT folks do not want to take a chance on installing it on our exchange server. 

 

Is there a work around or app that I can use to copy my correspondence into Salesforce?  The cutting and pasting is not efficient and very time consuming.  We have called Salesforce and cannot seem to get any help.  I cannot belive that I am the only one who's company has this issue.