---
title: "Extract Scaffolding fields into Scaffolding report blocks"
canonical: "https://support.appfire.com/space/RFC/477333555/Extract%20Scaffolding%20fields%20into%20Scaffolding%20report%20blocks"
format: markdown
---
> Macro (aura-html)

The primary method for extracting Scaffolding data into a report is by adding one or more Scaffolding blocks to the report builder. Each Scaffolding block extracts data from a single Scaffolding field of a Field Group macro.

If you want a single report block to extract data from multiple fields, including Scaffolding fields, refer to [https://appfire.atlassian.net/wiki/spaces/RFC/pages/1903429123/Extracting+multiple+Scaffolding+fields+into+a+single+report+block?atlOrigin=eyJpIjoiNGUxMzAxMTUyMjM3NGYxZjk2NThlZDAxN2E3MmViYzUiLCJwIjoiYyJ9](https://appfire.atlassian.net/wiki/spaces/RFC/pages/1903429123/Extracting+multiple+Scaffolding+fields+into+a+single+report+block?atlOrigin=eyJpIjoiNGUxMzAxMTUyMjM3NGYxZjk2NThlZDAxN2E3MmViYzUiLCJwIjoiYyJ9).

## Scenario

Let's generate a report based on staff profile pages. In this tutorial, we'll show you how to create a report that extracts data from profile pages created using [Scaffolding.](https://appfire.atlassian.net/wiki/spaces/SCAFC)

We're interested in extracting four types of data from each profile - name, position, start date, and employee ID.

![image](media://f13adb69-1ec4-4e9d-aaac-1638d56731d3)

## Result

We will generate a report that looks like this:

![image](media://1db0bd29-370f-45ec-8eba-1dfdb73ace1c)

## Recipe

| Apps | Reporting for Confluence Cloud, Scaffolding for Confluence Cloud |
| --- | --- |
| Level | Intermediate |
| Estimated time | 20 minutes |

## Prerequisites

- All profile pages must use the same Scaffolding - Field Group macro name and field names. Ideally, your pages should have been created from a template or a live template.
- The Scaffolding - Field Group macro name and field names must be recognizable and legible to you. By default, Scaffolding does not use these names, so it just generates semi-random ones. You can edit these names in the Field Group macro editor.
- Verify that you plan to extract data from supported Scaffolding fields - Custom List, Date, Number, Paragraph, and Short Text.
- Verify that the Scaffolding integration is enabled. See [https://appfire.atlassian.net/wiki/spaces/RFC/pages/477333120](https://appfire.atlassian.net/wiki/spaces/RFC/pages/477333120).

## Steps

1. Compile a list of the Field Group macro name and field names used in profile pages. Edit any of these pages if necessary.
2. Take note of the *Field Group name* value used on the profile page. It is listed under the *Field Group settings*. In this example, the name is `profile_group`.
3. Take note of the field names for each field you are interested in. Click **Field settings** to expand it, then click each field on the right to note its *Field name *value. In the two examples shown below, the field names are `employee_name` and `employee_position,` respectively.
  
4. Create a new page for the report, give it a suitable title, and insert a **Reporting** macro.
5. In the *Reporting *macro editor, start with some simple CQL syntax and search for the profile pages you want to report on. For details about the CQL syntax, refer to [this page](https://developer.atlassian.com/server/confluence/advanced-searching-using-cql/?__hstc=72543820.3ed169511bff716da189ebd03c026c3b.1647412751898.1677642624510.1677648287722.71&__hssc=72543820.175.1677648287722&__hsfp=179215543) by Atlassian.  
The example below will match all pages with the label *profile_page*.
6. Click **Search** and confirm that your CQL syntax matches the profile pages.
7. In the *Report Builder* section, create the first column (leftmost column) of the report, which will contain the employee’s name.
  1. From the dropdown menu, select **Scaffolding** and click **Add**.
  2. Click **Block 0**.
  3. In the **Title box**, enter `Name`.
  4. From the **Field Group Name **dropdown menu, select the correct Field Group name. For this example, select **profile_group**.
  5. From the **Field Name **dropdown menu, select the field that matches the title. For this example, select **employee_name** and click **Update**.
8. Add the second column for the report, which will display employees' positions.
  1. From the dropdown menu, select **Scaffolding** and click **Add**.
  2. Click **Block 1**.
  3. In the **Title box**, enter `Position`.
  4. From the **Field Group Name **dropdown menu, select the correct Field Group name. For this example, select **profile_group**.
  5. From the **Field Name **dropdown menu, select the field that matches the title. For this example, select **employee_position** and click **Update**.
9. Repeat step 7 for the two remaining columns, `Start date` and `Employee ID`. Make sure you match the field to the title each time.
10. Keep the *Report Type*** **as *Table *(the default) and in the **Empty Report** box, enter some error text to appear if the report has no results. For this example, we'll enter `No matching profiles were found. Please try again later.` You can also see a preview of the report here.
11. **Save** your report and **Publish** the page.