# Attendance taking

{% hint style="success" %}
**Why you need this**

* Track turnout for your event
* Track the success of your event so you can plan future events better
  {% endhint %}

{% hint style="info" %}
This template automatically creates a Tile to capture attendance. For the flow to work, you need to upload a column labeled 'Email' containing email addresses
{% endhint %}

{% tabs %}
{% tab title="1. Trigger: FormSG" %}

## Connect to the form you wish to use for capturing attendance.

1. After logging into Plumber.gov.sg
2. Click "Template" on the left or "Use a template" on the homepage
3. Click "Attendance taking"
4. Click "Use template" on the top right
5. Click "New form response"
6. Click "Connect" at the right
7. Under "Choose connection", click the dropdown
8. Click "+ Add new form"
9. Under "Form URL", paste the form link that you wish to connect to
10. Under "Form Secret Key", paste the form's secret key
11. Click "Connect"
12. A message "Your form is connected successfully." will be shown
13. Click "Save and continue"
14. Under "1. New form response", a green dot will appear as an indication that the form has been connected successfully.

<figure><img src="https://guide.plumber.gov.sg/~gitbook/image?url=https%3A%2F%2F2212031742-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FXyVsBiX9OwOL1o9g5hLM%252Fuploads%252FC9XfJoUQzMgUVDvYkZ5W%252Fimage.png%3Falt%3Dmedia%26token%3D795822d6-2674-493a-b543-83aee4cc0170&#x26;width=768&#x26;dpr=4&#x26;quality=100&#x26;sign=a4be96cd&#x26;sv=2" alt=""><figcaption></figcaption></figure>

1. Click "Check step"
   {% endtab %}

{% tab title="2. Action: Find single row" %}

## Configuring "Find single row"

1. Click on "2. Find single row"&#x20;
2. Under "Lookup conditions", backspace the dotted line variable

<figure><img src="/files/zzpCJyf06Sq47UataAkT" alt=""><figcaption></figcaption></figure>

3. Replace the dotted line variable with a name response

<figure><img src="/files/Q2znx55Hbog54e4y4HOw" alt=""><figcaption></figcaption></figure>

4. Click "Check step", a green box will appear

<figure><img src="/files/4kX00zww0AuFdTtZHuU2" alt=""><figcaption></figcaption></figure>
{% endtab %}

{% tab title="3. Action: Configuring if-then" %}

## Configuring If-then

There will be 2 branches for you to configure in this use case.

1. Click on "3. Condition" under "New event attendance"
2. Click "Check step"
3. A green box would appear stating "Based on your sample data, it meets the conditions that you have set up and your pipe would have continued."
4. Click on "4. Create Row"
5. Delete all the dotted line variables
6. Click on the empty field
7. Insert the corresponding variables
8. For "Email" under "New row data", click on the email response from the drop down (see screenshot)

<figure><img src="/files/WykHCQOhDPuhZBUnP5qA" alt=""><figcaption></figcaption></figure>

1. For "Name" under "New row data", click on the name response from the drop down/
2. For "Attending?" under "New row data", click on the attendance response from the drop down.
3. Leave "Remarks" as is.&#x20;
4. Click "Check step"
5. Click on "5. Condition" under "Updating existing attendance".
6. Click "Check step".
7. A yellow box would appear stating "Based on your sample data, it meets the conditions that you have set up and your pipe **would not have** continued."&#x20;
8. Click "6. Update single row"
9. Click "Check step"
10. A green box would appear stating "updated, false".
11. Done! Click "Publish" at the top right and send a submission through your form to experience the flow.
    {% endtab %}
    {% endtabs %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://guide.plumber.gov.sg/all-workflows/attendance-taking.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.