Want to export data from your table fields? Kraaft offers specific tags to automatically retrieve all entries in your Word and Excel export templates ๐
๐ Hold on: if you have never heard of tags or table fields, read these articles first before continuing ๐ช
โฎ๏ธ Quick reminder about tags!
Find all your tags directly in the report creation and editing tab on your computer. Each field has its own tag key โ and so does the table field! The sub-fields inside the table also have their own keys, automatically generated based on the name you gave them.
๐ก The table field tag corresponds to the name given to the table field in the report template โ exactly like regular tags.
1๏ธโฃ Export all entries at once โ ##table##
The simplest way to export your table field: use the table field tag. Kraaft automatically retrieves all entries and completed information, without any extra steps needed ๐
Tag | Meaning | Output | Available on |
| Exports all entries from the table field | Full table with all rows | Word & Excel |
| Displays the table only if the field is visible (Kraaft condition) | Based on the display conditions of the report | Word |
| Displays the table only if at least one entry has been filled in | Full table with all rows | Word |
| Exports the table content as plain text, without table formatting | All entered values listed in sequence | Word & Excel |
| Total number of entries | 3 | Word & Excel |
| Column headers | Field name, Responsible, Dateโฆ | Excel only |
๐ก IF/END-IF condition tags are compatible with the general ##table## tag โ you can therefore condition the display of the entire table.
๐ In a Word export
Each table entry appears as a mini-table:
The 1st column shows the sub-field name (e.g. Responsible, Date, Signature)
The 2nd column shows the value entered in the report
All entries are exported automatically, one after another ๐
๐ In an Excel export
Each entry corresponds to one row, and each sub-field to one column. You can format your template (bold, cell colorโฆ) โ the formatting is preserved in the export.
โ ๏ธ Column headers are not displayed automatically. Two options:
Option A โ Add column names manually in your template (with your own formatting)
Option B โ Use the
##table__headers##tag above the table tag โ headers update automatically if you rename a field in Kraaft ๐ก
โ ๏ธ Rows are inserted by overwriting content below. To avoid any issues, two recommended options:
Place the table at the end of the sheet, with no data below
Insert it on a dedicated sheet in your Excel file
2๏ธโฃ Target a specific entry or sub-field
Want to place data at a specific location in your template, or retrieve only certain information? Use the advanced tags.
The table field principle: your table field contains sub-fields (e.g. Name, Date, Signatureโฆ). These sub-fields are present in every entry โ meaning every new row added to the table. When exporting, you can therefore:
Target a full entry (e.g. all info from the 1st row added) โ
##table__1##Target a specific sub-field of a specific entry (e.g. only the signature from the 2nd row) โ
##table__2__signature##
The number follows the order of creation of entries in Kraaft.
Tag | Meaning | Output |
| All data from the 1st entry (all its sub-fields) | Word: Mini-table of entry 1 Excel: one row with all info from entry 1 |
| All data from the 2nd entry | Word: Mini-table of entry 2 |
| Value of a specific sub-field in the 1st entry | Word & Excel: entered value for the sub-field |
๐ Go further
๐จ Report tags โ all tags to customise your exports
๐จ Using conversation tags in a report โ pull conversation info into your export
