Plumber user guide
Click here if you can't view this page properlyGo to appSupport
  • 👩‍🔧Plumber
  • Login to Plumber
  • 💼Popular Workflows
    • 🔀ALL WORKFLOWS
    • 🔔Notifications for FormSG
    • 📨FormSG and SMS integration
    • 📧Email acknowledgements to respondent
    • 🔥Get updated on urgent requests w/ Telegram
    • ☎️Keep mailing lists updated
    • ✔️Attendance taking
    • 🤝Dynamic response based on respondent selections
  • 📖User guides
    • Executions page
    • Pipe settings
    • Triggers
      • 📃FormSG
      • ⚙️Webhooks
      • 🕐Scheduler
    • Actions
      • 🔷Tiles
      • 📊M365 Excel (.gov.sg Agencies only)
      • ✉️LetterSG
      • 📪Email by Postman
      • ☎️SMS by Postman
      • 🗂️Vault workspace
      • #️⃣Slack
      • 💵PaySG
      • ☎️Telegram
      • 💼Toolbox
      • 🌉Custom API
  • Help!!!
    • ⁉️FAQ
    • 🧑Contact us
  • Legal
    • Terms of Use
    • Government Agency Privacy Statement
Powered by GitBook
On this page

Was this helpful?

  1. Popular Workflows

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.

PreviousKeep mailing lists updatedNextDynamic response based on respondent selections

Last updated 10 months ago

Was this helpful?

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!

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.

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.

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!

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

💼
✔️
here