Salesforce Developer Community

Bob Poliquin 9
NEWBIE
20 Points
Member since 2020

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
13

Questions
16

Replies

3 replies

Work Bench Error no package.xml found

I am trying to mass delete some old process builder workflows and I keep getting the following error.

User-added image

screenshot of the two files in my test folder
User-added image

<?xml version="1.0" encoding="UTF-8"?>
<Package xmlns="http://soap.sforce.com/2006/04/metadata">
<types>
<members>Service_Provider_Bid_Set_Bid_Notification_Information</members>
<members>Send_Mobile_Pin_SMS</members>
<members>Account_Sync_Service_Provider_Bids_Bid_Notification_Information</members>
<members>Procurement_Bid_Update_Vendor_s_Latest_Contract_End_Date</members>
<members>Work_Order_Set</members>
<name>Flow</name>
</types>Ï
</Package>

<?xml version="1.0" encoding="UTF-8"?>
<Package xmlns="http://soap.sforce.com/2006/04/metadata">    
  <version>50.0</version>
</Package>

Any help would be very greatly appreciated
Here is the link I used to try this way of doin git with no success
https://sfdccloudninja.com/flow/deleting-lots-of-old-flows-process-builders/

Bob Poliquin 9
March 24, 2021
Like
0

2 replies

Converting visualforce page to lightning web component

I do not know how to covert my VF pages to a lightning web component and need some help. Below is the code for my vf page and apex class. If anyone can show me how to covert this to LWC I would appreciated it.

Apex Class:

// Used on the account page updated 1-31-2020
Public Class VF_SiteServicePartnerAllController{
   private Account acc;
   public List<Site_Service_Partner__c> sspList {get;set;}
   
   public VF_SiteServicePartnerAllController(ApexPages.StandardController sp){
       acc = (Account)sp.getRecord();
       sspList = new List<Site_Service_Partner__c>();
       sspList = [SELECT Id,Name,Site_Account__c,Primary_Field_Contact__c,Service_Partner__c,
                  Service_Partner_Owner__c,Service_Partner_Owner_Mobile__c,Service_Partner_Owner_Email__c,
                  Primary_Field_Email__c,Primary_Field_Mobile__c,Service_Partner_Site_Status__c, 
                  Contracted_Services__c,Secondary_Field_Contact__c,Secondary_Field_Email__c,Secondary_Field_Mobile__c,
                  Service_Partner_Start_Date__c,Service_Partner_End_Date__c,Service_Partner_Main_Phone__c,Service_Line__c,Supported_Service_Lines__c FROM Site_Service_Partner__c WHERE Site_Account__c =: acc.Id AND Service_Line__c IN ('Land', 'Snow', 'Land;Snow','Janitorial','Land;Snow;Janitorial') AND Service_Partner_Site_Status__c = 'Active'];

    
    Set<Id> bidId = new  Set<Id>();  
    for(Site_Service_Partner__c bs:sspList){
       bidId.add(bs.Id);
    }
     
   }

}

VF Page:

<apex:page standardController="Account"   extensions="VF_SiteServicePartnerAllController" lightningStylesheets="true"  >


<style>
      
          .ht{ height:0px;
    vertical-align:middle;
          
          }
              
   </style>
 
<apex:form > 
  <apex:pageBlock >
    <apex:pageBlockTable cellpadding="1" width="100%" columns="2" value="{!sspList}" var="item">

           <apex:column rendered="{!IF(item.Service_Partner_Site_Status__c = 'Active',true,false)}"  >
                 <apex:outputPanel rendered="{!CONTAINS(item.Service_Line__c, 'Land')}">
                 <apex:outputPanel rendered="{!IF(item.Service_Partner_Start_Date__c  != null,true,false)}">
                 <apex:outputField value="{!item.Supported_Service_Lines__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Assigned to Site</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Primary Contact</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Primary_Field_Contact__c}"/><br></br>
                <apex:outputLabel value=""><b>Primary Field  Cell</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Primary_Field_Mobile__c}"/><br></br>
                <apex:outputLabel value=""><b>Primary Field Email</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Primary_Field_Email__c}"/><br></br>
                <apex:outputLabel value=""><b>Secondary Contact</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Secondary_Field_Contact__c}"/><br></br>
                <apex:outputLabel value=""><b>Secondary Cell</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Secondary_Field_Mobile__c}"/><br></br>
                <apex:outputLabel ><b>Secondary Email</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Secondary_Field_Email__c}"/><br></br>
                <apex:outputLabel ><b>Latest Work Order</b></apex:outputLabel><br></br>
                <apex:outputField value="{!Account.Latest_Work_Order__c}"/><br></br>
                 <apex:outputLabel ><b>Latest Work Order Submitted</b></apex:outputLabel><br></br>
                <apex:outputField value="{!Account.Latest_Work_Order_Submitted__c}"/>
           </apex:outputPanel>
           </apex:outputPanel>
           </apex:column>
           
           <apex:column styleClass="ht" rendered="{!IF(item.Service_Partner_Site_Status__c = 'Active',true,false && CONTAINS(item.Service_Line__c, 'Land') )}" >
                <apex:outputPanel rendered="{!CONTAINS(item.Service_Line__c, 'Land')}">
                <apex:outputPanel rendered="{!IF(item.Service_Partner_Start_Date__c  != null,true,false)}">
                <apex:outputLabel ><b>Service Partner Owner</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Owner__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Owner Cell</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Owner_Mobile__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Main Phone</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Main_Phone__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Owner Email</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Owner_Email__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Provider Start Date</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Start_Date__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Provider End Date</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_End_Date__c}"/>
                </apex:outputPanel> 
           </apex:outputPanel> 
           </apex:column>

      </apex:pageBlockTable>

    </apex:pageBlock>

  </apex:form>

 </apex:page>

Bob Poliquin 9
March 17, 2021
Like
0

0 replies

Send text message button with flow Messaging Notification core action

I have created a flow that should send a text message using a messaging notification core action when a button is clicked. When i run a debug it works. I see the output in debug and i get a text message.

Inputs
contextRecordId = {!CaseId.Id} (5006s000003vdetAAA)
channelDeveloperName = Text_US_12013504687
templateDeveloperName = Automated_Messaging
recipientPhone = {!CaseId.Service_Provider_Mobile_Phone__c} (+16173453456)
recipientRecordId = {!CaseId.Id} (5006s000003vdetAAA)

When I created the button and tried it from the case page. Nothing happen?

Do i need to add merge fields to this link below?

/flow/Send_SMS_Notification_to_Service_Provider

This is what I have setup in the messaging action

Context Record ID
{!CaseId.Id}

Recipient Phone Number
{!CaseId.Service_Provider_Mobile_Phone__c}

Recipient Record ID
{!CaseId.Id}

Bob Poliquin 9
February 18, 2021
Like
0

3 replies

flow button on case object to send text message from messaging action

I have created a flow that should send a text message when a button is clicked. When i run a debug it works. When i go to create a new action button, the new flow does not show up where you would select the flow in the dropdown

The flow is an autoflow that should execute when i users clicks the button.
I have a get records element and a messaging action in the flow, but i'm not sure if this is correct for a button. When i tried creating a New Button (Not an Action) the button doesnt should up on the lightning page. Also I am not sure if i have this Flow setup correctly to use in a button. I would like some help with this if possible

User-added image

Bob Poliquin 9
January 28, 2021
Like
0

1 replies

Flow messaging action setup

I am looking for some help on a flow messaging action. I need to know if there is any information out there that shows me how to setup a messaging type of action. Step by step with maybe screenshots.

Bob Poliquin 9
January 27, 2021
Like
0

3 replies

add fault message that users can understand not “An unhandled fault has occurred in this flow”

I am trying to add a fault screen to my flow so users can see a readable message if they receive an error, but it is not working. I read this article, but it doesn't SHOW me how to set this up in my flow.
https://help.salesforce.com/articleView?id=sf.flow_build_logic_fault_usermsg.htm&type=5

User-added image

I'm not sure what I am doing wrong

Bob Poliquin 9
January 26, 2021
Like
0

SOLVED

2 replies

Apex Test Class No Code Coverage

I have a apex class that needs a test class for code coverage. I made an attempt to write a test class but when i run a test it has zero coverage. I would appreciate help if someone could help me with what i am missing.

The visualforce page just displays related record information from a custom object to the account record.

Class:

// Used on the account page updated 1-31-2020
Public Class VF_SiteServicePartnerAllController{
   private Account acc;
   public List<Site_Service_Partner__c> sspList {get;set;}
   
   public VF_SiteServicePartnerAllController(ApexPages.StandardController sp){
       acc = (Account)sp.getRecord();
       sspList = new List<Site_Service_Partner__c>();
       sspList = [SELECT Id,Name,Site_Account__c,Primary_Field_Contact__c,Service_Partner__c,
                  Service_Partner_Owner__c,Service_Partner_Owner_Mobile__c,Service_Partner_Owner_Email__c,
                  Primary_Field_Email__c,Primary_Field_Mobile__c,Service_Partner_Site_Status__c, 
                  Contracted_Services__c,Secondary_Field_Contact__c,Secondary_Field_Email__c,Secondary_Field_Mobile__c,
                  Service_Partner_Start_Date__c,Service_Partner_End_Date__c,Service_Partner_Main_Phone__c,Service_Line__c,Supported_Service_Lines__c FROM Site_Service_Partner__c WHERE Site_Account__c =: acc.Id AND Service_Line__c IN ('Land', 'Snow', 'Land;Snow','Janitorial','Land;Snow;Janitorial') AND Service_Partner_Site_Status__c = 'Active'];

    
    Set<Id> bidId = new  Set<Id>();  
    for(Site_Service_Partner__c bs:sspList){
       bidId.add(bs.Id);
    }
     
   }

Test Class:

@isTest
Private class VF_SiteServicePartnerAllControllerTest {
    @isTest
    static void VF_SiteServicePartnerAllControllerTestMethod() {
        
        Contact cnt = new Contact();
        cnt.FirstName = 'Bob';
        cnt.LastName = 'Smith';
        cnt.MobilePhone = '508-888-5678';
        
        insert cnt;
        
        
        Account a = new Account();
        a.Name = 'Test';
        a.Primary_Field_POC__c = cnt.Id;
        a.Primary_Field_POC_Cell__c = '508-888-5678';
        a.Primary_Field_POC_Email__c = 'bsmith@gmail.com';
        
        insert a;
        
        Site_Service_Partner__c ssp = new Site_Service_Partner__c();
        ssp.Service_Partner__c = 'Test';
        ssp.Site_Account__c = a.Id;
        ssp.Service_Line__c = 'Snow';
        ssp.Primary_Field_Contact__c = cnt.Id;
        ssp.Primary_Field_Mobile__c = '508-888-5678';
        ssp.Primary_Field_Email__c = 'bsmith@gmail.com';        
        ssp.Service_Partner_Site_Status__c = 'Active';
        ssp.Service_Partner_Start_Date__c = date.newInstance(2020, 11, 13);
        ssp.Service_Partner_End_Date__c = date.newInstance(2021, 11, 13);
        insert ssp;
        
        ApexPages.StandardController sc = new ApexPages.StandardController(a);
        VF_SiteServicePartnerAllController  testAcc = new VF_SiteServicePartnerAllController(sc);
        
    }
}

VF Page:

<apex:page standardController="Account"   extensions="VF_SiteServicePartnerAllController" lightningStylesheets="true"  >


<style>
      
          .ht{ height:0px;
    vertical-align:middle;
          
          }
              
   </style>
 
<apex:form > 
  <apex:pageBlock >
    <apex:pageBlockTable cellpadding="1" width="100%" columns="2" value="{!sspList}" var="item">

           <apex:column rendered="{!IF(item.Service_Partner_Site_Status__c = 'Active',true,false)}"  >
                 <apex:outputPanel rendered="{!CONTAINS(item.Service_Line__c, 'Land')}">
                 <apex:outputPanel rendered="{!IF(item.Service_Partner_Start_Date__c  != null,true,false)}">
                 <apex:outputField value="{!item.Supported_Service_Lines__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Assigned to Site</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Primary Contact</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Primary_Field_Contact__c}"/><br></br>
                <apex:outputLabel value=""><b>Primary Field  Cell</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Primary_Field_Mobile__c}"/><br></br>
                <apex:outputLabel value=""><b>Primary Field Email</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Primary_Field_Email__c}"/><br></br>
                <apex:outputLabel value=""><b>Secondary Contact</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Secondary_Field_Contact__c}"/><br></br>
                <apex:outputLabel value=""><b>Secondary Cell</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Secondary_Field_Mobile__c}"/><br></br>
                <apex:outputLabel ><b>Secondary Email</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Secondary_Field_Email__c}"/><br></br>
                <apex:outputLabel ><b>Latest Work Order</b></apex:outputLabel><br></br>
                <apex:outputField value="{!Account.Latest_Work_Order__c}"/><br></br>
                 <apex:outputLabel ><b>Latest Work Order Submitted</b></apex:outputLabel><br></br>
                <apex:outputField value="{!Account.Latest_Work_Order_Submitted__c}"/>
           </apex:outputPanel>
           </apex:outputPanel>
           </apex:column>
           
           <apex:column styleClass="ht" rendered="{!IF(item.Service_Partner_Site_Status__c = 'Active',true,false && CONTAINS(item.Service_Line__c, 'Land') )}" >
                <apex:outputPanel rendered="{!CONTAINS(item.Service_Line__c, 'Land')}">
                <apex:outputPanel rendered="{!IF(item.Service_Partner_Start_Date__c  != null,true,false)}">
                <apex:outputLabel ><b>Service Partner Owner</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Owner__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Owner Cell</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Owner_Mobile__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Main Phone</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Main_Phone__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Owner Email</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Owner_Email__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Provider Start Date</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Start_Date__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Provider End Date</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_End_Date__c}"/>
                </apex:outputPanel> 
           </apex:outputPanel> 
           </apex:column>

      </apex:pageBlockTable>

    </apex:pageBlock>

  </apex:form>

 </apex:page>

Bob Poliquin 9
November 13, 2020
Like
0

2 replies

Report to show with or without records I want to be able to report on Accounts that don't have a child record

For example: We have accounts and a child object Bids__c, with a field named Service Year. I want to create a report that shows accounts with and without those Bids filtering the Service Year field,

So if the account has Bids with a Service Year of "2021" Count it as 1 if no bids are found with "2021" then 0
How do I pull a report that shows either or?

Bob Poliquin 9
October 28, 2020
Like
0

6 replies

Community users can not see files

I am trying to allow my community users to see attached files to a custom object. When i log in as the user I see the related list but no files are visible.

I have made sure this setting is correct on the attached file.

User-added image

I'm not sure what else I need to do

Bob Poliquin 9
July 30, 2020
Like
0

SOLVED

11 replies

Flow wrapped in a lightning component using e.force:closeQuickAction

I have a flow wrapped in a lightning component for a global action.

The flow worked fine in the lightning component but the problem is the flow will run then go back to the start. I want the screen to disppear after the user clicks finish.

hen I added the e.force:closeQuickAction and click the global action the flow screen doesn't really open, but you can see it automatically close to the lower right hand corner of the computer screen. I'm not sure if I need to add something to my code below to only close the screen after the flow finishes but I'm not sure where the issue is with my code.

<aura:component implements="force:appHostable, flexipage:availableForAllPageTypes, flexipage:availableForRecordHome,force:lightningQuickAction"  >

<aura:handler name="init"  value="{!this}" action="{!c.init}" />
<lightning:flow aura:id="flowData" />
    <br/>
    
</aura:component>

({
init : function (component) {
// Find the component whose aura:id is "flowData"
var flow = component.find("flowData");
// In that component, start your flow. Reference the flow’s Unique Name.
flow.startFlow("New_IT_Support_Case");
    
    // Close the action panel
        var dismissActionPanel = $A.get("e.force:closeQuickAction");
        dismissActionPanel.fire();
  },
})

Bob Poliquin 9
April 21, 2020
Like
0

1 replies

Visualforce PDF pagnation

I am having an issue with my visualforce pdf code. I'm using a apex:repeat but what is happening is some of the records are spilling over to the next page. How would i fix this so this doesnt happen. Would I add a style tag to my visualforce code or add some type of pagenation code to the apex class. I'm not really sure how to do either. any help would be greatly appreciated
User-added image

Apex Code:

public with sharing class VF_PrintBidPDF {

private Account acc;
   public List<Bids_Sent__c> bidsList {get;set;}
   public Map<String,List<Site_Bid_Details__c>>  bidsMap {get;set;}
   public Map<String,List<Site_Bid_Details__c>>  sbidsMap {get;set;}
   public VF_PrintBidPDF(ApexPages.StandardController sc){
       acc = (Account)sc.getRecord();
       bidsList = new List<Bids_Sent__c>();
       bidsList = [SELECT Id,Add_to_Schedule_C__c,Customer__r.Service_Agreement_Verbiage__c,Site__r.Service_Agreement_Verbiage__c,Service_Agreement_Verbiage__c,Awarded_Date__c,Site__r.Customer_Location_ID__c,Service_Year__c,Site__r.Customer_Account__r.Name,Name,
        Site__r.Name,Customer__r.Name,Primary_Contact__r.FirstName,Site__r.BillingCity,Site__r.BillingState,Site__r.BillingStreet,Site__r.BillingPostalCode,Site_Customer_Name__c,Customer_Name__c,Contract_Start_Date__c,Contract_End_Date__c FROM Bids_Sent__c WHERE Awarded__c =: acc.Id AND Add_to_Schedule_C__c=true  ];
    
          Set<Id> bidId = new  Set<Id>();  
    for(Bids_Sent__c bs : bidsList){
       bidId.add(bs.Id);
}
     
          bidsMap = new Map<String,List<Site_Bid_Details__c>> ();
    for(Site_Bid_Details__c bd : [SELECT Id,IsSeasonal__c, Bid_Name__r.Name,Site__c,Contract_Start_Month__c,Site__r.Customer_Location_ID__c,Cost__c,Increment__c,
    Total__c,Price__c,Scope__c,Bid_Name__r.Service_Type__c,Number_of_Months__c,Retainer_Fee__c,Monthly_Payment__c,UOM__c,Month_Start_Number__c,Month_End_Number__c, Contract_End_Year__c,IsConEndYear__c,IsZone__c FROM Site_Bid_Details__c WHERE Bid_Name__c IN : bidId]){
        
      if(bidsMap.containsKey(bd.Bid_Name__r.Name)){
          System.debug('CONTAINS KEY: ' + bd.Bid_Name__r.Name);
          bidsMap.get(bd.Bid_Name__r.Name).add(bd);
    }  
              
      else { 
          System.debug('CREATE: ' + bd.Bid_Name__r.Name);
          bidsMap.put(bd.Bid_Name__r.Name,new List<Site_Bid_Details__c>{bd}); 
           }
           
    }
          sbidsMap = new Map<String,List<Site_Bid_Details__c>> ();
    for(Site_Bid_Details__c sbd : [SELECT Id,IsSeasonal__c, Bid_Name__r.Name,Site__c,Contract_Start_Month__c,Site__r.Customer_Location_ID__c,Cost__c,Customer__r.Contract_Month__c,Increment__c,Total__c,
    Price__c,Scope__c,Bid_Name__r.Service_Type__c,Number_of_Months__c,Retainer_Fee__c,Monthly_Payment__c,UOM__c,Month_Start_Number__c,Month_End_Number__c,Contract_End_Year__c,IsConEndYear__c,IsZone__c   FROM Site_Bid_Details__c WHERE Bid_Name__c IN : bidId AND IsSeasonal__c = true]){
        
      if(sbidsMap.containsKey(sbd.Bid_Name__r.Name)){
          System.debug('CONTAINS KEY: ' + sbd.Bid_Name__r.Name);
          sbidsMap.get(sbd.Bid_Name__r.Name).add(sbd);
    } 
      else { 
           System.debug('CREATE: ' + sbd.Bid_Name__r.Name);
           sbidsMap.put(sbd.Bid_Name__r.Name,new List<Site_Bid_Details__c>{sbd}); 
           }
        } 
    }
    
    public VF_PrintBidPDF(ApexPages.StandardSetController controller) {
    }
    
    public VF_PrintBidPDF(){
       String myGeneratedFileName = 'SalesforceScool.pdf';
       Apexpages.currentPage().getHeaders().put('content-disposition', 'attachment; filename='+myGeneratedFilename); 
    }

}

Snippet of VF Code

<div style="page-break-after:always;">
   
                <apex:repeat var="sd" value="{!bidsList}">
            
    <table align="center" width="100%" style="font-family: Arial, Helvetica, sans-serif;font-size:10px; text-align:center;"
               cellpadding="0">
               <apex:outputPanel layout="none" rendered="{!IF(sd.Add_to_Schedule_C__c=true  ,true,false)}" style="vertical-align:central;font-family:Times New Roman, Arial, Helvetica, sans-serif;font-size:10px; text-align:center;width:65%">
                   
                <tr>
                <td colspan="4" style="font-weight:bold ;font-family:Times New Roman; border-style:solid;font-size:10px; border-width:1px;
                border-color:#000000;padding:1px;text-align:center;background-color:#B4C6E7;">SERVICE AGREEMENT DESCRIPTION</td>
                </tr>
                
                <tr>
                <td width="100%" align="left" style="color: #000000;text-align:justify; border-style:solid; border-width:1px;
                border-color:#000000;font-style:normal; font-weight:normal;font-size:10px;padding:1px"><apex:outputPanel rendered="{!IF(sd.Add_to_Schedule_C__c=true  ,true,false)}"> {!sd.Service_Agreement_Verbiage__c}</apex:outputPanel> </td>
                </tr>
                </apex:outputPanel>
            
            </table>
            
    <table align="center" width="100%" style="font-family: Arial, Helvetica, sans-serif; font-size:10px;text-align:center;" cellpadding="0">
            
            <tr>
                <td colspan="4" style="font-weight:bold; border-style: solid; border-width:1px;
                border-color:#000000;padding:1px;background-color:#B4C6E7;font-family: Arial, Helvetica, sans-serif;font-size:10px;">
                 SERVICE LOCATIONS AND FEES
                </td>
            </tr>
        
    </table> 
                
    <table align="center" width="100%" style="font-family: Arial, Helvetica, sans-serif;  text-align:left;"
               cellpadding="4">
          
            <tr>
               
            <td width="100%"  align="center" style="color: #000000;text-align:center; border-style:solid; border-width:1px;
                border-color:#000000;font-style:normal; font-weight:bold;font-size:10px;padding:1px">(Extra) Rates Listed Below **Not to be performed except by Written Request from Case Snow Management**</td>
            </tr>
    </table>
                
           <table align="center" width="100%" style="font-family: Arial, Helvetica, sans-serif;font-size:10px; text-align:center;"
               cellpadding="0">
              
                 
                <apex:outputPanel layout="none" rendered="{!IF(sd.Add_to_Schedule_C__c=true  ,true,false)}" style="vertical-align:central;font-family:Times New Roman, Arial, Helvetica, sans-serif;font-size:10px; text-align:center;width:65%">
                   
                    <tr>
                       <td style="text-align:center;background-color:#0000FF;border:1px solid black;font-family:Times New Roman,Arial;font-size:12px;font-weight:bold;color:#ffffff; page-break-after:always" class="auto-style3">Site Name</td>
                        <td style="font-weight: bold;font-family: Times New Roman, Arial;font-size: 12px;border: 1px solid black;color: #ffffff;padding: 1px;text-align: center;background-color: #0000FF;page-break-after: always" class="auto-style3" ><apex:outputPanel rendered="{!IF(sd.Add_to_Schedule_C__c=true  ,true,false)}"> {!sd.Customer__r.Name }</apex:outputPanel> </td>
                       
                        <td style="text-align:center;background-color:#0000FF;border:1px solid black;font-family:Times New Roman,Arial;font-size:12px;font-weight:bold;color:#ffffff" class="auto-style3">Service Period</td>
                       <td style="font-weight:bold ;font-family:Times New Roman, Arial; font-size:12px;border:1px solid black;
                            color:#ffffff;padding:3px;text-align:center;background-color:#0000FF;page-break-after:always" class="auto-style3" ><apex:outputPanel rendered="{!IF(sd.Add_to_Schedule_C__c=true  ,true,false)}"> <apex:outputText value="{0, date, MMMM d','  yyyy}">
                        <apex:param value="{!sd.Contract_Start_Date__c}" /> </apex:outputText> - <apex:outputText value="{0, date, MMMM d','  yyyy}"><apex:param value="{!sd.Contract_End_Date__c}" /></apex:outputText>

                </apex:outputPanel></td>

                        <td style="text-align:center;background-color:#0000FF;border:1px solid black;font-family:Times New Roman, Arial;font-size:12px;font-weight:bold;color:#ffffff" class="auto-style3">Address</td>
                       <td style="font-weight:bold ;font-family:Times New Roman, Arial;font-size:12px; border:1px solid black;
                            color:#ffffff;padding:3px;text-align:center;background-color:#0000FF;page-break-after:always" class="auto-style3" ><apex:outputPanel rendered="{!IF(sd.Add_to_Schedule_C__c=true  ,true,false)}">{!sd.Site__r.BillingStreet}&nbsp;{!sd.Site__r.BillingCity}, {!sd.Site__r.BillingState} {!sd.Site__r.BillingPostalCode} </apex:outputPanel></td>

                    </tr>

                </apex:outputPanel>
               
                       <apex:repeat var="et" value="{!bidsMap[sd.Name] }" rendered="{!IF(sd.Add_to_Schedule_C__c=true  ,true,false)}"    >
    
                    <tr>
                        
                       <td style="text-align:center;background-color:#dce6f1;font-family:Times New Roman, Arial;font-size:10px;font-weight:bold;color:#000000;border:1px solid black;padding-left:7px">Service Type</td>
                       <td style="border: 1px solid black;text-align: center;font-family: Times New Roman,Arial;padding: 1px;" > {!et.Bid_Name__r.Service_Type__c}</td>
                       <td style="text-align:center;background-color:#dce6f1;border:1px solid black;font-family:Times New Roman, Arial;font-size:10px;font-weight:bold;color:#000000;padding:1px">Service Desciption</td>
                       <td style="border:1px solid black;text-align:center;text-align:center;font-family:Times New Roman,Arial;font-size:10px;padding:1px" >{!et.Scope__c}&nbsp;{!et.Increment__c}</td>
                       <td style="text-align:center;background-color:#dce6f1;border:1px solid black;font-family:Times New Roman, Arial;font-size:10px;font-weight:bold;color:#000000;padding:1px">Pricing Schedule</td>
                       <td style="border-bottom:solid;border:1px solid black;text-align:center;text-align:center;font-family:Times New Roman,Arial; font-size:10px" class="ctr"><apex:outputText value="{0, Number, Currency}"><apex:param value="{!et.Cost__c}" /> </apex:outputText></td>
                        
                   </tr>
               </apex:repeat>
               </table>
             </apex:repeat>
            
    <table align="center" width="100%" style="font-family: Arial, Helvetica, sans-serif;font-size:12px; text-align:center; padding-top:20px"
               cellpadding="0">
        <tr><td style="border:0px solid black;text-align:center;font-family:Times New Roman,Arial;padding:1px; padding-bottom:15px; width:50%">Case Snow Management, Inc.<br />(as "Contractor")</td><td style="border:0px solid black;text-align:center;font-family:Times New Roman,Arial;padding:1px;padding:1px;width:50%;padding-bottom:20px;">{!Account.Name} 
 <br />(as "Subcontractor")</td></tr>

        </table>
    <table align="center" width="100%" style="font-family: Arial, Helvetica, sans-serif;font-size:12px; text-align:left;"
               cellpadding="0">
        <tr>
          <td style="border:0px solid black;text-align:right;font-family:Times New Roman,Arial;padding:1px;width:25%;" >Signature:</td><td style="border:0px solid black;text-align:left;font-family:Times New Roman,Arial;padding:1px;color:#ffffff;width:20%;">\s2\</td><td style="border:0px solid black;text-align:right;font-family:Times New Roman,Arial;width:25%;">Signature:</td><td style="border:0px solid black;text-align:left;font-family:Times New Roman,Arial;padding:5px;color:#ffffff;width:25%;">\s1\</td>
        </tr>
         <tr>
            <td style="border:0px solid black;text-align:right;font-family:Times New Roman,Arial;padding:1px">Name:</td><td style="border:0px solid black;text-align:left;font-family:Times New Roman,Arial;padding:1px;color:#ffffff">\n2\</td><td style="border:0px solid black;text-align:right;font-family:Times New Roman,Arial;padding:2px" >Name:</td><td  style="border:0px solid black;text-align:left;font-family:Times New Roman,Arial;padding:5px;color:#ffffff">\n1\</td>
            
        </tr>
         <tr>
            <td style="border:0px solid black;text-align:right;font-family:Times New Roman,Arial;padding:1px" >Date:</td><td style="border:0px solid black;text-align:left;font-family:Times New Roman,Arial;padding:1px;color:#ffffff">\d2\</td><td style="border:0px solid black;text-align:right;font-family:Times New Roman,Arial;padding:2px" >Date:</td><td style="border:0px solid black;text-align:left;font-family:Times New Roman,Arial;padding:5px;color:#ffffff">\d1\</td>
        </tr>

          </table></div>

Bob Poliquin 9
April 10, 2020
Like
0

1 replies

Apex Class for Visualforce page to show child records of a child record

I am wondering if I can update my apex class to show child records of a child record from the account object.

I have a custom object Bids_Sent__c of an account standard object. The Bids_Sent__c object has a child object entitled Site_Bid_Details__c. That custom object has a child object entitled Payments__c.
My Apex Class below is updated to show Account with Bids_Sent__c ad Site_Bid_Detail__c records on my visualforce pdf. But it does not cover the new custom object Payment__c. I need this to show those child records to show monthly payments if the Site_Bid Detail__c record meets a certain criteria. I'm not sure how to add this to my current class or if this is possible.

If anyone could help me with this I would greatly appreciate it.

public with sharing class VF_PrintBidPDF {

private Account acc;
   public List<Bids_Sent__c> bidsList {get;set;}
   public Map<String,List<Site_Bid_Details__c>>  bidsMap {get;set;}
   public Map<String,List<Site_Bid_Details__c>>  sbidsMap {get;set;}
   public VF_PrintBidPDF(ApexPages.StandardController sc){
       acc = (Account)sc.getRecord();
       bidsList = new List<Bids_Sent__c>();
       bidsList = [SELECT Id,Add_to_Schedule_C__c,Customer__r.Service_Agreement_Verbiage__c,Site__r.Service_Agreement_Verbiage__c,Service_Agreement_Verbiage__c,Awarded_Date__c,Site__r.Customer_Location_ID__c,Service_Year__c,Site__r.Customer_Account__r.Name,Name,
        Site__r.Name,Customer__r.Name,Primary_Contact__r.FirstName,Site__r.BillingCity,Site__r.BillingState,Site__r.BillingStreet,Site__r.BillingPostalCode,Site_Customer_Name__c,Customer_Name__c,Contract_Start_Date__c,Contract_End_Date__c FROM Bids_Sent__c WHERE Awarded__c =: acc.Id AND Add_to_Schedule_C__c=true  ];
    
          Set<Id> bidId = new  Set<Id>();  
    for(Bids_Sent__c bs : bidsList){
       bidId.add(bs.Id);
}
     
          bidsMap = new Map<String,List<Site_Bid_Details__c>> ();
    for(Site_Bid_Details__c bd : [SELECT Id,IsSeasonal__c, Bid_Name__r.Name,Site__c,Contract_Start_Month__c,Site__r.Customer_Location_ID__c,Cost__c,Increment__c,
    Total__c,Price__c,Scope__c,Bid_Name__r.Service_Type__c,Number_of_Months__c,Retainer_Fee__c,Monthly_Payment__c,UOM__c,Month_Start_Number__c,Month_End_Number__c, Contract_End_Year__c,IsConEndYear__c,IsZone__c FROM Site_Bid_Details__c WHERE Bid_Name__c IN : bidId]){
        
      if(bidsMap.containsKey(bd.Bid_Name__r.Name)){
          System.debug('CONTAINS KEY: ' + bd.Bid_Name__r.Name);
          bidsMap.get(bd.Bid_Name__r.Name).add(bd);
    }  
              
      else { 
          System.debug('CREATE: ' + bd.Bid_Name__r.Name);
          bidsMap.put(bd.Bid_Name__r.Name,new List<Site_Bid_Details__c>{bd}); 
           }
           
    }
          sbidsMap = new Map<String,List<Site_Bid_Details__c>> ();
    for(Site_Bid_Details__c sbd : [SELECT Id,IsSeasonal__c, Bid_Name__r.Name,Site__c,Contract_Start_Month__c,Site__r.Customer_Location_ID__c,Cost__c,Customer__r.Contract_Month__c,Increment__c,Total__c,
    Price__c,Scope__c,Bid_Name__r.Service_Type__c,Number_of_Months__c,Retainer_Fee__c,Monthly_Payment__c,UOM__c,Month_Start_Number__c,Month_End_Number__c,Contract_End_Year__c,IsConEndYear__c,IsZone__c   FROM Site_Bid_Details__c WHERE Bid_Name__c IN : bidId AND IsSeasonal__c = true]){
        
      if(sbidsMap.containsKey(sbd.Bid_Name__r.Name)){
          System.debug('CONTAINS KEY: ' + sbd.Bid_Name__r.Name);
          sbidsMap.get(sbd.Bid_Name__r.Name).add(sbd);
    } 
      else { 
           System.debug('CREATE: ' + sbd.Bid_Name__r.Name);
           sbidsMap.put(sbd.Bid_Name__r.Name,new List<Site_Bid_Details__c>{sbd}); 
           }
        } 
    }
    
    public VF_PrintBidPDF(ApexPages.StandardSetController controller) {
    }
    
    public VF_PrintBidPDF(){
       String myGeneratedFileName = 'SalesforceScool.pdf';
       Apexpages.currentPage().getHeaders().put('content-disposition', 'attachment; filename='+myGeneratedFilename); 
    }

}

Bob Poliquin 9
April 06, 2020
Like
0

0 replies

Display monthly payments from record in visualforce pdf

I am trying to figure out if something is possible. I have a custom object that has a monthly payment field, number of months field, contract start date and end date fields.

what i need to do is display a monthly payment schedule on my visualforce pdf document But i not sure if this can be done. My screen shots below shows what I have built out but it is not dynamic at all.
When the Number of Months changes I need the VF document to display a payment for each month and the month of the payment as above.

Below is a snippet of my visualforce code, but as I said it is not dynamic. I am looking for a better way to make this dynamic especially with the months btween the start and end contract dates.

Any help would be greatly appreciated. A better solution earns a gold star

<apex:outputPanel layout="none" rendered="{!IF(sbd.Number_of_Months__c >= 1 && sbd.Contract_Start_Month__c= 1 && sbd.IsSeasonal__c=true  ,true,false)}">
         <tr>
            <td style="font-weight:bold;border:1px solid black;
                            color:#000000;padding:1px;text-align:center;background-color:#dce6f1;font-size:10px;font-family:Times New Roman,  Helvetica, sans-serif;">10-Jan-20</td>
                            
                            <td style="font-weight:normal; border:1px solid black;
                            color:#000000;padding:1px;text-align:center;background-color:#ffffff;font-size:10px;font-family:Times New Roman,  Helvetica, sans-serif;width:40px"><apex:outputText value="{0, Number, Currency}"><apex:param value="{!sbd.Monthly_Payment__c}" /> </apex:outputText></td>

            <td style="font-weight:normal;border:1px solid black;
                            color:#000000;padding:1px;text-align:center;background-color:#ffffff;font-size:10px;font-family:Times New Roman,  Helvetica, sans-serif;"></td>
        </tr>
            </apex:outputPanel>

            <apex:outputPanel layout="none" rendered="{!IF(sbd.Number_of_Months__c >= 2 && sbd.Contract_Start_Month__c= 2 && sbd.IsSeasonal__c=true  ,true,false)}">
        <tr>
            <td style="font-weight:bold ;font-size:10px;font-family: Times New Roman, Arial, Helvetica, sans-serif;border:1px solid black;
                            color:#000000;padding:1px;text-align:center;background-color:#dce6f1">10-Feb-20</td>
            <td style="font-weight:normal ;font-size:10px;font-family: Times New Roman, Arial, Helvetica, sans-serif; border:1px solid black;
                            color:#000000;padding:1px;text-align:center;background-color:#ffffff"><apex:outputText value="{0, Number, Currency}"><apex:param value="{!sbd.Monthly_Payment__c}" /> </apex:outputText></td>
            <td style="font-weight:normal ;font-size:10px;font-family: Times New Roman, Arial, Helvetica, sans-serif; border:1px solid black;
                            color:#000000;padding:1px;text-align:center;background-color:#ffffff"></td>
        </tr>
            </apex:outputPanel>

View of the fields on the record
User-added image

Bob Poliquin 9
March 27, 2020
Like
0

3 replies

Work Bench Error no package.xml found

I am trying to mass delete some old process builder workflows and I keep getting the following error.

User-added image

screenshot of the two files in my test folder
User-added image

<?xml version="1.0" encoding="UTF-8"?>
<Package xmlns="http://soap.sforce.com/2006/04/metadata">
<types>
<members>Service_Provider_Bid_Set_Bid_Notification_Information</members>
<members>Send_Mobile_Pin_SMS</members>
<members>Account_Sync_Service_Provider_Bids_Bid_Notification_Information</members>
<members>Procurement_Bid_Update_Vendor_s_Latest_Contract_End_Date</members>
<members>Work_Order_Set</members>
<name>Flow</name>
</types>Ï
</Package>

<?xml version="1.0" encoding="UTF-8"?>
<Package xmlns="http://soap.sforce.com/2006/04/metadata">    
  <version>50.0</version>
</Package>

Any help would be very greatly appreciated
Here is the link I used to try this way of doin git with no success
https://sfdccloudninja.com/flow/deleting-lots-of-old-flows-process-builders/

Bob Poliquin 9
March 24, 2021
Like
0

2 replies

Converting visualforce page to lightning web component

// Used on the account page updated 1-31-2020
Public Class VF_SiteServicePartnerAllController{
   private Account acc;
   public List<Site_Service_Partner__c> sspList {get;set;}
   
   public VF_SiteServicePartnerAllController(ApexPages.StandardController sp){
       acc = (Account)sp.getRecord();
       sspList = new List<Site_Service_Partner__c>();
       sspList = [SELECT Id,Name,Site_Account__c,Primary_Field_Contact__c,Service_Partner__c,
                  Service_Partner_Owner__c,Service_Partner_Owner_Mobile__c,Service_Partner_Owner_Email__c,
                  Primary_Field_Email__c,Primary_Field_Mobile__c,Service_Partner_Site_Status__c, 
                  Contracted_Services__c,Secondary_Field_Contact__c,Secondary_Field_Email__c,Secondary_Field_Mobile__c,
                  Service_Partner_Start_Date__c,Service_Partner_End_Date__c,Service_Partner_Main_Phone__c,Service_Line__c,Supported_Service_Lines__c FROM Site_Service_Partner__c WHERE Site_Account__c =: acc.Id AND Service_Line__c IN ('Land', 'Snow', 'Land;Snow','Janitorial','Land;Snow;Janitorial') AND Service_Partner_Site_Status__c = 'Active'];

    
    Set<Id> bidId = new  Set<Id>();  
    for(Site_Service_Partner__c bs:sspList){
       bidId.add(bs.Id);
    }
     
   }

}

VF Page:

<apex:page standardController="Account"   extensions="VF_SiteServicePartnerAllController" lightningStylesheets="true"  >


<style>
      
          .ht{ height:0px;
    vertical-align:middle;
          
          }
              
   </style>
 
<apex:form > 
  <apex:pageBlock >
    <apex:pageBlockTable cellpadding="1" width="100%" columns="2" value="{!sspList}" var="item">

           <apex:column rendered="{!IF(item.Service_Partner_Site_Status__c = 'Active',true,false)}"  >
                 <apex:outputPanel rendered="{!CONTAINS(item.Service_Line__c, 'Land')}">
                 <apex:outputPanel rendered="{!IF(item.Service_Partner_Start_Date__c  != null,true,false)}">
                 <apex:outputField value="{!item.Supported_Service_Lines__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Assigned to Site</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Primary Contact</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Primary_Field_Contact__c}"/><br></br>
                <apex:outputLabel value=""><b>Primary Field  Cell</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Primary_Field_Mobile__c}"/><br></br>
                <apex:outputLabel value=""><b>Primary Field Email</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Primary_Field_Email__c}"/><br></br>
                <apex:outputLabel value=""><b>Secondary Contact</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Secondary_Field_Contact__c}"/><br></br>
                <apex:outputLabel value=""><b>Secondary Cell</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Secondary_Field_Mobile__c}"/><br></br>
                <apex:outputLabel ><b>Secondary Email</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Secondary_Field_Email__c}"/><br></br>
                <apex:outputLabel ><b>Latest Work Order</b></apex:outputLabel><br></br>
                <apex:outputField value="{!Account.Latest_Work_Order__c}"/><br></br>
                 <apex:outputLabel ><b>Latest Work Order Submitted</b></apex:outputLabel><br></br>
                <apex:outputField value="{!Account.Latest_Work_Order_Submitted__c}"/>
           </apex:outputPanel>
           </apex:outputPanel>
           </apex:column>
           
           <apex:column styleClass="ht" rendered="{!IF(item.Service_Partner_Site_Status__c = 'Active',true,false && CONTAINS(item.Service_Line__c, 'Land') )}" >
                <apex:outputPanel rendered="{!CONTAINS(item.Service_Line__c, 'Land')}">
                <apex:outputPanel rendered="{!IF(item.Service_Partner_Start_Date__c  != null,true,false)}">
                <apex:outputLabel ><b>Service Partner Owner</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Owner__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Owner Cell</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Owner_Mobile__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Main Phone</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Main_Phone__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Owner Email</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Owner_Email__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Provider Start Date</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Start_Date__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Provider End Date</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_End_Date__c}"/>
                </apex:outputPanel> 
           </apex:outputPanel> 
           </apex:column>

      </apex:pageBlockTable>

    </apex:pageBlock>

  </apex:form>

 </apex:page>

Bob Poliquin 9
March 17, 2021
Like
0

3 replies

flow button on case object to send text message from messaging action

Bob Poliquin 9
January 28, 2021
Like
0

3 replies

add fault message that users can understand not “An unhandled fault has occurred in this flow”

I'm not sure what I am doing wrong

Bob Poliquin 9
January 26, 2021
Like
0

SOLVED

2 replies

Apex Test Class No Code Coverage

// Used on the account page updated 1-31-2020
Public Class VF_SiteServicePartnerAllController{
   private Account acc;
   public List<Site_Service_Partner__c> sspList {get;set;}
   
   public VF_SiteServicePartnerAllController(ApexPages.StandardController sp){
       acc = (Account)sp.getRecord();
       sspList = new List<Site_Service_Partner__c>();
       sspList = [SELECT Id,Name,Site_Account__c,Primary_Field_Contact__c,Service_Partner__c,
                  Service_Partner_Owner__c,Service_Partner_Owner_Mobile__c,Service_Partner_Owner_Email__c,
                  Primary_Field_Email__c,Primary_Field_Mobile__c,Service_Partner_Site_Status__c, 
                  Contracted_Services__c,Secondary_Field_Contact__c,Secondary_Field_Email__c,Secondary_Field_Mobile__c,
                  Service_Partner_Start_Date__c,Service_Partner_End_Date__c,Service_Partner_Main_Phone__c,Service_Line__c,Supported_Service_Lines__c FROM Site_Service_Partner__c WHERE Site_Account__c =: acc.Id AND Service_Line__c IN ('Land', 'Snow', 'Land;Snow','Janitorial','Land;Snow;Janitorial') AND Service_Partner_Site_Status__c = 'Active'];

    
    Set<Id> bidId = new  Set<Id>();  
    for(Site_Service_Partner__c bs:sspList){
       bidId.add(bs.Id);
    }
     
   }

Test Class:

@isTest
Private class VF_SiteServicePartnerAllControllerTest {
    @isTest
    static void VF_SiteServicePartnerAllControllerTestMethod() {
        
        Contact cnt = new Contact();
        cnt.FirstName = 'Bob';
        cnt.LastName = 'Smith';
        cnt.MobilePhone = '508-888-5678';
        
        insert cnt;
        
        
        Account a = new Account();
        a.Name = 'Test';
        a.Primary_Field_POC__c = cnt.Id;
        a.Primary_Field_POC_Cell__c = '508-888-5678';
        a.Primary_Field_POC_Email__c = 'bsmith@gmail.com';
        
        insert a;
        
        Site_Service_Partner__c ssp = new Site_Service_Partner__c();
        ssp.Service_Partner__c = 'Test';
        ssp.Site_Account__c = a.Id;
        ssp.Service_Line__c = 'Snow';
        ssp.Primary_Field_Contact__c = cnt.Id;
        ssp.Primary_Field_Mobile__c = '508-888-5678';
        ssp.Primary_Field_Email__c = 'bsmith@gmail.com';        
        ssp.Service_Partner_Site_Status__c = 'Active';
        ssp.Service_Partner_Start_Date__c = date.newInstance(2020, 11, 13);
        ssp.Service_Partner_End_Date__c = date.newInstance(2021, 11, 13);
        insert ssp;
        
        ApexPages.StandardController sc = new ApexPages.StandardController(a);
        VF_SiteServicePartnerAllController  testAcc = new VF_SiteServicePartnerAllController(sc);
        
    }
}

VF Page:

<apex:page standardController="Account"   extensions="VF_SiteServicePartnerAllController" lightningStylesheets="true"  >


<style>
      
          .ht{ height:0px;
    vertical-align:middle;
          
          }
              
   </style>
 
<apex:form > 
  <apex:pageBlock >
    <apex:pageBlockTable cellpadding="1" width="100%" columns="2" value="{!sspList}" var="item">

           <apex:column rendered="{!IF(item.Service_Partner_Site_Status__c = 'Active',true,false)}"  >
                 <apex:outputPanel rendered="{!CONTAINS(item.Service_Line__c, 'Land')}">
                 <apex:outputPanel rendered="{!IF(item.Service_Partner_Start_Date__c  != null,true,false)}">
                 <apex:outputField value="{!item.Supported_Service_Lines__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Assigned to Site</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Primary Contact</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Primary_Field_Contact__c}"/><br></br>
                <apex:outputLabel value=""><b>Primary Field  Cell</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Primary_Field_Mobile__c}"/><br></br>
                <apex:outputLabel value=""><b>Primary Field Email</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Primary_Field_Email__c}"/><br></br>
                <apex:outputLabel value=""><b>Secondary Contact</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Secondary_Field_Contact__c}"/><br></br>
                <apex:outputLabel value=""><b>Secondary Cell</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Secondary_Field_Mobile__c}"/><br></br>
                <apex:outputLabel ><b>Secondary Email</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Secondary_Field_Email__c}"/><br></br>
                <apex:outputLabel ><b>Latest Work Order</b></apex:outputLabel><br></br>
                <apex:outputField value="{!Account.Latest_Work_Order__c}"/><br></br>
                 <apex:outputLabel ><b>Latest Work Order Submitted</b></apex:outputLabel><br></br>
                <apex:outputField value="{!Account.Latest_Work_Order_Submitted__c}"/>
           </apex:outputPanel>
           </apex:outputPanel>
           </apex:column>
           
           <apex:column styleClass="ht" rendered="{!IF(item.Service_Partner_Site_Status__c = 'Active',true,false && CONTAINS(item.Service_Line__c, 'Land') )}" >
                <apex:outputPanel rendered="{!CONTAINS(item.Service_Line__c, 'Land')}">
                <apex:outputPanel rendered="{!IF(item.Service_Partner_Start_Date__c  != null,true,false)}">
                <apex:outputLabel ><b>Service Partner Owner</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Owner__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Owner Cell</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Owner_Mobile__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Main Phone</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Main_Phone__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Partner Owner Email</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Owner_Email__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Provider Start Date</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_Start_Date__c}"/><br></br>
                <apex:outputLabel value=""><b>Service Provider End Date</b></apex:outputLabel><br></br>
                <apex:outputField value="{!item.Service_Partner_End_Date__c}"/>
                </apex:outputPanel> 
           </apex:outputPanel> 
           </apex:column>

      </apex:pageBlockTable>

    </apex:pageBlock>

  </apex:form>

 </apex:page>

Bob Poliquin 9
November 13, 2020
Like
0

2 replies

Report to show with or without records I want to be able to report on Accounts that don't have a child record

Bob Poliquin 9
October 28, 2020
Like
0

6 replies

Community users can not see files

I'm not sure what else I need to do

Bob Poliquin 9
July 30, 2020
Like
0

SOLVED

11 replies

Flow wrapped in a lightning component using e.force:closeQuickAction

<aura:component implements="force:appHostable, flexipage:availableForAllPageTypes, flexipage:availableForRecordHome,force:lightningQuickAction"  >

<aura:handler name="init"  value="{!this}" action="{!c.init}" />
<lightning:flow aura:id="flowData" />
    <br/>
    
</aura:component>

({
init : function (component) {
// Find the component whose aura:id is "flowData"
var flow = component.find("flowData");
// In that component, start your flow. Reference the flow’s Unique Name.
flow.startFlow("New_IT_Support_Case");
    
    // Close the action panel
        var dismissActionPanel = $A.get("e.force:closeQuickAction");
        dismissActionPanel.fire();
  },
})

Bob Poliquin 9
April 21, 2020
Like
0