Skip to main content

Dataset Placeholders in Reports

Updated over 3 weeks ago

You can output the values of the associated Datasets in an Excel, Word, or PDF Report.

The placeholders that can be used for Datasets are:

  1. {​{dataset-DATASET NAME}​} - this placeholder returns the value of the Dataset that was added in a Pin. Replace the words written in CAPITAL LETTERS with your filename. It is important to enter the exact name of the Dataset to retrieve a value, e.g., if your Dataset name is "Room List", use {​{dataset-raumliste}​}. - If your Dataset name contains spaces, please use - as a separator, for example, if your Dataset name is "Room List 1", use {​{dataset-raumliste-1}​}. - For example: The Dataset you have imported into docu tools is named "Craft List" or "Room Book", so the placeholders in the Template should be {​{dataset-Craft-List}​} or {​{dataset-Room-Book}​}.

  2. {​{all-datasets}​} - All Dataset links associated with a Pin will be displayed in the following format "Dataset Title: ID - Title". - For example: Craft: 08 - Electrical; Room Book: 2.008 - WC/Shower

  3. {​{alldatasets-all-info}​} - This placeholder allows you to Export all additional information of a Dataset link into your Report.

  4. {​{dataset-column-DATASETNAME--COLUMN NAME}​} - This placeholder only outputs the value of the specific column of the Dataset link. Note the double --!

  • For example for the following Dataset "Room List":

Room Number | Room Function | Room Size | Number of Doors| FEG12131 | Living Room | 24 | 4 |

In the Report, you can use the placeholder to specifically display only the value of the room size: {​{dataset-column-raumliste--raum-grösse}​} -> 24

Or the room function with: {​{dataset-column-raumliste--raumfunktion}​} -> Living Room

Did this answer your question?