---
title: "Show maps based on addresses in Scaffolding fields"
canonical: "https://support.appfire.com/space/REPS/472917284/Show%20maps%20based%20on%20addresses%20in%20Scaffolding%20fields"
format: markdown
---
> Macro (aura-html)

## Scenario

This recipe shows you how to embed Google Maps in a Confluence page using address or coordinate data stored in Scaffolding.

This recipe also requires the third-party app [Embed Google Map](https://marketplace.atlassian.com/apps/1211256/embed-google-map?hosting=server&tab=overview&__hstc=72543820.d7052ee4aea9e240b3ac06782fa72f88.1556203371028.1584421875698.1584435559059.28&__hssc=72543820.20.1584435559059&__hsfp=1902021915). With the Embed Google Map macro you are able to create maps by entering an address in the **Address or coordinates** parameter.

Reporting is used to directly inject Scaffolding values into Embed Google Map's *Address or coordinates* parameter.

If you already have address or coordinate data stored in Scaffolding, this avoids having to manually enter the data into the *Address or coordinates* parameter.

## Result

![image](media://5f68f7ea-5a99-4e7a-b541-a619638fffee)

## Recipe

| Apps | Scaffolding Forms & Templates, Reporting for Confluence Data Center, Embed Google Map |
| --- | --- |
| Level | Advanced |
| Estimated time | 45 minutes |
| Macros | Local Reporter, Report Column, Report Info, Report Table |
| Suppliers | Scaffold Data Supplier |

## Storage format

You can copy and paste this code into the [Confluence Source Editor](https://appfire.atlassian.net/wiki/spaces/REPS/pages/472907841):

```
<p>
  <br />
</p>
<ac:structured-macro ac:macro-id="8930a668-41fa-49cf-bae2-fdf18093c947" ac:name="hidden-data" ac:schema-version="1">
  <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
  <ac:rich-text-body>
    <p class="auto-cursor-target">
      <br />
    </p>
    <ac:structured-macro ac:macro-id="56a8db81-f5c4-4d07-b270-8bb520df1142" ac:name="repeating-data" ac:schema-version="1">
      <ac:parameter ac:name="name">Addresses</ac:parameter>
      <ac:rich-text-body>
        <p class="auto-cursor-target">
          <br />
        </p>
        <table class="wrapped relative-table" style="width: 42.0696%;">
          <colgroup> <col style="width: 17.1824%;" /> <col style="width: 82.9561%;" /> </colgroup>
          <tbody>
            <tr>
              <th>Enter the location</th>
              <td>
                <div class="content-wrapper">
                  <p class="auto-cursor-target">
                    <br />
                  </p>
                  <ac:structured-macro ac:macro-id="8cec1332-3790-481d-a1c2-7def4f9669ce" ac:name="text-data" ac:schema-version="1">
                    <ac:parameter ac:name="name">address</ac:parameter>
                    <ac:parameter ac:name="content">text</ac:parameter>
                    <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                    <ac:rich-text-body>
                      <p>
                        <br />
                      </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <p class="auto-cursor-target">
                    <br />
                  </p>
                </div>
              </td>
            </tr>
          </tbody>
        </table>
        <p class="auto-cursor-target">
          <br />
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p class="auto-cursor-target">
      <br />
    </p>
  </ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
  <br />
</p>
<p>
  <br />
</p>
<p>
  <br />
</p>
<ac:structured-macro ac:macro-id="944be615-bf44-4722-8b90-296307bbb4a9" ac:name="report-table" ac:schema-version="1">
  <ac:rich-text-body>
    <p class="auto-cursor-target">
      <br />
    </p>
    <ac:structured-macro ac:macro-id="391be3bf-7fee-4a3f-b09a-483401d64922" ac:name="local-reporter" ac:schema-version="1">
      <ac:parameter ac:name="">data:Addresses</ac:parameter>
      <ac:rich-text-body>
        <p>
          <br />
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p class="auto-cursor-target">
      <br />
    </p>
    <ac:structured-macro ac:macro-id="99ffa5a3-e523-4a2c-9796-2729fa9b108c" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Address</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="df525212-aa9d-45cd-bdaf-2d451a9f6d86" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">data:address</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p class="auto-cursor-target">
      <br />
    </p>
    <ac:structured-macro ac:macro-id="41cfb2f8-92d4-4ee9-8973-f74eb5a56096" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="injected">true</ac:parameter>
      <ac:parameter ac:name="title">Map</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="3aa442e5-883c-4c04-854a-3ecf3eea858f" ac:name="google-map" ac:schema-version="1">
            <ac:parameter ac:name="border_style">none</ac:parameter>
            <ac:parameter ac:name="address">%data:address%</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p class="auto-cursor-target">
      <br />
    </p>
  </ac:rich-text-body>
</ac:structured-macro>

```

 

## Macro structure

You can recreate the example in the editor view:

![image](media://c56abcfb-f122-423c-b2d9-80968640aa33)

## Steps

1. Create a Hidden Data macro (from the Scaffolding app).
2. Within the Hidden Data macro, add a Repeating Data macro (from the Scaffolding app) with **Name:** `Addresses`.
3. Within the Repeating Data macro, add a 2 x 2 table.
4. In the first table column, enter the text `Enter the location`.
5. In the second table column, add a Text Data macro (from the Scaffolding app) with the following parameters:
  - **Name**: `address `
  - **Content Type**: `text`
6. Under the Hidden Data macro, add a Report Table macro.
7. Within the Report Table macro, add a Local Reporter macro with **Key**: `data:Addresses`.
8. Under the Local Reporter macro, add a Report Column macro with **Title**: *Address.*
9. Within the *Address *Report Column macro, add a Report Info macro within it with **Key**: `data:address`.
10. Under the *Address *Report Column macro, add another Report Column macro with the following parameters:
  - **Title**: `Map`
  - **Injected**: selected
11. Within the *Address *Report Column macro, add a Google Map macro with **Address or coordinates**: `%data:address%`.