Skip to main content

📤 Export reference list fields

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 💪

🏷️ 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

##collaborateur##

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

##collaborateur$horizontal##

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

##collaborateur$with(nom, metier)##

Shows only the listed sub-fields' columns, using their key (here nom and metier) — handy to keep just the essentials

##collaborateur$without(coordonnees)##

Shows all sub-fields except the ones whose key you list (here coordonnees)

##collaborateur__1__nom##

Targets a specific piece of data on the 1st selected entry: your report's Reference list field → the 1st entry selected in your report (the 1st team member) → a sub-field defined in your list (here the name)

##collaborateur__headers##

Automatically adds column headers (your sub-fields' names) — place it right above ##collaborateurs## in your Excel template. Headers update on their own if you rename a sub-field in Kraaft 💡 Excel only, doesn't work in Word

💡 The $with and $without tags are there to lighten the horizontal display when your list has a lot of fields 🎯 Use your reference list's sub-field keys (here nom, metier, coordonnees), found in your list's configuration 🔑

💡 Tip — get a data point without adding a Linked data field

  • Just need one specific piece of data on export? $with() isolates it (e.g. ##collaborateurs$with(nom)##), but the output stays in table mode, even reduced to a single column

  • Need plain text, no table? In single choice mode, ##collaborateurs__1__nom## is enough. In multiple choice mode, add a List linked data field instead: only that field guarantees plain text (with numbering if needed)

  • The Linked data field is also useful if you want to display this info directly in the filled-in report 🙌

🔗 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)

🧩 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

##presences##

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

##presences$horizontal##

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 Reference list or table field tag inside a table cell in your template: it can cause an export error. Keep them as plain text, outside your formatting tables 📝

  • The ##collaborateurs__headers## tag (column headers) only works in Excel exports, not in Word 📊

🔗 Go further

💬 Need help?

If you have any questions, Contact us!

Did this answer your question?