> For the complete documentation index, see [llms.txt](https://help.tahua.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.tahua.io/knowledge-base/administrator-help-guides/reports/how-to-pull-fields-from-different-forms-into-a-single-report.md).

# How to pull fields from different forms into a single report

## Data from different templates (forms) can be pulled into the same report with the use of tags

If a report needs to show data from multiple different forms, the field in question must be tagged. This way a field can be pulled from applications in multiple grants or multiple different milestones with different templates.

{% hint style="info" %}
You can zoom in to see the images better by holding Ctrl/Cmd and using the mouse scroll wheel.
{% endhint %}

## Create two grants and tag a field in each application template

{% stepper %}
{% step %}

### Example grant (first)

![](https://content.gitbook.com/content/49pNEQ4fXNtxv0yJ5jgn/blobs/iXrTO6PArIlIEqMhRIWX/image%20png%20Aug%2026%202024%2006%2013%2027%208110%20AM.png)
{% endstep %}

{% step %}

### A simple application form in the form builder

![](https://content.gitbook.com/content/49pNEQ4fXNtxv0yJ5jgn/blobs/08pjlw5nF95gIHOImW3P/image%20png%20Aug%2026%202024%2006%2014%2015%202969%20AM.png)
{% endstep %}

{% step %}

### Tag the amount requested field with the tag name "amount"

![](https://content.gitbook.com/content/49pNEQ4fXNtxv0yJ5jgn/blobs/QxRqMLcp236rYFXKS3Sh/image%20png%20Aug%2026%202024%2006%2015%2001%206747%20AM.png)
{% endstep %}

{% step %}

### Publish the grant

![](https://content.gitbook.com/content/49pNEQ4fXNtxv0yJ5jgn/blobs/Bkxd7e4eiGxN1sM9JnF8/image%20png%20Aug%2026%202024%2006%2015%2053%202112%20AM.png)
{% endstep %}

{% step %}

### Create a second grant

![](https://content.gitbook.com/content/49pNEQ4fXNtxv0yJ5jgn/blobs/mvk2SUAUKaVxKRE1oWTO/image%20png%20Aug%2026%202024%2006%2016%2015%204681%20AM.png)
{% endstep %}

{% step %}

### Tag the "production budget" field with the same "amount" tag

![](https://content.gitbook.com/content/49pNEQ4fXNtxv0yJ5jgn/blobs/Gco13ngfFpgRrigUsy14/image%20png%20Aug%2026%202024%2006%2016%2032%202670%20AM.png)
{% endstep %}

{% step %}

### Publish the second grant

![](https://content.gitbook.com/content/49pNEQ4fXNtxv0yJ5jgn/blobs/cdHDP8Y2P8M7sjxwBZoi/image%20png%20Aug%2026%202024%2006%2017%2017%205276%20AM.png)
{% endstep %}
{% endstepper %}

## Now for the applicant side

{% stepper %}
{% step %}

### View the two grants

![](https://content.gitbook.com/content/49pNEQ4fXNtxv0yJ5jgn/blobs/4ydhWvhfjxaHIrqP3KD6/image%20png%20Aug%2026%202024%2006%2018%2040%200440%20AM.png)
{% endstep %}

{% step %}

### Applicant submits an application requesting $6000

![](https://content.gitbook.com/content/49pNEQ4fXNtxv0yJ5jgn/blobs/yw7wMMW9MPwRfX5YNrKQ/image%20png%20Aug%2026%202024%2006%2019%2027%201650%20AM.png)
{% endstep %}

{% step %}

### In the movie grant the applicant sets a production budget of $48,000

![](https://content.gitbook.com/content/49pNEQ4fXNtxv0yJ5jgn/blobs/E0V19wuUfweKhLQEBfYf/image%20png%20Aug%2026%202024%2006%2020%2035%200647%20AM.png)
{% endstep %}
{% endstepper %}

## The Admin creates a report showing data from different templates

{% stepper %}
{% step %}

### Select Data Reports

![](https://content.gitbook.com/content/49pNEQ4fXNtxv0yJ5jgn/blobs/y1mbOigTU8Ypo0eFqqew/image%20png%20Aug%2026%202024%2006%2022%2001%200776%20AM.png)
{% endstep %}

{% step %}

### Create a Data Table

![](https://content.gitbook.com/content/49pNEQ4fXNtxv0yJ5jgn/blobs/06mXKWnEEzo3swYj2iHH/image%20png%20Aug%2026%202024%2006%2022%2038%203862%20AM.png)
{% endstep %}

{% step %}

### Select the type of data — Applications

![](https://content.gitbook.com/content/49pNEQ4fXNtxv0yJ5jgn/blobs/MRakimGVgZMkce9FfWTA/image%20png%20Aug%2026%202024%2006%2022%2052%204512%20AM.png)
{% endstep %}

{% step %}

### Select the tagged field as one of the columns

![](https://content.gitbook.com/content/49pNEQ4fXNtxv0yJ5jgn/blobs/WzgYdlXt1rceeWWRnF0y/image%20png%20Aug%2026%202024%2006%2023%2046%203639%20AM.png)
{% endstep %}

{% step %}

### Fill in names for the report and data table, and see the combined data

![](https://content.gitbook.com/content/49pNEQ4fXNtxv0yJ5jgn/blobs/CKFtFRxqX2XDEE11mjJ2/image%20png%20Aug%2026%202024%2006%2024%2029%209398%20AM.png)
{% endstep %}
{% endstepper %}

It's also possible to combine data from two different data tables. For details on that, see this tutorial:

[How to combine assessments with different templates into a single report](/knowledge-base/administrator-help-guides/assessments/assessment-reporting/how-to-combine-assessments-with-different-templates-into-a-single-report.md)