You're using reference lists in your Kraaft reports and want to pull that data into your Word and Excel exports 📝? Here are all the tags you need!
⚠️ Never heard of tags before? Start with 🎨 Report tags before continuing 💪
🧭 3 types of tags — don't mix them up
A reference list in a report gives you access to 3 different export tags — each with a specific use:
The Reference list field's tag (e.g.
##collaborateur##) → exports a table with all the info for each selected entry 📋A tag targeting a specific sub-field (e.g.
##collaborateur__1__nom##) → instead of the full table, it targets a single sub-field of your list (herenom) on the selected entry, and displays it as plain text, no table — useful in single choice mode 📝 The sub-field's key (herenom) comes from your reference list's structure, found in the List tabThe List linked data field's tag (e.g.
##metier##) → key advantage: this field also shows up directly in the filled-in report 👀 It also gives you its own dedicated export tag, in plain text, which also works in multiple choice mode (with numbering) 🎯
The rest of the article details each of these 3 tags.
🏷️ Reference list field tag
Use your Reference list field's key to automatically export the selected entries as a table:
📌 Example: your sign-in report uses a Reference list field with the key collaborateur (auto-generated in your report), connected to your team members reference list 👷 Keys like nom or metier come from your reference list's own structure — find them in your list's configuration (List tab) 🗂️
Tag | Effect |
| A mini-table per selected entry, with all its related info (email, contact details, reference number...) 📋 If several entries are selected, you get one mini-table per entry, one after another in your reference list's order |
| Horizontal display (one row per entry) ⚠️ If your list has many sub-fields, that's a lot of columns on export: the table might get cut off or overflow the page |
| Shows only the listed sub-fields' columns (here |
| Shows all sub-fields except the ones whose key you list (here |
| Automatically adds column headers (your sub-fields' names) — place it right above |
🔗 These are almost the same tags as for a regular table field — find them all in detail in 🏷️ Tags for table fields 🔧
🏷️ List linked data field tag
The List linked data field targets a single, specific sub-field of your reference list (for example just the job, just the contact details, or just the name) 🎯 Simply use its key to export it anywhere in your template, not just where the Reference list field sits 📍
The export result depends on your source Reference list field's selection mode:
🔢 Multiple choice — each selected entry is numbered (1, 2, 3...), in your reference list's order. For example, if you selected 4 team members, you get their 4 jobs numbered 1 to 4, so you know which is which
1️⃣ Single choice — no numbering: the data shows up as-is, since only one entry is selected (for example the selected team member's name)
💡 🔑 Good to know: 2 levels of keys — don't mix them up
The field in the report (e.g.
collaborateur) — to the right of the field, in the report template editorThe sub-field in the list (e.g.
nom,metier,coordonnees) — Reports → Reference lists → your list → List tab
⚠️ $with() and $without() only take keys from the 2nd level (your list's sub-fields), never report field keys. Using a report field key in a $with()/$without() won't work.
📝 Plain text: display a single piece of info without a table
This is the most common need: no table, just one specific piece of info, displayed simply in your export.
In single choice mode — combine 2 keys in a single tag:
your Reference list field's key in the report (1st level)
the sub-field's key in your reference list (2nd level)
##collaborateur__1__nom## → displays only the name of the selected team member, in plain text, no table ✅
💡 This also works with your list's title field (the one shown in the dropdown menu): it also has its own key, found in the List tab, right alongside the other sub-fields. In our example, that's exactly the case for nom: ##collaborateur__1__nom## (used above) therefore displays the selected entry's title directly.
In multiple choice mode — there's no equivalent with __1__ (which only targets a single entry). For plain text with several selected entries, add a List linked data field instead: only that field guarantees plain text (with numbering 1, 2, 3... if there are several entries), and you can place it anywhere in your template, not just where the Reference list field sits 📍
🧩 Combined case: a reference list inside a table field
Let's take the example of a site report showing today's on-site attendance 👷 The table field presences holds one entry per person present, with a Reference list sub-field with the key collaborateur to select who's there (and, if needed, a List linked data sub-field to display related info).
Tag | Effect |
| A mini-table per entry, merging all the table field's sub-fields one after another: a regular date field, the selected entry/entries (the title) from your Reference list sub-field, the related linked data if you added one, and the table's other sub-fields |
| Same idea, horizontally (one row per entry) |
💡 Same rule as for a regular Linked data field: if your Reference list sub-field is in multiple choice mode, the selected entries (and their linked data) show up numbered (1, 2, 3...) in list order. In single choice mode, only one result shows up, with no numbering.
⚠️ 📄 Word vs Excel: 2 things to know
In Word, never place a tag that generates a table (
##collaborateur##,##collaborateur$horizontal##,##collaborateur$with(...)##,##collaborateur$without(...)##) inside a table cell in your template 📝 It creates a mini-table per entry → that makes a table inside a table, and the export fails with "A server error occurred". Keep these tags as plain text, outside your formatting tables.✅ Need to keep your layout in a table? Use
##collaborateur__1__nom##or a Linked data field: they output plain text and go into a cell without any issue.The
##collaborateur__headers##tag (column headers) only works in Excel exports, not in Word 📊
🔗 Go further
🏷️ Tags for table fields — all the tags to export your table fields
🔗 Use a reference list in a report — connect your reference list to a report template
💬 Need help?
If you have any questions, Contact us!