Salesforce Developer Community

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
3

Questions
2

Replies

Apex:Repeat in email template.

So - HELP! I have a custom object (RFQ) that is a child object to the Opportunity object. I'm building a visualforce email template that lists the RFQs associated with the Opportunity. This is the version of the code I think is closest to being correct, but I'm not sure.

Things to note:
- I'm sure that the Child Relationship Name is RFQs (I've checked)
- I've tried the following options for value: {!RelatedTo.RFQs__r}, {!RelatedTo.RFQs__c}, {!RelatedTo.Opportunity.RFQs__r}, and {!RelatedTo.Opportunity.RFQs__c} and get some sort of Invalid Field Error

<messaging:emailTemplate subject="An RFQ Has Been Submitted" recipientType="User" relatedToType="Opportunity">

    <messaging:htmlEmailBody >
        <html>
            <body>
            <img src="https://c.cs91.content.force.com/servlet/servlet.FileDownload?file=0152F00000055mq" width="100" height="105"></img>
            <p>Dear {!recipient.name},</p>
            <p>Below are the open RFQs associated with the following Opportunity: {!relatedTo.name}.</p>
                 <p><strong><em>RFQs:</em></strong></p>
          <table border="0" >
            <tr > 
               <th>Action</th>
               <th>RFQ Name</th>
               <th>RFQ Record ID</th>
               <th>Date Requested</th>
               <th>Date Needed</th>
               <th>Sales Rep</th>
            </tr>
 <tr>
             <apex:repeat var="cx" value="{!RelatedTo.RFQ__r}">
             
                <td><a href="https://na57.salesforce.com/{!cx.id}">View</a> |  
                <a href="https://na57.salesforce.com/{!cx.id}/e">Edit</a></td>
                <td>{!cx.RFQs.name}</td>
                <td>{!cx.RFQs.Record_Id__c}</td>
                <td>{!cx.RFQs.Date_Requested__c}</td>
                <td>{!cx.RFQs.Date_Needed__c}</td>
                <td>{!cx.RFQs.SalesRep__c}</a></td>
  
            </apex:repeat> 
           </tr>              
          </table>
            <p/>
                <apex:outputLink value="impact://matthews/salesforce/forms/model%20admin">
                    View this opportunity in ImpactECS
                </apex:outputLink>

            </body>
        </html>
    </messaging:htmlEmailBody>

<messaging:plainTextEmailBody >
Congratulations!
This is your new Visualforce Email Template.
</messaging:plainTextEmailBody>
</messaging:emailTemplate>

3CMarketing
October 19, 2017
Like
0

1 replies

Is there a way to restore a sandbox?

I was attempting to rename a sandbox using refresh and all of the custom work I'd done on the original sandbox is gone. Is there a way to restore it? HELP!!

3CMarketing
October 19, 2017
Like
0

0 replies

Using the Public Knowledge Base with external documentation

I am trying to determine whether the public knowledge database will meet our needs and am hoping that someone can provide me with some guidance. I’m the SF administrator in our company, but I’m not a programmer so I need to get prepared for some of my conversations with our IT group to explain what SF can do.

1- What are the options for querying external systems (in our case, a web server that contains our html help and documentation files) to return search results for the PKB or does the data have to reside on SF servers? I’m guessing that you can leverage the API somehow to do this, but my programming knowledge is limited here.

2- Which editions allow you to customize the layout of the PKB on the website? We currently have professional edition. I can customize the page in FrontPage, but when I look at the page on the browser the standard SF PKB page appears. I’m referring to more than just the style sheets… I’m looking to reformat the entire screen layout.

Thanks for any advice or guidance you have!

3CMarketing
April 18, 2006
Like
0

1 replies

Apex:Repeat in email template.

<messaging:emailTemplate subject="An RFQ Has Been Submitted" recipientType="User" relatedToType="Opportunity">

    <messaging:htmlEmailBody >
        <html>
            <body>
            <img src="https://c.cs91.content.force.com/servlet/servlet.FileDownload?file=0152F00000055mq" width="100" height="105"></img>
            <p>Dear {!recipient.name},</p>
            <p>Below are the open RFQs associated with the following Opportunity: {!relatedTo.name}.</p>
                 <p><strong><em>RFQs:</em></strong></p>
          <table border="0" >
            <tr > 
               <th>Action</th>
               <th>RFQ Name</th>
               <th>RFQ Record ID</th>
               <th>Date Requested</th>
               <th>Date Needed</th>
               <th>Sales Rep</th>
            </tr>
 <tr>
             <apex:repeat var="cx" value="{!RelatedTo.RFQ__r}">
             
                <td><a href="https://na57.salesforce.com/{!cx.id}">View</a> |  
                <a href="https://na57.salesforce.com/{!cx.id}/e">Edit</a></td>
                <td>{!cx.RFQs.name}</td>
                <td>{!cx.RFQs.Record_Id__c}</td>
                <td>{!cx.RFQs.Date_Requested__c}</td>
                <td>{!cx.RFQs.Date_Needed__c}</td>
                <td>{!cx.RFQs.SalesRep__c}</a></td>
  
            </apex:repeat> 
           </tr>              
          </table>
            <p/>
                <apex:outputLink value="impact://matthews/salesforce/forms/model%20admin">
                    View this opportunity in ImpactECS
                </apex:outputLink>

            </body>
        </html>
    </messaging:htmlEmailBody>

<messaging:plainTextEmailBody >
Congratulations!
This is your new Visualforce Email Template.
</messaging:plainTextEmailBody>
</messaging:emailTemplate>

3CMarketing
October 19, 2017
Like
0

SOLVED

5 replies

What is sandbox ?

hi,

can anybody plz explain what is diffrence between develper edition and sandbox ?

Thanks,

daya

desidsk
May 29, 2010
Like
0