Keep mailing lists updated

Automatically update your mailing lists whenever users change their information

Why you need this

• Keep your lists up to date automatically

In this use case, we want to automatically update our mailing list whenever someone changes their email! This pipe will also help create new email address automatically.

Update emailUpdate email

1. Trigger: FormSG

Connect the form you want to collect email addresses from

1. After logging into Plumber.gov.sg

2. Click "Template" on the left or "Use a template" on the homepage

3. Click "Update mailing lists"

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 "Officer has signed up mailing lists"

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 3 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 "Mobile number" under "New row data", click on the mobile number response from the drop down.

3. Click "Check step"

4. Click on "5. Condition" under "Officer has signed up for the mailing list".

5. Click "Check step".

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

7. Delete all the 2 dotted line variables

8. Replace them with the corresponding variables.

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.