Mapping Many Template Fields with One Related Table Field and Values from Different Records

If your template is mapped with a related table that has a one-to-many relationship with the main data source, you can specify which of the related records you want to use to render values in the generated PDF document. 

For example, you might need to generate an order summary in which you fill in the same parameters (for example, product name, number of items, and price) for different items purchased, with each item in a separate line. In this case, in line 1 of the “Items purchased” section of your document template, for each item parameter field, you configure the field to render the value from the first record returned from the related table; for line 2, you set all the fields to use values for the second record, and so on. You do it by entering the sequential record number in the Record index field.

Prerequisites: In a template, in the Data source field, select a table that has a one-to-many relationship with at least one other table, and then choose the related tables that you want to use, in the Related tables panel. For more information, see Mapping templates.

As a best practice, set field sorting to make sure which records from related tables are listed first to make sure the PDF document contains the correct values. For example, for an order summary document, you can sort the fields by the “Product Name” field.