Sign Up ›
  • Camila Heitz
  • NEWBIE
  • 10 Points
  • Member since 2014
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 8
    Questions
  • 11
    Replies
10 replies

Change case status upon its opening

Hello everyone,

I have cases being created from different channels: email to case, web to lead, etc.
These cases are created with a New status, and I would like the case status to change to Opened automatically, when the case is opened for the first time.
Is this possible without programming a trigger? Any suggestions will do.

Thank you.
6 replies

Publish a comment on a case without an assigned contact

Hello everyone,

I have cases created via email-2-case in which I get the email adress saved (in the case as a web address), but that doesn't necessarily mean that person is a contact or will be.
I would like to know if there's a way to publish o send a new case comment to that email address that has been saved. It seems right now that it's not possible to publish a case comment (or not publish it but get that comment to the web address) if the case is not assigned to a contact.

I have thought of creating a hidden case comment on the case object, but I don't really know to fill in that field every time a new case comment is created. If someone would have a suggestion on how to do this, I guess I could fire a workflow rule to send an email alert everytime the hidden case comment changes.

Thank you.
2 replies

Publish a case comment on case without assigned contact

Hello everyone, 

I open cases from anonymous users (potential customers) and I have their email addresses saved inside the case. I would like to send the case to that email adress but I don't want to create a contact for that email person because it is not a client yet.
Is this possible?
Thank you.
2 replies

Render as PDF won't read my CSS

I'm trying to do border-radius and @font-face in apex (inside the style tag, inside the head tag)
and this doesn't work.
Any ideas on this?

Thank you!
2 replies

Splitting datatable in pdf onto separate pages

Hello,

I have my header and my footer showing on every page, but the pagination isn't right since my footer covers my content.
Any idea on what I can do?
Thank you!

Here's my code:
<apex:page controller="cnReportHoras" showHeader="false" standardStylesheets="false" renderAs="pdf">
   
    <apex:stylesheet value="{!URLFOR($Resource.Estatico, 'css/Style.css')}"/>
     <head>
    
    <link href="https://fonts.googleapis.com/css?family=Comfortaa:300,400,700" rel="stylesheet" type="text/css" />
    <link href="https://fonts.googleapis.com/css?family=Roboto:100,400,300" rel="stylesheet" type="text/css" />
   
     <style>
     @font-face {
  font-family: 'Comfortaa';
  font-style: normal;
  font-weight: 300;
  src: local('Comfortaa Light'), local('Comfortaa-Light'), url(https://themes.googleusercontent.com/static/fonts/comfortaa/v5/r_tUZNl0G8xCoOmp_JkSCnhCUOGz7vYGh680lGh-uXM.woff) format('woff');
}

    table {
    -fs-table-paginate: paginate;
    }
   
    table tr{
    page-break-inside:avoid;
}

#footer_container {
bottom:0;
left:0;
position:fixed;
width:100%;
}
        
#footer {
margin:0 auto;
}

   
#header-cont {
    width:100%;
    position:fixed;
    top:0px;
}

#header {
   
 
margin:0px auto;
}

@page{
    @bottom-left {                
    content: element(footer);    
    }
    @top-right {
    content: "Page " counter(page) " of " counter(pages);
   
    }
    @top-left-corner {
    content: element(header);
    }
   
    margin-top:2cm;
    margin-left:1.54cm;
    margin-right:1.54cm;
    margin-bottom:2cm;
}

div.footer {
display: block;
padding: 5px;
position: running(footer);
}

.pagenumber:before {
content: counter(page);
}

.pagecount:before {
content: counter(pages);
}
     </style>
     </head>
     
     <div id="header-cont">
    <div id="header">
    <img src="{!URLFOR($Resource.Estatico, 'img/s4gheader.png')}" width="100%"/>
    </div>
    </div>
    <div class="clear" style="height:30px;" />
    
   
    
   <body style="margin-top:200px; margin-bottom:60px; font-family: 'Comfortaa'">
  
    <table width="100%" class="tablaGral" >
        <tr>
            <td width="70%">
                <img src="{!URLFOR($Resource.Estatico, 'img/s4g-status.png')}" width="100%" />
             </td>
            
             <td width="30%">
            
               <table class="tableC">
                  <tr>
                       <td>HORAS CONTRATADAS:  </td>
                       <td>{!proyectos[0].horasEstimadas} hrs.</td>
                  </tr>
                  <tr>
                       <td style="vertical-align:middle;">CONSUMO: </td>
                       <td>
                       <apex:image id="activo" value="{!URLFOR($Resource.Estatico, 'img/render1.png')}" width="60" rendered="{!if(proyectos[0].percConsumido<100,true,false)}" />
                       <apex:image id="agotado" value="{!URLFOR($Resource.Estatico, 'img/render2.png')}" width="60" rendered="{!if(proyectos[0].percConsumido>=100,true,false)}" />                      
                      </td>
                  </tr>
                  <tr>
                       <td>TODAVIA QUEDAN: </td>
                       <td>{!proyectos[0].horasRestantes} hrs.</td>
                  </tr>
               </table>
              
             </td>
         </tr>
        
         <tr>
             <td width="20%">
                 <table width="85%">
                     <tr>
                         <th>Cliente </th>
                         <th>Fecha inicio</th>
                         <th>Fecha cierre</th>
                     </tr>
                     <tr>
                     <td>{!proyectos[0].cliente}</td>
                     <td style="color:red;">
                         <apex:outputText value="{0,date,MM'/'dd'/'yyyy}">
                            <apex:param value="{!proyectos[0].comienzoPlanificado}" />
                         </apex:outputText>
                     </td>
                     <td style="color:red;">
                         <apex:outputText value="{0,date,MM'/'dd'/'yyyy}">
                            <apex:param value="{!proyectos[0].finPlanificado}" />
                         </apex:outputText>
                     </td>
                     </tr>
                 </table>
             </td>
             <td width="80%">
             </td>
         </tr>
        
        
     </table>
     
  
    <div class="clear" style="height:50px;"/>
    <div class="panel panel-vercasos" style="border: 1px solid; ">
  
 
       
         <apex:pageBlock title="Peticiones">
        <apex:pageBlockTable value="{!peticiones}" var="peticion" id="tablaPeticiones" styleClass="table" cellspacing="10" rowClasses="odd,even">
                <apex:column >
                        <apex:facet name="header">Petición</apex:facet>
                        <apex:outputField value="{!peticion.Id_Peticion__c}"/>
                </apex:column>
                <apex:column >
                        <apex:facet name="header">Asunto</apex:facet>
                        <apex:outputField value="{!peticion.subject}"/>
                </apex:column>
                <apex:column >
                        <apex:facet name="header">Horas</apex:facet>
                        <center><apex:outputField value="{!peticion.Horas_estimadas_peticion__c}" /></center>
                </apex:column>
                <apex:column >
                        <apex:facet name="header"><center>Estado</center></apex:facet>
                        <apex:outputField value="{!peticion.Estado_Peticion__c}" />
                </apex:column>
                <apex:column >
                        <apex:facet name="header">Fecha Petición</apex:facet>
                        <center><apex:outputField value="{!peticion.Fecha_Estimada_Peticion__c}" /></center>
                </apex:column>
        </apex:pageBlockTable>
        </apex:pageBlock>
   
    <div class="clear" style="height:20px;" />
   
  
    </div>
   </body>
  
  
   <div id="footer_container">
    <div id="footer">
        <img src="{!URLFOR($Resource.Estatico, 'img/s4gfooter.png')}" width="100%" height="100%"  />
    </div>
    </div>

  
    
</apex:page>
SOLVED
7 replies

Splitting datatable in pdf onto separate pages

Hi,

 

My knowledge on coding is very basic so I am not sure it is possble to do what I'd like or if I have to find an alternate solution.   Basically I am rendering a pdf which lists of of the delegates who have attended a training course and stating if they have passed or failed. 

 

I am doing this in a pdf attachment to an email.  I had it working fine until I found a course with 30+ delegates as the table just continues to render over the page footer and beyond.  Is there anyway to easily split this table after 30 entries (I would like to avoid anything creating controllers etc as they are over my head)?

 

This is my code (the red section is the data table):

 

<messaging:attachment renderAs="pdf"  filename="Exam results notification">
<html>
<head><style type="text/css" media="print">
body {color:#666666; font-family:"Arial Unicode MS"; font-size:11pt; font-style:normal; }

@page{
    @bottom-left {                  
    content: element(footer);      
    }   
    size: A4 portrait;
    margin-top:0cm;
    margin-left:0cm;
    margin-right:0cm;
    margin-bottom:0cm;  
}

div.footer {
   display: block;
   position: running(footer);
   line-height: 10pt;
   font-size: 7.5pt;
   color: #A9A9A9;
   z-index:2;                
}
   
</style>
</head>

<body>


<img src="{!URLFOR($Resource.Template)}" style="position: fixed; left: 0cm; top: 0cm;  z-index:-2;" width="21cm" height="29.7"/>

 <apex:dataTable cellpadding="2" width="15.92cm" border="0.2" style=" text-align:center; position: fixed; left: 2.54cm; top: 8cm; line-height: 12pt; font-size:11pt; z-index:+2;" columns="5" value="{!relatedTo.Enrollments__r}" var="cx" >

               <apex:column width="3cm"  >  
                   <apex:facet name="header">Number</apex:facet>
                       {!cx.name}       
               </apex:column>
               <apex:column >
                      <apex:facet name="header">姓名</apex:facet>
                             {!cx.delegate_name__r.LastNameLocal}{!cx.delegate_name__r.FirstNameLocal}
               </apex:column>
               <apex:column >
                      <apex:facet name="header">單位</apex:facet>
                          {!cx.delegate_name__r.department}     
               </apex:column>
               <apex:column >
                     <apex:facet name="header">英文姓名</apex:facet>
                         {!cx.delegate_name__r.LastName}{!cx.delegate_name__r.FirstName}
               </apex:column>
               <apex:column width="2cm" >
                   <apex:facet name="header">Pass/Fail</apex:facet>
                       {!IF(OR(CONTAINS(cx.Exam_results__c,'Fail'),CONTAINS(cx.Exam_results__c,'fail')),'F','P')}
               </apex:column>
               
        </apex:dataTable>



<table width="15.92cm" valign="top" style="position: fixed; left: 2.54cm; top: 27.1cm; line-height: 10pt; font-size:7.5pt; color: #A9A9A9;" >
  <colgroup>
    <col span="4" width="3.98cm" />
  </colgroup>
<tr valign="top">
<td>
address
</td>
<td>address</td>
<td></td>
<td></td>
</tr>
</table>
</body></html>
</messaging:attachment>

 

Many Thanks for any help you can offer.