• BenBurbridge(JP)
  • NEWBIE
  • 50 Points
  • Member since 2014

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 8
    Questions
  • 10
    Replies
Hi All,

I have an issue whereby information we collect via our online portal (using a visualforce page) is entered into a custom object.

At present I have a visualforce page rendering as a PDF document, nothing fancy but I have now been advised that this information needs to populate a formal form.  This is a legal document.

The completed form needs to be available immediatelty after completion for download and customer signature but the mail merge option is a manual process which would be too slow for this.

Is there a way to populate a word / editable PDF document with specific fields from the custom document without using mail merge?

Any help is appreciated.
I have a tmeplate which until I refined the styles worked perfectly, below is the code for the attachment portion of the template.
 
<messaging:attachment renderAs="pdf" filename="Patient Treatment Request">

<style type="text/css">

caption {
    border-width: 1px;
    padding: 1px;
    border-style: solid;
    border-color: black;
        text-align: center;
        font-family: Arial;
        background: #940000;
        font-weight: bold;
        font-size: 13px;
        color: #FFFFFF
}

Table {
    border-width: thin;
    border-spacing: 1px;
    border-style: solid;
    border-color: gray;
    background-color: white;
}

Table td:first-child {
        font-weight: bold;
        font-size: 10px;
        text-align: right;
        padding:2px;
}

Table th {
    border-width: 0px;
    padding: 1px;
    border-style: solid;
    border-color: black;
    background-color: #BFBFBF;
    text-align: left;
        font-size:12px;
        font-family: Arial;
        text-align: center;
        font-weight: bold;

}

Table td {
    border-width: 1px;
    padding: 1px;
    border-style: solid;
    border-color: black;
    background-color: white;
    text-align: left;
        font-size:10px;
        font-family: Arial;
        font-weight: normal;
}

.space {
       border-width: 0px;
       }

</style>
<html>
<body>

<div class="Table">
     <table width="100%">
       <caption>Patient Treatment Request Information. Patient:{!relatedTo.Patient_First_Name__c},&nbsp;{!relatedTo.Patient_Last_Name__c}. Coverage Used:{!relatedTo.Division__c}</caption>
                        <tr>
                            <th colspan="2">Patient Demographics</th>
                        </tr>
                        <tr><td height="2px" colspan="2" class="space"></td></tr>
                        <tr>
                            <td width="30%">Patient Name:</td>
                            <td width="70%">{!relatedTo.Patient_First_Name__c},&nbsp;{!relatedTo.Patient_Last_Name__c}</td>
                        </tr>
                        <tr>
                            <td>Date of Birth:</td>
                            <td><apex:outputText value="{0,date,dd-MMMM-yyyy}"><apex:param value="{!relatedTo.Date_of_Birth__c}" /></apex:outputText></td>
                        </tr>
                        <tr>
                            <td>Date of Injury:</td>
                            <td ><apex:outputText value="{0,date,dd-MMMM-yyyy}"><apex:param value="{!relatedTo.Date_of_Accident__c}" /></apex:outputText></td>
                        </tr>
                        <tr>
                            <td>Address:</td>
                            <td>{!relatedTo.Patient_Address_Line_1__c}</td>
                        </tr>
                        <tr>
                            <td>City:</td>
                            <td>{!relatedTo.Patient_City__c}</td>
                        </tr>
                        <tr>
                            <td>Province:</td>
                            <td>{!relatedTo.Patient_Province_State__c}</td>
                        </tr>
                        <tr>
                            <td>Postal Code:</td>
                            <td>{!relatedTo.Patient_Postal_ZIP_Code__c}</td>
                        </tr>
                        <tr>
                            <td>Email Address:</td>
                            <td>{!relatedTo.Patient_Email__c}</td>
                        </tr>
                        <tr>
                            <td>Patient Telephone Numbers:</td>
                            <td>{!relatedTo.Patient_Contact_Details__c}</td>
                        </tr>
                        <tr><td height="5px" colspan="2" class="space"></td></tr>

                        <tr>
                            <th colspan="2">Patient Alternative Contact Details / Emergency Contact</th>
                        </tr>
                        <tr><td height="2px" colspan="2" class="space"></td></tr>
                        <tr>
                            <td style="font-weight: bold">Patient Alternative Contact Details / Emergency Contact Details</td>
                            <td colspan="2"><apex:outputText value="{!relatedTo.Emergency_Contact_Information__c}" escape="false"/></td>
                        </tr>
                        <tr><td height="5px" colspan="2" class="space"></td></tr>

                        <tr>
                            <th colspan="2">Patient Insurance Details</th>
                        </tr>
                        <tr><td height="2px" colspan="2" class="space"></td></tr>
                        <tr>
                            <td style="font-weight: bold">Patient Insurance Details</td>
                            <td colspan="2"><apex:outputText value="{!relatedTo.Patient_Insurance_Information__c}" escape="false"/></td>
                        </tr>
                        <tr><td height="5px" colspan="2" class="space"></td></tr>

                        <tr>
                            <th colspan="2">Patient Employment Details (If Available)</th>
                        </tr>
                        <tr><td height="2px" colspan="2" class="space"></td></tr>
                        <tr>
                            <td style="font-weight: bold">Patient Employment Details (If available)</td>
                            <td colspan="2"><apex:outputText value="{!relatedTo.Patient_Employment_Details__c}" escape="false"/></td>
                        </tr>
                        <tr><td height="5px" colspan="2" class="space"></td></tr>

                        <tr>
                            <th colspan="2">Patient Injury Related Information</th>
                        </tr>
                        <tr><td height="2px" colspan="2" class="space"></td></tr>
                        <tr>
                            <td width="15%">Area of Main Injury:</td>
                            <td width="45%">{!relatedTo.Area_Of_Pain_Area_1__c}</td>
                        </tr>
                        <tr>
                            <td>Current NPRS:</td>
                            <td>{!relatedTo.NPRS_Current_Area_1__c}</td>
                        </tr>
                        <tr>
                            <td>Chief Concern:</td>
                            <td>{!relatedTo.Chief_Concern__c}</td>
                        </tr>
                        <tr><td height="5px" colspan="2" class="space"></td></tr>
                        <tr>
                            <td>Undertaken Diagnostics:</td>
                            <td>{!relatedTo.Diagnostics__c}</td>
                        </tr>
                        <tr>
                            <td>Other Diagnostics Description:</td>
                            <td>{!relatedTo.Diagnostic_Other__c}</td>
                        </tr>
                        <tr>
                            <td>Any Allergies:</td>
                            <td>{!relatedTo.Listed_Allergies__c}</td>
                        </tr>
                        <tr>
                            <td>Current Medications:</td>
                            <td>{!relatedTo.Medications__c}</td>
                        </tr>
                        <tr>
                            <td>Any Pertinent Medical Conditions:</td>
                            <td>{!relatedTo.Medical_Questionnaire__c}</td>
                        </tr>
                        <tr><td height="5px" colspan="2" class="space"></td></tr>

                        <tr>
                            <td colspan="2" style="font-size:6pt;text-align:center;">CONFIDENTIALITY NOTE:  This communication (and any information or material transmitted with this communication) is confidential, may be privileged and is intended only for the use of the intended recipient.  If you are not the intended recipient, any review, retransmission, conversion to hard copy, copying, circulation, publication, dissemination, distribution, reproduction or other use of this communication, information or material is strictly prohibited and may be illegal.  If you received this communication in error, please notify the sender immediately by return mail and delete this communication, information and material from any computer, disk drive, diskette or other storage device or media.  Thank you.</td>
                        </tr>
                        <tr>
                            <td colspan="2" style="font-size:6pt;text-align:center;">AVIS DE CONFIDENTIALITE-: Ce courrier électronique (ainsi que toute information ou matériel transmis par cette communication) est confidentielle, peut être privilégiée, et est destinée que pour l’usage du destinataire adressé. Si vous n’êtes pas le destinataire adressé, toute lecture, retransmission, conversion, copie, circulation, publication, diffusion, distribution, reproduction, ou autre usage de cette communication, information ou matériel est strictement interdit, voire même illégal. Si vous avez reçu cette communication en erreur, s’il-vous-plaît immédiatement avertir l’expéditeur et supprimer cette communication, information et materiel de tout ordinateur, disque dur, disquette ou autre périphérique.  Merci de votre coopération.</td>
                        </tr>
     </table>
</div>
</body>
</html>
</messaging:attachment>
</messaging:emailTemplate>

The font formatting etc works but the borders are not rendering at all?

Help required .. thanks
Hi,

I have a controller which I have used from a glorious Bob Buzzard blog:
 
public class CSTHomeController 
{
 public String nameQuery {get; set;}
 public List<Complaints__c> com {get; set;}
  
 public PageReference executeSearch()
 {
  String queryStr='%' + nameQuery + '%';
  com=[select id, 
              Name, 
              Patient_Name_Reference__c,
              Date_and_time_complaint_lodged__c,
              Complainant_Type__c 
            from Complaints__c 
            where Patient_Name_Reference__c like :queryStr];
            
  return null;
 }
  
 public CSTHomeController ()
 {
  // if query appears in URL, execute it
  String urlQuery=ApexPages.currentPage().getParameters().get('query');
   
  if ( (null!=urlQuery) && (0!=urlQuery.length()) )
  {
   nameQuery=urlQuery;
   executeSearch();
  }
 }
}

This works perfectly, but I want to use several of these searches together on one page.  The above is for a complaints object, but we have a customer feedback object and an audits object which I want to use this for.  I am building a visualforce page which will become a Customer Service Team landing page and they can search across these different objects but ....

How do I add more searches onto the same controller?

Visualforce Page with duplicated search in very early stages of development:
 
<apex:page controller="CSTHomeController">
   <style type="text/css">
   
h1 { 
    display: block;
    font-size: 18pt;
    font-family: arial;
    font-weight: bold;
    text-align: center;
}

</style>
<h1> Customer Service Team </h1>
    <apex:form >
        <apex:pageBlock >
            <table>
                <tr>
                    <td><apex:outputlink value="https://cs21.salesforce.com/a0C/o">Complaints Home</apex:outputlink></td>
                </tr>
                <tr>
                    <td style="height:10px;"></td>
                </tr>
                <tr>
                    <td><apex:outputLabel value="Search for a Complaint"/></td>
                </tr>
                <tr>
                    <td><apex:inputText value="{!nameQuery}"/></td>
                </tr>
                <tr>
                    <td style="height:10px;"></td>
                </tr>
                <tr>
                    <td><apex:commandButton action="{!executeSearch}" value="Search"/></td>
                </tr>
            </table>  
            <apex:pageBlockTable value="{!com}" var="comp">
                <apex:column headerValue="Complaint Results">
                    <apex:outputLink value="/{!comp.id}/e?retURL={!URLENCODE('/apex/RetUrlSearchPage?query='+nameQuery)}">{!comp.Name}</apex:outputLink>
                </apex:column>
                <apex:column value="{!comp.Patient_Name_Reference__c}"/>
                <apex:column value="{!comp.Date_and_time_complaint_lodged__c}"/>
                <apex:column value="{!comp.Complainant_Type__c }"/>
            </apex:pageBlockTable>
        </apex:pageBlock>
    </apex:form>
    <apex:form >
    <apex:pageBlock >
            <table>
                <tr>
                    <td><apex:outputlink value="https://cs21.salesforce.com/a0C/o">Complaints Home</apex:outputlink></td>
                </tr>
                <tr>
                    <td style="height:10px;"></td>
                </tr>
                <tr>
                    <td><apex:outputLabel value="Search for a Complaint"/></td>
                </tr>
                <tr>
                    <td><apex:inputText value="{!nameQuery}"/></td>
                </tr>
                <tr>
                    <td style="height:10px;"></td>
                </tr>
                <tr>
                    <td><apex:commandButton action="{!executeSearch}" value="Search"/></td>
                </tr>
            </table>  
            <apex:pageBlockTable value="{!com}" var="comp">
                <apex:column headerValue="Complaint Results">
                    <apex:outputLink value="/{!comp.id}/e?retURL={!URLENCODE('/apex/RetUrlSearchPage?query='+nameQuery)}">{!comp.Name}</apex:outputLink>
                </apex:column>
                <apex:column value="{!comp.Patient_Name_Reference__c}"/>
                <apex:column value="{!comp.Date_and_time_complaint_lodged__c}"/>
                <apex:column value="{!comp.Complainant_Type__c }"/>
            </apex:pageBlockTable>
        </apex:pageBlock>
        </apex:form>
</apex:page>



Thanks
I have created a visualforce page for my finance team to work specifically with some integrated fields, I have pasted my code below (please excuse the way it is laid out as I am new and learning)
 
<apex:page standardController="Treatment_Plan__c" extensions="BillingTreatmentPlanController" title="Billing Department - Treatment Plan" standardStylesheets="false" tabstyle="Treatment_Plan__c">

<script type="text/javascript">
    window.onload=function(){
    var tfrow = document.getElementById('tfhover').rows.length;
    var tbRow=[];
    for (var i=1;i<tfrow;i++) {
        tbRow[i]=document.getElementById('tfhover').rows[i];
        tbRow[i].onmouseover = function(){
          this.style.backgroundColor = '#f3f8aa';
        };
        tbRow[i].onmouseout = function() {
          this.style.backgroundColor = '#ffffff';
        };
    }
};
</script>

<style type="text/css">

h1 { 
    display: block;
    font-size: 18pt;
    font-family: sans-serif,arial;
    font-weight: bold;
    text-align:center;
}

table.tftable {
                font-size:12px;
                color:#333333;
                width:100%;
                border-width: 1px;
                border-color: #729ea5;
                border-collapse: collapse;
}

table.tftable th {
                    font-size:12px;background-color:#acc8cc;
                    border-width:1px;
                    padding:8px;
                    border-style:solid;
                    border-color:#729ea5;
                    text-align:left;
}

table.tftable tr {
                    background-color:#ffffff;
}

table.tftable td {
                    font-size:12px;
                    border-width: 1px;
                    padding: 8px;
                    border-style: solid;
                    border-color: #729ea5;
}

table.tftable1 {
                font-size:12px;
                color:#333333;
                width:10%;
                border-width: 1px;
                border-color: #729ea5;
                border-collapse: collapse;
}

table.tftable1 th {
                    font-size:12px;background-color:#acc8cc;
                    border-width:1px;
                    padding:8px;
                    border-style:solid;
                    border-color:#729ea5;
                    text-align:center;
}

table.tftable1 tr {
                    background-color:#ffffff;
}

table.tftable1 td {
                    font-size:12px;
                    border-width: 1px;
                    padding: 8px;
                    border-style: solid;
                    border-color: #729ea5;
                    text-align:center;
}

table.tftable2 {
                font-size:12px;
                color:#333333;
                width:20%;
                border-width: 1px;
                border-color: #729ea5;
                border-collapse: collapse;
}

table.tftable2 th {
                    font-size:12px;background-color:#acc8cc;
                    border-width:1px;
                    padding:8px;
                    border-style:solid;
                    border-color:#729ea5;
                    text-align:left;
}

table.tftable2 tr {
                    background-color:#ffffff;
}

table.tftable2 td {
                    font-size:12px;
                    border-width: 1px;
                    padding: 8px;
                    border-style: solid;
                    border-color: #729ea5;
}

</style>

<h1>Billing Department - Send OCF</h1>
    <apex:form >
        <apex:pageBlock title="Patient Details" mode="detail">
            <apex:pageBlockSection columns="1">
                <apex:inputField value="{!Treatment_Plan__c.Name}" label="Related Treatment Plan"/>
                <apex:outputText value="{!Treatment_Plan__c.Patient_First_Name__c + ' ' + Treatment_Plan__c.Patient_Last_Name__c}" label="Patients Name"/>
                <apex:outputField value="{!Treatment_Plan__c.Clinic_Check__c}" label="Clinic Used"/>
            </apex:pageBlockSection>
        </apex:pageBlock>
        <apex:pageBlock title="Service Code Lookup" mode="edit">
            <apex:pageBlockSection columns="1">
                <apex:outputText value="Copy the service code from the appropriate line below and check the corresponding check box to update that line"></apex:outputText>
                <br></br>
                <apex:inputfield value="{!Treatment_Plan__c.Service_Code1_lookup__c}" label=""/>
                <br></br>
            </apex:pageBlockSection>
        </apex:pageBlock>
        <apex:pageBlock title="Service Invoice Lines" mode="edit">
            <table id="tfhover" class="tftable" border="1">
                  <br></br>
                    <tr>    
                        <th>Line Number</th>
                        <th>Service Code</th>
                        <th>Quantity</th>
                        <th>Proposed Count</th>
                        <th>Proposed Cost</th>
                        <th>Service HST</th>
                        <th>Confirm Line</th>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Service_Code_1__c), 'none', 'table-row')};">
                        <td>1</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Service_Code_1__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Quantity1__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Count_1__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Cost_1__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Service_HST1__c}" label=""/></td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Update_OCF18_Cost1__c}" label=""/></td>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Service_Code_2__c), 'none', 'table-row')};">
                        <td>2</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Service_Code_2__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Quantity2__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Count_2__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Cost_2__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Service_HST2__c}" label=""/></td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Update_OCF18_Cost2__c}" label=""/></td>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Service_Code_3__c), 'none', 'table-row')};">
                        <td>3</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Service_Code_3__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Quantity3__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Count_3__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Cost_3__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Service_HST3__c}" label=""/></td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Update_OCF18_Cost3__c}" label=""/></td>  
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Service_Code_4__c), 'none', 'table-row')};">
                        <td>4</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Service_Code_4__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Quantity4__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Count_4__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Cost_4__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Service_HST4__c}" label=""/></td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Update_OCF18_Cost4__c}" label=""/></td>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Service_Code_5__c), 'none', 'table-row')};">
                        <td>5</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Service_Code_5__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Quantity5__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Count_5__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Cost_5__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Service_HST5__c}" label=""/></td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Update_OCF18_Cost5__c}" label=""/></td>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Service_Code_6__c), 'none', 'table-row')};">
                        <td>6</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Service_Code_6__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Quantity6__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Count_6__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Cost_6__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Service_HST6__c}" label=""/></td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Update_OCF18_Cost6__c}" label=""/></td>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Service_Code_7__c), 'none', 'table-row')};">
                        <td>7</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Service_Code_7__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Quantity7__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Count_7__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Cost_7__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Service_HST7__c}" label=""/></td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Update_OCF18_Cost7__c}" label=""/></td>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Service_Code_8__c), 'none', 'table-row')};">
                        <td>8</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Service_Code_8__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Quantity8__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Count_8__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Cost_8__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Service_HST8__c}" label=""/></td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Update_OCF18_Cost8__c}" label=""/></td>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Service_Code_9__c), 'none', 'table-row')};">
                        <td>9</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Service_Code_9__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Quantity9__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Count_9__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Cost_9__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Service_HST9__c}" label=""/></td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Update_OCF18_Cost9__c}" label=""/></td>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Service_Code_10__c), 'none', 'table-row')};">
                        <td>10</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Service_Code_10__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Quantity10__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Count_10__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Proposed_Cost_10__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Service_HST10__c}" label=""/></td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Update_OCF18_Cost10__c}" label=""/></td>
                    </tr>
             </table>
            <apex:pageBlockButtons location="bottom">
               <apex:commandButton id="quicksave" value="Update" action="{!quicksave}"/>
           </apex:pageBlockButtons>
           </apex:pageblock>
           <apex:pageBlock title="Product Invoice Lines" mode="edit">         
            <table id="tfhover" class="tftable" border="1">
                  <br></br>
                    <tr>
                        <th>Line Number</th>
                        <th>Product Code</th>
                        <th>Quantity</th>
                        <th>Provider Occupation</th>
                        <th>Total Count</th>
                        <th>Cost</th>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Product_Code1__c), 'none', 'table-row')};">
                        <td>1</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Product_Code1__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Quantity1__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Provider_Occupation1__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Count1__c}" label=""/></td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Product_Cost1__c}" label=""/></td>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Product_Code2__c), 'none', 'table-row')};">
                        <td>2</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Product_Code2__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Quantity2__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Provider_Occupation2__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Count2__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Cost2__c}" label=""/></td>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Product_Code3__c), 'none', 'table-row')};">
                        <td>3</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Product_Code3__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Quantity3__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Provider_Occupation3__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Count3__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Cost3__c}" label=""/></td>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Product_Code4__c), 'none', 'table-row')};">
                        <td>4</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Product_Code4__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Quantity4__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Provider_Occupation4__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Count4__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Cost4__c}" label=""/></td>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Product_Code5__c), 'none', 'table-row')};">
                        <td>5</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Product_Code5__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Quantity5__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Provider_Occupation5__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Count5__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Cost5__c}" label=""/></td>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Product_Code6__c), 'none', 'table-row')};">
                        <td>6</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Product_Code6__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Quantity6__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Provider_Occupation6__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Count6__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Cost6__c}" label=""/></td>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Product_Code7__c), 'none', 'table-row')};">
                        <td>7</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Product_Code7__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Quantity7__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Provider_Occupation7__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Count7__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Cost7__c}" label=""/></td>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Product_Code8__c), 'none', 'table-row')};">
                        <td>8</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Product_Code8__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Quantity8__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Provider_Occupation8__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Count8__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Cost8__c}" label=""/></td>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Product_Code9__c), 'none', 'table-row')};">
                        <td>9</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Product_Code9__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Quantity9__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Provider_Occupation9__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Count9__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Cost9__c}" label=""/></td>
                    </tr>
                    <tr style="display: {!IF(ISBLANK(Treatment_Plan__c.Product_Code10__c), 'none', 'table-row')};">
                        <td>10</td>
                        <td><apex:inputfield value="{!Treatment_Plan__c.Product_Code10__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Quantity10__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Provider_Occupation10__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Count10__c}" label=""/></td>
                        <td><apex:outputfield value="{!Treatment_Plan__c.Product_Cost10__c}" label=""/></td>
                    </tr>
            </table>
        </apex:pageBlock>
        <apex:pageBlock title="Sub Totals" mode="edit">       
                <table id="tfhover" class="tftable1" border="1">
                      <tr>
                            <th>Subtotal</th>
                      </tr>
                      <tr>
                            <td><apex:outputfield value="{!Treatment_Plan__c.Sub_Total_OCF18__c}" label=""/></td>
                      </tr>
                      <tr>
                            <th>HST</th>
                      </tr>
                      <tr>
                            <td><apex:outputfield value="{!Treatment_Plan__c.Total_HST_OCF18__c}" label=""/></td>
                      </tr>
                      <tr>
                            <th>Total</th>
                      </tr>
                      <tr>
                            <td><apex:outputfield value="{!Treatment_Plan__c.Total_Cost_OCF18__c}" label=""/></td>
                      </tr>
                </table>
        </apex:pageBlock>
        <apex:pageBlock title="Send OCF" mode="edit">       
                <table id="tfhover" class="tftable2" border="1">
                     <tr>
                     <th>Send OCF</th>
                     </tr>
                      <tr>
            <td><apex:inputfield value="{!Treatment_Plan__c.Send_OCF18__c}" label=""/></td>
            </tr>
            <tr>
            <th>Reduce Treatment Plan by 15%</th>
            </tr>
            <tr>
            <td><apex:inputfield value="{!Treatment_Plan__c.Reduce_Treatment_Plan_by_15__c}" label=""/></td>
            </tr>
            <br></br>
            </table>
        </apex:pageBlock>
        <apex:pageBlock >  
            <apex:pageBlockButtons location="bottom">
               <apex:commandButton id="save" value="Save" action="{!save}"/>
            </apex:pageBlockButtons>
        </apex:pageBlock>
    </apex:form>
</apex:page>

I need to overright the custom save button to simply save the data and rerender the page and another button to save and close the page.

My only experience is with standard buttons and I dont want to enclose everything in pageblocks, does anyone know of a way I can achieve this in my controller (copy below)
 
public with sharing class BillingTreatmentPlanController {
  
    public Treatment_Plan__c billingview {get; set;}

    public BillingTreatmentPlanController(ApexPages.StandardController
                                stdController) {
       
       billingview = (Treatment_Plan__c)stdController.getRecord();
       
       if (ApexPages.currentPage().getParameters().get('treatmentPlanId') != null) {
           billingview.ID = ApexPages.currentPage().getParameters().get('treatmentPlanId');
       }
    }   
}


 
I am designing a patient intake visual workflow.

My operations deartment want some scripting to show dynamically based on drop down choice, I can use an IF statement but in flow they need to be numerical values which is annoying.

Example:

If( ISPICKVAL( {!Caller_Response} , {!I_am_calling_to_find_out_the_opening_hours}), "Our usual opening hours are 8am until 6.00pm, but this will depend on your area.  If you can spare 5 minutes to go through our intake, I am sure I can satisfy your requirements", "")
&If( ISPICKVAL( {!Caller_Response} , {!I_am_calling_to_find_out_the_prices_for_treatment}), "Our costings vary dependant on your location and injury type but I can tell you that they are between 30 and 60 dollars", "")
&If( ISPICKVAL( {!Caller_Response} , "{!Please_Choose}), "Please choose an option", "")

Can anyone help?
HI,

I have created an in depth flow which is working well, I want to be able to split screen this flow which I can do but I am unsure how to show the flow on oneside and then the created custom object on the otherside?

I think I need to pull a variable out of the flow but I am unsure on this.

Custom Object - Treatment_Plan__c
Variable - VarTreatmentID
Visualforce Flow and VIsualforce Pages.

I have a visualforce flow setup and working well, it has been embedded into a visualforce page.

However, I have created a class / VF combination to show localised accounts into a table which is currently shown on a custom object.

I need to get this smaller VF page/table into the flow, anyone have any ideas or experience?

Bem
Hi,

I appreciate lots of similar questions have been asked but I can not workout where the issue is in this code, I have picked this up from a previous employee and am learning.  I have noted the error below as well as bold and underline the line.

I am trying to have a new Accounts Receiveable object create when Work Injury is chosen in a picklist on the Treatment Plan.

Error: Compile Error: Try block must have at least one catch or finally at line 2 column 1

trigger OnceARc on Treatment_Plan__c (after update, after insert) {
try{
if(Test.isRunningTest()||!OnceARc.hasAlreadyRound()){

    list<Accounts_Receivable__c> lst = new list<Accounts_Receivable__c>();
  for(Treatment_Plan__c p:trigger.new){
    boolean nst = false;
    if(trigger.isInsert){
      if(p.Division__c=='Work Injury'){
        nst=true;
      }
    }else if(trigger.isUpdate){
      string ott=trigger.oldmap.get(p.id).Division__c;
      string ntt = p.Division__c;
      if(ott!=ntt&&ntt=='Work Injury'){
        nst=true;
      }
      system.debug('!!!!!!!!!!!!ott'+ott);
      system.debug('!!!!!!!!!!!!ntt'+ntt);
      system.debug('!!!!!!!!!!!!nst'+nst);
    
    }

  if(lst.size()>0){insert lst;lst.clear();}    
    if(nst){
      OnceARc.setAlreadyRound();
      Accounts_Receivable__c st = new Accounts_Receivable__c(
      Treatment_Plan_Object__c =p.Id
      );
      lst.add(st);
      if(lst.size()>95){insert lst;lst.clear();}    
    }
  }
  if(lst.size()>0){insert lst;lst.clear();}    
}

}catch(Exception exall){}
}
I have a tmeplate which until I refined the styles worked perfectly, below is the code for the attachment portion of the template.
 
<messaging:attachment renderAs="pdf" filename="Patient Treatment Request">

<style type="text/css">

caption {
    border-width: 1px;
    padding: 1px;
    border-style: solid;
    border-color: black;
        text-align: center;
        font-family: Arial;
        background: #940000;
        font-weight: bold;
        font-size: 13px;
        color: #FFFFFF
}

Table {
    border-width: thin;
    border-spacing: 1px;
    border-style: solid;
    border-color: gray;
    background-color: white;
}

Table td:first-child {
        font-weight: bold;
        font-size: 10px;
        text-align: right;
        padding:2px;
}

Table th {
    border-width: 0px;
    padding: 1px;
    border-style: solid;
    border-color: black;
    background-color: #BFBFBF;
    text-align: left;
        font-size:12px;
        font-family: Arial;
        text-align: center;
        font-weight: bold;

}

Table td {
    border-width: 1px;
    padding: 1px;
    border-style: solid;
    border-color: black;
    background-color: white;
    text-align: left;
        font-size:10px;
        font-family: Arial;
        font-weight: normal;
}

.space {
       border-width: 0px;
       }

</style>
<html>
<body>

<div class="Table">
     <table width="100%">
       <caption>Patient Treatment Request Information. Patient:{!relatedTo.Patient_First_Name__c},&nbsp;{!relatedTo.Patient_Last_Name__c}. Coverage Used:{!relatedTo.Division__c}</caption>
                        <tr>
                            <th colspan="2">Patient Demographics</th>
                        </tr>
                        <tr><td height="2px" colspan="2" class="space"></td></tr>
                        <tr>
                            <td width="30%">Patient Name:</td>
                            <td width="70%">{!relatedTo.Patient_First_Name__c},&nbsp;{!relatedTo.Patient_Last_Name__c}</td>
                        </tr>
                        <tr>
                            <td>Date of Birth:</td>
                            <td><apex:outputText value="{0,date,dd-MMMM-yyyy}"><apex:param value="{!relatedTo.Date_of_Birth__c}" /></apex:outputText></td>
                        </tr>
                        <tr>
                            <td>Date of Injury:</td>
                            <td ><apex:outputText value="{0,date,dd-MMMM-yyyy}"><apex:param value="{!relatedTo.Date_of_Accident__c}" /></apex:outputText></td>
                        </tr>
                        <tr>
                            <td>Address:</td>
                            <td>{!relatedTo.Patient_Address_Line_1__c}</td>
                        </tr>
                        <tr>
                            <td>City:</td>
                            <td>{!relatedTo.Patient_City__c}</td>
                        </tr>
                        <tr>
                            <td>Province:</td>
                            <td>{!relatedTo.Patient_Province_State__c}</td>
                        </tr>
                        <tr>
                            <td>Postal Code:</td>
                            <td>{!relatedTo.Patient_Postal_ZIP_Code__c}</td>
                        </tr>
                        <tr>
                            <td>Email Address:</td>
                            <td>{!relatedTo.Patient_Email__c}</td>
                        </tr>
                        <tr>
                            <td>Patient Telephone Numbers:</td>
                            <td>{!relatedTo.Patient_Contact_Details__c}</td>
                        </tr>
                        <tr><td height="5px" colspan="2" class="space"></td></tr>

                        <tr>
                            <th colspan="2">Patient Alternative Contact Details / Emergency Contact</th>
                        </tr>
                        <tr><td height="2px" colspan="2" class="space"></td></tr>
                        <tr>
                            <td style="font-weight: bold">Patient Alternative Contact Details / Emergency Contact Details</td>
                            <td colspan="2"><apex:outputText value="{!relatedTo.Emergency_Contact_Information__c}" escape="false"/></td>
                        </tr>
                        <tr><td height="5px" colspan="2" class="space"></td></tr>

                        <tr>
                            <th colspan="2">Patient Insurance Details</th>
                        </tr>
                        <tr><td height="2px" colspan="2" class="space"></td></tr>
                        <tr>
                            <td style="font-weight: bold">Patient Insurance Details</td>
                            <td colspan="2"><apex:outputText value="{!relatedTo.Patient_Insurance_Information__c}" escape="false"/></td>
                        </tr>
                        <tr><td height="5px" colspan="2" class="space"></td></tr>

                        <tr>
                            <th colspan="2">Patient Employment Details (If Available)</th>
                        </tr>
                        <tr><td height="2px" colspan="2" class="space"></td></tr>
                        <tr>
                            <td style="font-weight: bold">Patient Employment Details (If available)</td>
                            <td colspan="2"><apex:outputText value="{!relatedTo.Patient_Employment_Details__c}" escape="false"/></td>
                        </tr>
                        <tr><td height="5px" colspan="2" class="space"></td></tr>

                        <tr>
                            <th colspan="2">Patient Injury Related Information</th>
                        </tr>
                        <tr><td height="2px" colspan="2" class="space"></td></tr>
                        <tr>
                            <td width="15%">Area of Main Injury:</td>
                            <td width="45%">{!relatedTo.Area_Of_Pain_Area_1__c}</td>
                        </tr>
                        <tr>
                            <td>Current NPRS:</td>
                            <td>{!relatedTo.NPRS_Current_Area_1__c}</td>
                        </tr>
                        <tr>
                            <td>Chief Concern:</td>
                            <td>{!relatedTo.Chief_Concern__c}</td>
                        </tr>
                        <tr><td height="5px" colspan="2" class="space"></td></tr>
                        <tr>
                            <td>Undertaken Diagnostics:</td>
                            <td>{!relatedTo.Diagnostics__c}</td>
                        </tr>
                        <tr>
                            <td>Other Diagnostics Description:</td>
                            <td>{!relatedTo.Diagnostic_Other__c}</td>
                        </tr>
                        <tr>
                            <td>Any Allergies:</td>
                            <td>{!relatedTo.Listed_Allergies__c}</td>
                        </tr>
                        <tr>
                            <td>Current Medications:</td>
                            <td>{!relatedTo.Medications__c}</td>
                        </tr>
                        <tr>
                            <td>Any Pertinent Medical Conditions:</td>
                            <td>{!relatedTo.Medical_Questionnaire__c}</td>
                        </tr>
                        <tr><td height="5px" colspan="2" class="space"></td></tr>

                        <tr>
                            <td colspan="2" style="font-size:6pt;text-align:center;">CONFIDENTIALITY NOTE:  This communication (and any information or material transmitted with this communication) is confidential, may be privileged and is intended only for the use of the intended recipient.  If you are not the intended recipient, any review, retransmission, conversion to hard copy, copying, circulation, publication, dissemination, distribution, reproduction or other use of this communication, information or material is strictly prohibited and may be illegal.  If you received this communication in error, please notify the sender immediately by return mail and delete this communication, information and material from any computer, disk drive, diskette or other storage device or media.  Thank you.</td>
                        </tr>
                        <tr>
                            <td colspan="2" style="font-size:6pt;text-align:center;">AVIS DE CONFIDENTIALITE-: Ce courrier électronique (ainsi que toute information ou matériel transmis par cette communication) est confidentielle, peut être privilégiée, et est destinée que pour l’usage du destinataire adressé. Si vous n’êtes pas le destinataire adressé, toute lecture, retransmission, conversion, copie, circulation, publication, diffusion, distribution, reproduction, ou autre usage de cette communication, information ou matériel est strictement interdit, voire même illégal. Si vous avez reçu cette communication en erreur, s’il-vous-plaît immédiatement avertir l’expéditeur et supprimer cette communication, information et materiel de tout ordinateur, disque dur, disquette ou autre périphérique.  Merci de votre coopération.</td>
                        </tr>
     </table>
</div>
</body>
</html>
</messaging:attachment>
</messaging:emailTemplate>

The font formatting etc works but the borders are not rendering at all?

Help required .. thanks
Hi,

I have a controller which I have used from a glorious Bob Buzzard blog:
 
public class CSTHomeController 
{
 public String nameQuery {get; set;}
 public List<Complaints__c> com {get; set;}
  
 public PageReference executeSearch()
 {
  String queryStr='%' + nameQuery + '%';
  com=[select id, 
              Name, 
              Patient_Name_Reference__c,
              Date_and_time_complaint_lodged__c,
              Complainant_Type__c 
            from Complaints__c 
            where Patient_Name_Reference__c like :queryStr];
            
  return null;
 }
  
 public CSTHomeController ()
 {
  // if query appears in URL, execute it
  String urlQuery=ApexPages.currentPage().getParameters().get('query');
   
  if ( (null!=urlQuery) && (0!=urlQuery.length()) )
  {
   nameQuery=urlQuery;
   executeSearch();
  }
 }
}

This works perfectly, but I want to use several of these searches together on one page.  The above is for a complaints object, but we have a customer feedback object and an audits object which I want to use this for.  I am building a visualforce page which will become a Customer Service Team landing page and they can search across these different objects but ....

How do I add more searches onto the same controller?

Visualforce Page with duplicated search in very early stages of development:
 
<apex:page controller="CSTHomeController">
   <style type="text/css">
   
h1 { 
    display: block;
    font-size: 18pt;
    font-family: arial;
    font-weight: bold;
    text-align: center;
}

</style>
<h1> Customer Service Team </h1>
    <apex:form >
        <apex:pageBlock >
            <table>
                <tr>
                    <td><apex:outputlink value="https://cs21.salesforce.com/a0C/o">Complaints Home</apex:outputlink></td>
                </tr>
                <tr>
                    <td style="height:10px;"></td>
                </tr>
                <tr>
                    <td><apex:outputLabel value="Search for a Complaint"/></td>
                </tr>
                <tr>
                    <td><apex:inputText value="{!nameQuery}"/></td>
                </tr>
                <tr>
                    <td style="height:10px;"></td>
                </tr>
                <tr>
                    <td><apex:commandButton action="{!executeSearch}" value="Search"/></td>
                </tr>
            </table>  
            <apex:pageBlockTable value="{!com}" var="comp">
                <apex:column headerValue="Complaint Results">
                    <apex:outputLink value="/{!comp.id}/e?retURL={!URLENCODE('/apex/RetUrlSearchPage?query='+nameQuery)}">{!comp.Name}</apex:outputLink>
                </apex:column>
                <apex:column value="{!comp.Patient_Name_Reference__c}"/>
                <apex:column value="{!comp.Date_and_time_complaint_lodged__c}"/>
                <apex:column value="{!comp.Complainant_Type__c }"/>
            </apex:pageBlockTable>
        </apex:pageBlock>
    </apex:form>
    <apex:form >
    <apex:pageBlock >
            <table>
                <tr>
                    <td><apex:outputlink value="https://cs21.salesforce.com/a0C/o">Complaints Home</apex:outputlink></td>
                </tr>
                <tr>
                    <td style="height:10px;"></td>
                </tr>
                <tr>
                    <td><apex:outputLabel value="Search for a Complaint"/></td>
                </tr>
                <tr>
                    <td><apex:inputText value="{!nameQuery}"/></td>
                </tr>
                <tr>
                    <td style="height:10px;"></td>
                </tr>
                <tr>
                    <td><apex:commandButton action="{!executeSearch}" value="Search"/></td>
                </tr>
            </table>  
            <apex:pageBlockTable value="{!com}" var="comp">
                <apex:column headerValue="Complaint Results">
                    <apex:outputLink value="/{!comp.id}/e?retURL={!URLENCODE('/apex/RetUrlSearchPage?query='+nameQuery)}">{!comp.Name}</apex:outputLink>
                </apex:column>
                <apex:column value="{!comp.Patient_Name_Reference__c}"/>
                <apex:column value="{!comp.Date_and_time_complaint_lodged__c}"/>
                <apex:column value="{!comp.Complainant_Type__c }"/>
            </apex:pageBlockTable>
        </apex:pageBlock>
        </apex:form>
</apex:page>



Thanks
I am designing a patient intake visual workflow.

My operations deartment want some scripting to show dynamically based on drop down choice, I can use an IF statement but in flow they need to be numerical values which is annoying.

Example:

If( ISPICKVAL( {!Caller_Response} , {!I_am_calling_to_find_out_the_opening_hours}), "Our usual opening hours are 8am until 6.00pm, but this will depend on your area.  If you can spare 5 minutes to go through our intake, I am sure I can satisfy your requirements", "")
&If( ISPICKVAL( {!Caller_Response} , {!I_am_calling_to_find_out_the_prices_for_treatment}), "Our costings vary dependant on your location and injury type but I can tell you that they are between 30 and 60 dollars", "")
&If( ISPICKVAL( {!Caller_Response} , "{!Please_Choose}), "Please choose an option", "")

Can anyone help?
HI,

I have created an in depth flow which is working well, I want to be able to split screen this flow which I can do but I am unsure how to show the flow on oneside and then the created custom object on the otherside?

I think I need to pull a variable out of the flow but I am unsure on this.

Custom Object - Treatment_Plan__c
Variable - VarTreatmentID
Visualforce Flow and VIsualforce Pages.

I have a visualforce flow setup and working well, it has been embedded into a visualforce page.

However, I have created a class / VF combination to show localised accounts into a table which is currently shown on a custom object.

I need to get this smaller VF page/table into the flow, anyone have any ideas or experience?

Bem
HI,

      May i know How can i divide the visualforce page into 2 vertical, 2 horizontal columns..??