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, e.g., 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: Crafts: 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 specifically display only the value of the Room Size with the placeholder: #{{dataset-column-raumliste--raum-grösse}} -> 24

Or the Room Function with: #{{dataset-column-raumliste--raumfunktion}} ->Living Room

Did this answer your question?