How to insert groups of rows of data into the same document
Portant Workflow can group data within your source spreadsheet and place it into tables within your document. If your source spreadsheet contains multiple rows that should be grouped and inserted into one table then this is the feature for you. A good example use case is when you need to include multiple Google Sheet rows into aninvoice template or purchase order.
If you need to use this feature, your source spreadsheet will normally have rows that are grouped together like the example below.
You can easily place a data merge table into a document in a few easy steps:
Open the Google Sheet Source Block, then open the source field details by clicking the row in the source table. You can then select the data grouping option. This column needs to be unique (e.g. no columns which are named Invoice Number and Invoice No. with the same data in the column.
or you can select it here:
Add or open the document block and insert a table into the document (Insert > Table).
Then add the tags to the table. These are the tags of the data that will have multiple lines per document. Please ensure the tags are only added to one row.
Note: You can also apply data grouping when using Google Slides as a template within your workflows.
Optional: You can add header and footer rows to the top and bottom rows of the table and format as appropriate. The additional rows will only be placed immediately after the row with tags.
After you have set up the grouping and other document settings (e.g. Document name, pdf or email, etc) you can click the Create Documents button, and voila! invoices will be made, including tables with multiple lines from the spreadsheet source!
Feedback and feature suggestions
We created Portant in 2021, and the feedback we have received since then has been very helpful and greatly appreciated. If you have any feedback, please feel free to send us an email at [email protected] or use our contact form here: https://www.portant.co/support