Generate Loan Repayment Schedule from Template

An example of how to fill tables with data and manage what happens when the table runs over the bottom of the page.

Includes examples of Date and Currency formatting.

 

Filling tables with data

The table starts at the bottom of the first page and, depending on the amount of data, may flow on to the second page.

By setting the Table Properties in the template, you can control whether the whole table should start on a new page, or perhaps just repeat the header row on the next page.

You can find more details on this behavior in our blog called: Tips for Creating a Reporting Template.

Formatting dates and numbers

This template makes use of the built-in dateFormat and numFormat functions.

Date format function

In this example, the dateFormat function looks like this:

{dateFormat(date,'EEEE, dd MMM yyyy','MMddyyyy')}

The first parameter is the data item you want to format.

The second is a format string specifying how you want the date to appear in the document.

The third is a format string specifying how the date is encoded in the variable.

So the date from the data: 08112019, is displayed in the generated document as: Tuesday, 11 Aug 2019.

Number format function

In this example, the numFormat function looks like this:

{numFormat(number,'$#,##0.00')}

The first parameter is the data item you want to format.

The second is a format string specifying how you want the number to appear in the document.

In the example, number is formatted so that it:

  • starts with a '$' sign
  • has an optional comma at the thousands
  • finishes with at least one number before the decimal point
  • has two numbers after the decimal point.

So the number from the data: 1200, is displayed in the generated document as: $1,200.00.

You can find more details on the formatting options in the relevant Docmosis Template Guide.

Feedback

Invalid Input

Sorry, this field will only accept letters and numbers, and not special characters, to limit spam. Please also consider contacting support@docmosis.com if you need help with this article.

Sorry, this field will only accept letters and numbers, and not special characters, to limit spam.

Invalid Input

Document Gallery

Docmosis showcases its template-based document generation capabilities through a gallery of downloadable PDF documents. The gallery features a mixture of real documents provided by customers as well as links to PDFs generated from example templates, desgined to illustrate the versatility of Docmosis.