Skip to main content

๐Ÿท๏ธ Tags for table fields

Updated this week

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

##table##

Exports all entries from the table field

Full table with all rows

Word & Excel

##table$visible##

Displays the table only if the field is visible (Kraaft condition)

Based on the display conditions of the report

Word

##table$filled##

Displays the table only if at least one entry has been filled in

Full table with all rows

Word

##table$text##

Exports the table content as plain text, without table formatting

All entered values listed in sequence

Word & Excel

##table__count##

Total number of entries

3

Word & Excel

##table__headers##

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

##table__1##

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

##table__2##

All data from the 2nd entry

Word: Mini-table of entry 2
Excel: one row with all info from entry 2

##table__1__sub_field_key##

Value of a specific sub-field in the 1st entry

Word & Excel: entered value for the sub-field


๐Ÿ”— Go further

Need help? Contact us via chat ๐Ÿ’ฌ

Did this answer your question?