[SalesForce] Serial Number in first column of HTML table in apex:repeat

I have created a VF email template with a HTML table. In table i have used apex:repeat to trace all child records. But i am not able to get serial number in first column of table.

Using solution provided by Tushar Sharma is showing serial number in PDF attachement but not in email table.

   <apex:repeat var="EW" value="{!relatedTo.Event_Workers__r}">
          <tr>
            <td></td>
            <td>{!EW.Opportunity__r.Name}</td>
            <td>{!EW.Hours_Worked__c}</td>
            <td>{!EW.Base_Pay__c}</td> 
            <td>{!EW.Overtime_Hours__c}</td>
            <td>{!EW.OT_Pay__c}</td>
            <td>{!EW.Service_Charge_Commision__c}</td>               
            <td>{!EW.C_Card_Tipes__c}</td> 
            <td>{!EW.Cash_Tips__c}</td> 
            <td>{!EW.Service_Charge_Tips__c}</td>                                
          </tr>
    </apex:repeat>

Best Answer

For this you need apex:variable in Your table. Using that you can make your own count variable

<apex:variable value="{!1}" var="count" />
 <apex:repeat var="EW" value="{!relatedTo.Event_Workers__r}">
          <tr>
            <td>{!count}
                <apex:variable value="{!count+1}" var="count" /> 
            </td>

Related Solutions

[SalesForce] Floating divs side-by-side that contain Apex:repeat without table

So your issue is that you want your apex:repeat elements to be rendered adjacent to each other instead of rendering the second repeat below the first one.

Firstly, if it is possible to use a wrapper class and fetch all your data so that you can use one apex:repeat to render it, then do this.

If not, you can use CSS to position two <div> elements next to each other.

So you can try something like this:

<apex:outputPanel layout="block">
    <apex:outputPanel layout="block">
    Your first apex:repeat here
    </apex:outputPanel> 
    <apex:outputPanel layout="block">
    Your second apex:repeat here
    </apex:outputPanel> 
</apex:outputPanel>

[SalesForce] How to create the fixed width table in VF Email Template or using html

You need to create a CSS and add styling to handle this.

<table class="fixed">
    <col width="20px" />
    <col width="30px" />
    <col width="40px" />
    <tr>
        <td>text</td>
        <td>text</td>
        <td>text</td>
    </tr>
</table>

and this will be your CSS

table.fixed { table-layout:fixed; }
table.fixed td { overflow: hidden; }
table {
            border-collapse: collapse;
        }

        table, tr, td {
            border: 1px solid black;
        }

So, for first table you have to define 4 columns with the fixed width, currently you are defining single column. Your code should look like this:

<table class="fixed">
    <col width="30px" />
    <col width="40px" />
     <col width="20px" />
     <col width="40px" />
    <tr>
        <td>Name</td><td>{!relatedTo.XXXX.Name}</td><td rowspan="3">Address</td><td rowspan="3">{!relatedTo.XXXX.XXXX}</td>
    </tr>
    <tr>
        <td>Phone</td><td>{!relatedTo.XXXX.XXXX}</td>
    </tr>
    <tr>
        <td>Email</td><td>{!relatedTo.XXX.XXXX}</td>
    </tr> 
</table>

Output

Best Answer

Related Solutions

[SalesForce] Floating divs side-by-side that contain Apex:repeat without table

[SalesForce] How to create the fixed width table in VF Email Template or using html

Related Topic