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

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

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.

1. Click "Check step"

2. Action: Find single row

Configuring "Find single row"

1. Click on "2. Find single row"

2. Under "Lookup conditions", backspace the dotted line variable

1. Replace the dotted line variable with a name response

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

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)

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.

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."

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.