✔️Attendance taking

Smoothen event management by automating and tracking turnout. Track the success of your event by automating the sending of post-event surveys to attendees.

Why you need this

• Track turnout for your event

• Track the success of your event so you can plan future events better

In this use case, we want to track the event turnout and send attendees a post-event survey or feedback form!

1. Trigger: FormSG

Connect the form you wish to receive notifications for

1. Under "Choose an app", select "FormSG" as the app.

2. Under "Choose an event", select "New form submission"

3. Click "Continue" button

1. Under "Choose connection", click "Add new connection", a modal will pop out.

1. Enter your Form URL and secret key and click

1. Click "Submit" and a "Your form is connected successfully." text would appear.

2. Choose how you want Plumber to deal with NRICs collected in your form responses. If your form does not collect NRICs select "Do nothing".

1. Click on 'Test step' button and mock data will appear. If you wish to test with actual data, you may submit a response to the live form and it'll appear the next time you click on "Test step".

1. A drop down will appear (as seen in the screenshot below) if the test is a success. Do note that mock data are being used in the example below.

You're done with setting up the FormSG integration! Please refer to the next tab for next step.

2. Action: Tiles (Find Single Row)

You must have a populated Tile table created with the list of potential attendees. To create a Tile table, you may refer here.

Update Tile table

1. Select "Find single row"

1. This action will allow you to find a single row and return based on the value you’ve insert.

1. Under “Select Tile”

2. Select the table you wish to connect

3. Under “Lookup conditions”

4. Select the column you wish to look up, in most cases, we recommend email address as an unique identifier

5. Select the conditions

6. Enter the value you wish to look up, this can something you’ve typed or a variable from previous actions.

1. Select “Yes (Returns most recent row)” .

2. Click "Test step"

3. Upon success execution, create a new action and refer to the next tab on this guide for the next step.

3. Action: Tiles (Update single row)

Updating attendees' attendance

This will allow you to update row, do note that you’ll require “Find single row” action before this action.

1. Select the table you wish to connect under “Select Tile”

2. Under “Row ID”, select the row id you wish to manipulate, row id can be retrieve with “Find single row” action.

3. Under “Row data”, select the column you need to edit and insert the value. Either key in the value or use variable retrieve from previous actions.

4. Under "Value" you may entered words like "Attended" ,"Yes" or "No" to indicate attendee's attendance and you're done!