PDF {{#each Filtering Possible?

[dodom2]

Does anyone know if its possible to filter records that match a certain criteria when using <!-- {{#each function in PDF templates?

[telecastg]

You could embed"{{#if}} or {{lookup}} statements inside the {{#each}} loop or develop your own handlebars helper.

https://handlebarsjs.com/guide/builtin-helpers.html#each

https://handlebarsjs.com/guide/block-helpers.html#basic-blocks

[yuri]

Custom helpers for the back-end are implemented this way. https://docs.espocrm.com/development...custom-helper/

If can just put an {{#if}} block inside your {{#each}} to filter needed values.

[espcrm]

It certainly is; please read this:

I couldn't find where I original posted this but I just copy it and paste it from my template.

https://forum.espocrm.com/forum/general/54706-learning-espocrm-and-design?p=86742#post86742

[dodom2]

Thank you espcrm the below from your post helped me. Here's my full code of my template this helps anyone else. I used this for our company budget tool.



<p style="text-align: center; "><b><span style="font-size: 18px;"><font color="#000000">{{name}}</font></span><br></b></p>
<font color="#000000" style=""><b>Expenses</b></font><br><table border="0.5pt" cellpadding="2" class="table table-bordered">
<tbody>
<tr>
<th width="8%" style="background-color: rgb(54,54,53); color: #ffffff;" align="left"><b>Line #</b></th>
<th width="35%" style="background-color: rgb(54,54,53); color: #ffffff;" align="left"><b>Budget Item</b></th>
<th width="8%" style="background-color: rgb(54,54,53); color: #ffffff;" align="left"><b>Type</b></th>
<th width="12%" style="background-color: rgb(54,54,53); color: #ffffff;" align="left"><b>$ Budgeted</b></th>
<th width="12%" style="text-align: right; background-color: rgb(54, 54, 53); color: rgb(255, 255, 255);" align="left"><b>$ Used</b></th>
<th width="12%" style="text-align: right; background-color: rgb(54, 54, 53); color: rgb(255, 255, 255);" align="left"><b>$ Available</b></th>
<th width="12%" style="text-align: right; background-color: rgb(54, 54, 53); color: rgb(255, 255, 255);" align="left"><b>% Used</b></th>
</tr>
<!-- {{#each budgetsItems}}{{#ifEqual budgetItemType "Expense"}} --> <tr>
<td>{{line}}</td>
<td>{{name}}</td>
<td>{{budgetItemType}}</td>
<td>${{totalBudgetedAmount}}</td>
<td align="right">${{amountUsed}}</td>
<td align="right">${{amountAvailable}}</td>
<td align="right">{{percentageUsed}}%</td>
</tr>
<!-- {{/ifEqual}}{{/each}} --> <tr>
<td><b style="background-color: rgb(255, 255, 255);"></b></td>
<td><br></td><td><b>Totals<br></b></td><td align="right"><b>${{totalAmountBudgeted}}<br></b></td><td align="right"><b>${{amountUsed}}</b></td><td align="right"><b>${{amountAvailable}}</b></td><td align="right"><b>{{percentageUsed}}%<br></b></td></tr></tbody>
</table>
<p><br></p>


<font color="#000000" style=""><b>Income</b></font><br><table border="0.5pt" cellpadding="2" class="table table-bordered">
<tbody>
<tr>
<th width="8%" style="background-color: rgb(54,54,53); color: #ffffff;" align="left"><b>Line #</b></th>
<th width="35%" style="background-color: rgb(54,54,53); color: #ffffff;" align="left"><b>Budget Item</b></th>
<th width="8%" style="background-color: rgb(54,54,53); color: #ffffff;" align="left"><b>Type</b></th>
<th width="12%" style="background-color: rgb(54,54,53); color: #ffffff;" align="left"><b>$ Budgeted</b></th>
<th width="12%" style="text-align: right; background-color: rgb(54, 54, 53); color: rgb(255, 255, 255);" align="left"><b>$ Used</b></th>
<th width="12%" style="text-align: right; background-color: rgb(54, 54, 53); color: rgb(255, 255, 255);" align="left"><b>$ Available</b></th>
<th width="12%" style="text-align: right; background-color: rgb(54, 54, 53); color: rgb(255, 255, 255);" align="left"><b>% Used</b></th>
</tr>
<!-- {{#each budgetsItems}}{{#ifEqual budgetItemType "Income"}} --> <tr>
<td>{{line}}</td>
<td>{{name}}</td>
<td>{{budgetItemType}}</td>
<td>${{totalBudgetedAmount}}</td>
<td align="right">${{amountUsed}}</td>
<td align="right">${{amountAvailable}}</td>
<td align="right">{{percentageUsed}}%</td>
</tr>
<!-- {{/ifEqual}}{{/each}} --> <tr>
<td><b style="background-color: rgb(255, 255, 255);"></b></td>
<td><br></td><td><b>Totals<br></b></td><td align="right"><b>${{totalAmountBudgeted}}<br></b></td><td align="right"><b>${{amountUsed}}</b></td><td align="right"><b>${{amountAvailable}}</b></td><td align="right"><b>{{percentageUsed}}%<br></b></td></tr></tbody>
</table>
<p><br></p>

[dodom2]

Do you know if there is a sum feature to sum only records displayed on the filtered table? I cant seem to locate anything that allows this but would like to verify

[espcrm]

I don't think you can with PDF Template for Sum Related Records. You certainly can do Formula to do that though. I recently made a post somewhere I call "Accounting" that make use of SumRelated formula.

---

PS: Pretty good looking design