Example: invoice PDF

Use the sample data below to understand how to get from a document (= template, here: DOCX in Microsoft Word) to a rendered report (= result, PDF in Ninox).

Understand the example

1. Create a database from the NINOX backup file from the sample data below.

2. Once the database is created, open the Invoice table, click any record, then click the Print icon.

3. View the 2 layouts:

   1. en_invoice_template -> refer to#option-a-without-a-custom-script

   2. en_invoice_template_without_JSON -> refer to #option-b-with-a-custom-script

4. Open Microsoft Word or another text editor to view the MS Word template A (Option A) and B (Option B).

   1. Depending on which template is used, you either work with or without a custom script.

5. In Ninox, select a layout, then click the Print icon. Select This record to download the final result, a rendered PDF report.

   1. Both MS Word templates A and B result in the same report. All roads lead to Rome. 😉

Note: For both layouts, we use a global function to correctly display currency.

Sample data

What	File format	EN	DE	Notes
MS Word template A	DOCX	https://share.ninox.com/5mtgtv7r0ff9x6eolgkurzr6a9tsylv79hty	https://share.ninox.com/15op5nm99s300xz39796awz7ewvwm5gxbdbn	no custom script needed, refer to Option A: without a custom script
MS Word template B	DOCX	https://share.ninox.com/jj0ie5x028c5v1qg9zjp6a1jimpfw314iwcl	https://share.ninox.com/opd2kpcewknu9eff75al3rdqongmlfm9jvxa	requires custom script, refer to Option B: with a custom script
rendered report	PDF	https://share.ninox.com/vamds328sxftmmfxx6326oq8ulve2ftqfqnx	https://share.ninox.com/fo8ak0v6onlbkr4hi5ixwtq0uevzp3h9iaun	watermark on PDF only appears in this demo
database	NINOX	https://share.ninox.com/61ao4kdcru7zwg51hytoy17byvj0sfffaw92	https://share.ninox.com/crox2usf4xh7foyh7nlmbxlhm3wsf4dy4r5v
custom script	JSON	https://share.ninox.com/j9pkx2y1ur3tsz8xrdtd0tfpwj4gr45ai55c	https://share.ninox.com/ct39234fxle0n7d6omh2s3298s2faip5ovqs
global function	JSON	https://share.ninox.com/h3fp9a48x7e780nmss6rx5ewq33s0ewthrcr	https://share.ninox.com/q32dhf2xu9xgv6qqtbupjeeea6sxooc3lc6p