Salesforce Developer Community

Vishal Biraris
NEWBIE
25 Points
Member since 2017

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
5

Questions
12

Replies

I am not able to get Values of fields from Custom as well as standard object while sending email triggered from process builder

Hello,

I am not able to get values of standard as well as Custom object fields used in my code (Code is provided below) in email,
I can see the values when i run using "Send test and verify merge fields" option within "Visualforce Email Template"

Currently I am triggering the template from the "Process Builder"

I am only getting Text from below visualforce code but not the values.

My code is :-

<messaging:emailTemplate subject="First payment reminder - Customer id : {!relatedTo.Exact_Online_Account_ID__c}" recipientType="Contact" relatedToType="Account" >

<messaging:htmlEmailBody >
<STYLE type="text/css">
TH {font-size: 11px; font-face: arial;background: #CCCCCC; border-width: 1; text-align: center }
TD {font-size: 11px; font-face: verdana }
TABLE {border: solid #CCCCCC; border-width: 1}
TR {border: solid #CCCCCC; border-width: 1}
</STYLE>


 Dear {!relatedTo.Name}, 
 

Our financial records show that we have not yet received funds for your subscription for the total amount {!relatedTo.Total_Outstanding_Amount__c} {!relatedTo.CurrencyIsoCode} 
 
We kindly ask you to pay each individual invoice using transfer of funds to our bank account within 5 business days of receiving this email. 

 
Your outstanding invoices: 

 
<table border="0" >
<tr>
<th align="right">Invoice Number ; </th>
<th align="right">Payment Due Date ; </th>
<th align="right">Payment Due Since ; </th>
<th align="right">Amount Due ; </th>
<th align="right">Currency ; </th>

</tr>

<apex:repeat var="cx" value="{!relatedTo.Invoices__r}" >

<apex:outputPanel rendered="{! If(cx.Outstanding_Amount_FC__c > 0,true,false) }">
<apex:outputPanel rendered="{! If(cx.Receivable_Is_Fully_Paid_del__c == 'false',true,false) }">

<tr>
<td align="right">{!cx.Invoice_Number__c} </td>

<td align="right">
<apex:outputText value="{0,date,dd'/'MMM'/'yyyy}">
<apex:param value="{!cx.Transaction_Due_Date_del__c}" />
</apex:outputText> 
</td>

<td align="right">{!TEXT(cx.Total_Due_Days__c)}  Days </td>

<td align="right"> 
<apex:outputText style="float:right" value="{0, number, ###,##0.00}">
<apex:param value="{!cx.Outstanding_Amount_FC__c}"/>
</apex:outputText> 
</td>

<td align="right">{!cx.Currency__c} </td>

</tr>

</apex:outputPanel>
</apex:outputPanel>

</apex:repeat>
</table>


 

Our bank details 
Payment reference :- {!relatedTo.Exact_Online_Account_ID__c} 
Please do not hesitate to contact us with questions. Thank you in advance for your cooperation. 

 
 
 

Best regards, 
Collection department 
BV Amsterdam, the Netherlands 

</messaging:htmlEmailBody>
</messaging:emailTemplate>

Vishal Biraris
September 06, 2017
Like
0

SOLVED

1 replies

How can we filter some of the records of Custom object in visualforce email template

Hello all,

As per below visualforce email template code, it's selecting all the Invoices of custom object "Invoices" into my email.
I would like to filter the invoice records based on the INVOICE object field "Receivable_Is_Fully_Paid_del__c",
That means i would like to select the Invoice records into email only when "Receivable_Is_Fully_Paid_del__c" field has value "false" AND "Outstanding_Amount_FC__c" field has value greater than 0.

Could you please help me on how we can add filter to handle this situation.

May be somethins i need to change on this line " <apex:repeat var="cx" value="{!relatedTo.Invoices__r}" >" of below code , but not sure wha exactly need to change.

My Visualforce working code is -

<messaging:emailTemplate subject="First payment reminder" recipientType="Contact" relatedToType="Account">



<messaging:htmlEmailBody >
<STYLE type="text/css">
TH {font-size: 11px; font-face: arial;background: #CCCCCC; border-width: 1; text-align: center }
TD {font-size: 11px; font-face: verdana }
TABLE {border: solid #CCCCCC; border-width: 1}
TR {border: solid #CCCCCC; border-width: 1}
</STYLE>


 Dear {!relatedTo.Name}, 
 

Our financial records show that -- subscription for the total amount {!relatedTo.CurrencyIsoCode} {!relatedTo.Total_Outstanding_Amount__c} 
 

 
<table border="0" >
<tr>
<th align="right">Invoice Number ; </th>
<th align="right">Payment Due Date ; </th>
<th align="right">Amount Due ; </th>
<th align="right">Currency ; </th>

</tr>

<apex:repeat var="cx" value="{!relatedTo.Invoices__r}" >

<tr>
<td align="right">{!cx.Invoice_Number__c} </td>

<td align="right">
<apex:outputText value="{0,date,dd'/'MMM'/'yyyy}">
<apex:param value="{!cx.Transaction_Due_Date_del__c}" />
</apex:outputText> 
</td>

<td align="right"> 
<apex:outputText style="float:right" value="{0, number, ###,##0.00}">
<apex:param value="{!cx.Outstanding_Amount_FC__c}"/>
</apex:outputText> 
</td>

<td align="right">{!cx.Currency__c} </td>

</tr>

</apex:repeat>
</table>


 

Our bank details: 
Payment reference: {!relatedTo.Exact_Online_Account_ID__c} 
Please do not hesitate to contact us with questions. Thank you in advance for your cooperation. 

 
 
 

Best regards, 
Collection department 
BV Amsterdam, the Netherlands 

</messaging:htmlEmailBody>
</messaging:emailTemplate>

Vishal Biraris
September 05, 2017
Like
0

SOLVED

1 replies

Is it possible to change the subject of visual force email based on some condiitons ?

Hello all,

We would like to change the subject ""First payment reminder" " as mentioned in below sample visulaforce code, based on the some condtions.
That means, If i send first reminder email then i am going to update the field "Total remider sent" value to 1,
Then later after checking other due dates conditions, ww would like to send another email but with different Subject i.e ". "Second payment reminder" and again update Total remider sent" value to 2.
can you please help how to handle such situation, This will help me to reuse same template for all the reminder;s, Invoice information will be picked up on run time, so no issues with that.

My Visualforce working code is -

<messaging:emailTemplate subject="First payment reminder" recipientType="Contact" relatedToType="Account">



<messaging:htmlEmailBody >
<STYLE type="text/css">
TH {font-size: 11px; font-face: arial;background: #CCCCCC; border-width: 1; text-align: center }
TD {font-size: 11px; font-face: verdana }
TABLE {border: solid #CCCCCC; border-width: 1}
TR {border: solid #CCCCCC; border-width: 1}
</STYLE>


 Dear {!relatedTo.Name}, 
 

Our financial records show that -- subscription for the total amount {!relatedTo.CurrencyIsoCode} {!relatedTo.Total_Outstanding_Amount__c} 
 

 
<table border="0" >
<tr>
<th align="right">Invoice Number ; </th>
<th align="right">Payment Due Date ; </th>
<th align="right">Amount Due ; </th>
<th align="right">Currency ; </th>

</tr>

<apex:repeat var="cx" value="{!relatedTo.Invoices__r}" >

<tr>
<td align="right">{!cx.Invoice_Number__c} </td>

<td align="right">
<apex:outputText value="{0,date,dd'/'MMM'/'yyyy}">
<apex:param value="{!cx.Transaction_Due_Date_del__c}" />
</apex:outputText> 
</td>

<td align="right"> 
<apex:outputText style="float:right" value="{0, number, ###,##0.00}">
<apex:param value="{!cx.Outstanding_Amount_FC__c}"/>
</apex:outputText> 
</td>

<td align="right">{!cx.Currency__c} </td>

</tr>

</apex:repeat>
</table>


 

Our bank details: 
Payment reference: {!relatedTo.Exact_Online_Account_ID__c} 
Please do not hesitate to contact us with questions. Thank you in advance for your cooperation. 

 
 
 

Best regards, 
Collection department 
BV Amsterdam, the Netherlands 

</messaging:htmlEmailBody>
</messaging:emailTemplate>

Vishal Biraris
September 04, 2017
Like
0

6 replies

How can we select the email address from Account fields for visualforce email template

Hello,

I need to send visualforce email address to the Address mentioned on Account's custom field "Billing_E_Mail__c"
Could you please suggest what changes are required in below code ?

My Visualforce working code is -

<messaging:emailTemplate subject="First payment reminder" recipientType="Contact" relatedToType="Account">



<messaging:htmlEmailBody >
<STYLE type="text/css">
TH {font-size: 11px; font-face: arial;background: #CCCCCC; border-width: 1; text-align: center }
TD {font-size: 11px; font-face: verdana }
TABLE {border: solid #CCCCCC; border-width: 1}
TR {border: solid #CCCCCC; border-width: 1}
</STYLE>


 Dear {!relatedTo.Name}, 
 

Our financial records show that -- subscription for the total amount {!relatedTo.CurrencyIsoCode} {!relatedTo.Total_Outstanding_Amount__c} 
 

 
<table border="0" >
<tr>
<th align="right">Invoice Number ; </th>
<th align="right">Payment Due Date ; </th>
<th align="right">Amount Due ; </th>
<th align="right">Currency ; </th>

</tr>

<apex:repeat var="cx" value="{!relatedTo.Invoices__r}" >

<tr>
<td align="right">{!cx.Invoice_Number__c} </td>

<td align="right">
<apex:outputText value="{0,date,dd'/'MMM'/'yyyy}">
<apex:param value="{!cx.Transaction_Due_Date_del__c}" />
</apex:outputText> 
</td>

<td align="right"> 
<apex:outputText style="float:right" value="{0, number, ###,##0.00}">
<apex:param value="{!cx.Outstanding_Amount_FC__c}"/>
</apex:outputText> 
</td>

<td align="right">{!cx.Currency__c} </td>

</tr>

</apex:repeat>
</table>


 

Our bank details: 
Payment reference: {!relatedTo.Exact_Online_Account_ID__c} 
Please do not hesitate to contact us with questions. Thank you in advance for your cooperation. 

 
 
 

Best regards, 
Collection department 
BV Amsterdam, the Netherlands 

</messaging:htmlEmailBody>
</messaging:emailTemplate>

Vishal Biraris
September 04, 2017
Like
0

SOLVED

12 replies

Help - Visual force email Template - Reference to Custom object

Hi all,I am trying to create VF email template. I have account object and inside account I have custom object "Invoices", I need help how we can get "Invoices” object fields into template.

My sample code is –
Messaging:emailTemplate subject="Dunning Reminder" recipientType="Contact" relatedToType="Invoice__c">


<messaging:htmlEmailBody >
 Dear {!relatedTo.Name} 
Our financial records show that we have not yet received funds for your Virtuagym subscription for the total amount of currency_and_total_amount. 
 <table>
 <tr>
 <th>Invoice Number</th>
 </tr>

 <apex:repeat var="cx" value="{!relatedTo.Account_invoice__r}" >
 <tr>
 <td>{!cx.Invoice_Number__c}</td>
 </tr>

 </apex:repeat>
 </table>

I am also getting error – “Error: Invalid field Invoice_Number__r for SObject Account”
Additional Info :-
- Invoice__c : Is API name of my Custom Object Invoices
- Account_invoice__c - Child Relationship Name of Invoices with Accounts

Vishal Biraris
August 31, 2017
Like
0

2 replies

I am not able to get Values of fields from Custom as well as standard object while sending email triggered from process builder

Vishal Biraris
September 06, 2017
Like
0

SOLVED

1 replies

How can we filter some of the records of Custom object in visualforce email template

Vishal Biraris
September 05, 2017
Like
0

6 replies

How can we select the email address from Account fields for visualforce email template

Vishal Biraris
September 04, 2017
Like
0

SOLVED

12 replies

Help - Visual force email Template - Reference to Custom object

Vishal Biraris
August 31, 2017
Like
0