You need to sign in to do that
Don't have an account?
JohnThomas
Campaign Summary Tab
Does anyone have some sample code to get me started on creating a Campaign Summary Tab that will display a sortable table containing all active campaigns at the beginning of each row, with associated campaign result fields (Total Contacts, Total Responses, Num Sent, etc.) going across to the right. I need a dropdown to select between All Active Campaigns and My Active Campaigns, then sorted by campaign Type. This needs to be on a Tab called Campaign Metrics.
Thx.
Maybe the s-controls in this free app from sf.com on the appexchange might be a useful starting point and shorten the development cycle;
http://www.salesforce.com/appexchange/detail_overview.jsp?NavCode__c=&id=a0330000002NegDAAS
I need to have the Campaign Detail page, for each campaign.name in the Campaign Name column, to open in a separate popup window onClick.
Any ideas on how to popup the view?
thx, JT
DRAFT 1:
<apex:page controller="dataTableCon" id="CampMetrx" showHeader='true'>
<apex:pageBlock title="Campaigns">
<apex:stylesheet value="{!$Resource.Global}"/>
<apex:dataTable value="{!campaigns}" var="campaign" id="MetrxTable" rowClasses="odd,even" cellpadding="10" styleClass="tableClass" bgcolor="#F3F3EC" onRowMouseOver="hiOn(this);" onRowMouseOut="hiOff(this);">
<apex:facet name="header"><b>Campaign Metrics</b></apex:facet>
<apex:column>
<apex:facet name="header">Campaign Name</apex:facet>
<apex:outputText value="{!campaign.name}" styleClass="global"/>
</apex:column>
<apex:column>
<apex:facet name="header">Owner</apex:facet>
<apex:outputText style="font-style:italic; font-size:12px" value="{!campaign.owner.name}"/>
</apex:column>
<apex:column>
<apex:facet name="header">Selected</apex:facet>
<apex:outputText value="{!campaign.Total_Emails_Selected__c}" styleClass="global"/>
</apex:column>
<apex:column>
<apex:facet name="header">Delivered</apex:facet>
<apex:outputText value="{!campaign.Total_Emails_Delivered__c}" styleClass="global"/>
</apex:column>
<apex:column>
<apex:facet name="header">Open</apex:facet>
<apex:outputText value="{!campaign.Cmpn_Total_Open__c}" styleClass="global"/>
</apex:column>
<apex:column>
<apex:facet name="header">Click/Open %</apex:facet>
<apex:outputText value="{!campaign.Click_Open_Ratio__c}" styleClass="global"/>
</apex:column>
<apex:column>
<apex:facet name="header">Clicks</apex:facet>
<apex:outputText value="{!campaign.Cmpn_Total_Clicks__c}" styleClass="global"/>
</apex:column>
<apex:column>
<apex:facet name="header">Unsubs</apex:facet>
<apex:outputText value="{!campaign.Unsubscribe_Rate__c}" styleClass="global"/>
</apex:column>
<apex:column>
<apex:facet name="header">Bounces</apex:facet>
<apex:outputText value="{!campaign.Cmpn_Total_Bounces__c}" styleClass="global"/>
</apex:column>
<apex:column>
<apex:facet name="header">Hard</apex:facet>
<apex:outputText value="{!campaign.Cmpn_Hard_Bounces__c}" styleClass="global"/>
</apex:column>
<apex:column>
<apex:facet name="header">Soft</apex:facet>
<apex:outputText value="{!campaign.Cmpn_Soft_Bounces__c}" styleClass="global"/>
</apex:column>
</apex:dataTable>
</apex:pageBlock>
</apex:page>
DRAFT 2:
<apex:page controller="dataTableCon" id="CampMetrx" showHeader='true'>
<apex:stylesheet value="{!$Resource.Global}"/>
<apex:pageBlock title="Campaigns">
<apex:form>
<apex:dataTable value="{!campaigns}" var="campaign" border="1 "id="MetrxTable" rowClasses="odd,even" cellpadding="10" styleClass="tableClass" bgcolor="#F3F3EC" onRowMouseOver="hiOn(this);" onRowMouseOut="hiOff(this);">
<apex:facet name="header"><b>Campaign Metrics</b><hr /></apex:facet>
<apex:facet name="header">Campaign Name</apex:facet>
<apex:column>
<apex:outputPanel>
<apex:actionSupport event="onmouseover" rerender="detail">
<apex:param name="cid" value="{!campaign.id}"/>
</apex:actionSupport>
{!campaign.Name}
</apex:outputPanel>
</apex:column>
<apex:column>
<apex:facet name="header">Owner</apex:facet>
<apex:outputText style="font-style:italic; font-size:12px" value="{!campaign.owner.name}"/>
</apex:column>
<apex:column>
<apex:facet name="header">Selected</apex:facet>
<apex:outputText value="{!campaign.Sevista_Total_Emails_Selected__c}" styleClass="global"/>
</apex:column>
<apex:column>
<apex:facet name="header">Delivered</apex:facet>
<apex:outputText value="{!campaign.Total_Emails_Delivered__c}" styleClass="global"/>
</apex:column>
<apex:column>
<apex:facet name="header">Opens</apex:facet>
<apex:outputText value="{!campaign.Cmpn_Total_Open__c}" styleClass="global"/>
</apex:column>
<apex:column>
<apex:facet name="header">Clicks</apex:facet>
<apex:outputText value="{!campaign.Cmpn_Total_Clicks__c}" styleClass="global"/>
</apex:column>
<apex:column>
<apex:facet name="header">Click/Open %</apex:facet>
<apex:outputText value="{!campaign.Click_Open_Ratio__c}" styleClass="global"/>
</apex:column>
<apex:column>
<apex:facet name="header">Unsubs</apex:facet>
<apex:outputText value="{!campaign.Cmpn_Total_Unsub__c}" styleClass="global"/>
</apex:column>
<apex:column>
<apex:facet name="header">Unsub %</apex:facet>
<apex:outputText value="{!campaign.Unsubscribe_Rate__c}" styleClass="global"/>
</apex:column>
<apex:column>
<apex:facet name="header">Bounces</apex:facet>
<apex:outputText value="{!campaign.Cmpn_Total_Bounces__c}" styleClass="global"/>
</apex:column>
<apex:column>
<apex:facet name="header">Hard</apex:facet>
<apex:outputText value="{!campaign.Cmpn_Hard_Bounces__c}" styleClass="global"/>
</apex:column>
<apex:column>
<apex:facet name="header">Soft</apex:facet>
<apex:outputText value="{!campaign.Cmpn_Soft_Bounces__c}" styleClass="global"/>
</apex:column>
</apex:dataTable>
<apex:commandButton action="{!print}" value="Print" id="theButton"/>
</apex:form>
</apex:pageBlock>
<apex:outputPanel id="detail">
<apex:actionStatus startText="Requesting...">
<apex:facet name="stop">
<apex:detail subject="{!$CurrentPageReference.parameters.cid}" relatedList="false" title="false"/>
</apex:facet>
</apex:actionStatus>
</apex:outputPanel>
</apex:page>
Message Edited by JohnThomas on 04-28-2008 08:27 PM